DATA Step, Macro, Functions and more

use proc sql to merge multiple dataset

Accepted Solution Solved
Reply
Super Contributor
Posts: 345
Accepted Solution

use proc sql to merge multiple dataset

I need to merge 7 datasets, monday, tuesday, wed, thur, friday, sat, and sun.

 

Use data set step is easy but I want to create a variable that I can identify whether those are from the dataset monday, or from sat, or from other dataset/

 

therefore, I am thinking to use "coalesce"

but I usually only merge two datasets, and never tried to merge seven together once.

 

the requriment is,

1) merge 7 at one time

2) create an index to identify where it is from, so in case there are ids same from monday and tue, I can still identify by looking at the index id.

any advice?

Thanks

 

 


Accepted Solutions
Solution
‎07-05-2016 04:28 PM
Super Contributor
Posts: 308

Re: use proc sql to merge multiple dataset

Hello,

 

There is also a set option - INDSNAME which may help

data want;
set sashelp.class sashelp.cars INDSNAME=bse;

contributing_tbl=bse;
run;

View solution in original post


All Replies
Solution
‎07-05-2016 04:28 PM
Super Contributor
Posts: 308

Re: use proc sql to merge multiple dataset

Hello,

 

There is also a set option - INDSNAME which may help

data want;
set sashelp.class sashelp.cars INDSNAME=bse;

contributing_tbl=bse;
run;
Super User
Posts: 5,518

Re: use proc sql to merge multiple dataset

[ Edited ]

Here's a recent question that has a viable approach:

 

https://communities.sas.com/t5/Base-SAS-Programming/Passing-a-SQL-Query-into-a-Macro/m-p/281086#M569...

 

That's assuming that MERGE means a SAS MERGE and not some other combination.

Super Contributor
Posts: 345

Re: use proc sql to merge multiple dataset

Posted in reply to Astounding

Thanks. Can you suggest an option with sql, since they are very large datasets?

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 380 views
  • 1 like
  • 3 in conversation