SAS Tutorial | Merging Data Sets in SAS using SQL

Показать описание

In this SAS How To Tutorial, Anna Yarbrough shows an example of merging data sets in SAS using PROC SQL. Data can be stored in separate tables to avoid creating large data sets with lots of redundancy. When data is stored in separate tables, you often need to be able to bring those tables together to create reports and answer business questions. Joining tables enables you to select data from multiple tables as if the data were contained in on table. Joins do not alter the original tables.

This SAS tutorial covers PROC SQL joins in SAS with examples. Anna discusses why you need joining and uses sample data to show you how to accomplish this common task.

Learn more about SAS Software

SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS

ABOUT SAS
SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

CONNECT WITH SAS

Рекомендации по теме

Комментарии

Mesmerizing art of teaching. Love from India 🇮🇳

deepakkumaar

Love it, thanks for the video. Where can I buy full series of your videos? I am SAS beginner I would like to have them for personal use. Thanks.

anvarisamukhamedov

Which technique (Data Step or proc sql) would you say is more efficient when joining very large ( millions/billions record with 1000s of column) tables?

sumanlama

Hi Anna, it was a great explanation, I have learned it with ease. I have a question here - Your video taught join using one common variable, what if i have more than 2 common variables to use to complete join using PROC SQL? If you could give with an example would of great help. Thank you in advance.

jitendarreddy

What if I need to merge a dataset with another dataset instead of with Anna? How do I do that?

jensbpunkt

Hi Anna,

I have a question.

Is it possible to zip .xlsx/.xls (with multiple sheets inside them) files through sas??

harimanda

Bom dia. Tudo bem? Fiz um programa utilizando inner join e funcionou perfeitamente, porém quando eu coloco a importação para ser através de um prompt a leitura dos arquivos é feita corretamente, mas quando solicito para imprimir uma das tabelas totalmente com o comando *, aparece um erro. Saberia me dizer se preciso utilizar outro comando nesse caso?

GuilhermeGoncalves-ssmf

Vunderful video. Check out some of Bill Jellen's videos on Excel. I love the format that he uses for teaching he jumps right into it...Nothing extraneous.. What he's trying to tackle, and then he does it.

BeerMonies

I am looking for update and joins in proc SQL i.e updating the columns of one table by joining it with other table in proc SQL...can you help?

mayanksingh

Well explained in a simple way!! Thank you !! could you please assist me with the below query? what is the use of outer union corr here in this query?

proc sql;
select * from sasuser.admit
outer union corr/*what is this significant?*/
select sum(fee) as fee from sasuser.admit;
quit;

please guide?

naveensandilya