07-05-2016 09:59 AM
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.
07-05-2016 10:27 AM - edited 07-05-2016 10:27 AM
Here's a recent question that has a viable approach:
That's assuming that MERGE means a SAS MERGE and not some other combination.
Need further help from the community? Please ask a new question.