use proc sql to merge multiple dataset

[Bal23]

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

[Loko · Accepted solution]

Hello,

There is also a set option - INDSNAME which may help

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

contributing_tbl=bse;
run;

[Astounding]

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.

[Bal23]

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