If you want to merge then setup your data so that it can be merged.
data want;
merge a(rename=(age_a=age)) b(rename=(age_b=age)) ;
by id age;
run;
If you want more precise help then post a workable example of data that demonstrates your problem.
Thank you !! I did this and with a few other steps and it worked 🙂
If you merged by ID and AGE and you are getting missmatched records then the value or either ID or AGE do not match. Perhaps your AGE values have been derived and one of them is 14 but the other is really 13.9999999 and it is just printing as 14.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.