Note that when doing the merge
merge TABLE2 TABLE(in=Y);
you are matching one to one, so the shortest table (in terms of number of observations) stops the processing even if the other one is longer.
Dive into keynotes, announcements and breakthroughs on demand.
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.
Browse our catalog!