I am trying to remerge two datasets under the following conditions:
dataset1: more than one observation per id and multiple date per id
id date age sex
1 ..
2...
3...
4
4
5
I created dataset 2 and selected distint id and the min(date)
dataset 2, one observation per id
id min_date
1
2
3
Now I want to remerge the data back to get all the other variables, how can I create an inner joint statement using both id and min(date) to get the other information specific to that date in the original dataset
Thanks it worked!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.