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
Hello,
There is also a set option - INDSNAME which may help
data want;
set sashelp.class sashelp.cars INDSNAME=bse;
contributing_tbl=bse;
run;
Hello,
There is also a set option - INDSNAME which may help
data want;
set sashelp.class sashelp.cars INDSNAME=bse;
contributing_tbl=bse;
run;
Here's a recent question that has a viable approach:
That's assuming that MERGE means a SAS MERGE and not some other combination.
Thanks. Can you suggest an option with sql, since they are very large datasets?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.