topic use proc sql to merge multiple dataset in SAS Programming

use proc sql to merge multiple dataset

Bal23 — Tue, 05 Jul 2016 13:59:31 GMT

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

Re: use proc sql to merge multiple dataset

Loko — Tue, 05 Jul 2016 14:15:59 GMT

Hello,

There is also a set option - INDSNAME which may help

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

contributing_tbl=bse;
run;

Re: use proc sql to merge multiple dataset

Astounding — Tue, 05 Jul 2016 14:27:50 GMT

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#M56930

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

Re: use proc sql to merge multiple dataset

Bal23 — Tue, 05 Jul 2016 14:43:45 GMT

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