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?
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.