I have 3 data sets with different variables, but a account numbers as the common variable among all the 3 tables. need to match any account listed in either or both of the tables.
Need to find the same account number in all the dataset.
data want;
merge have1(in=t1) have2(in=t2) have3(in=t3);
by ID;
if t1& t2 & t3;
run;
@Sultana wrote:
need to match any account listed in either or both of the tables.
Need to find the same account number in all the dataset.
IMO those are contradictory statements.
Match Merging is documented here: https://documentation.sas.com/?docsetId=lrcon&docsetTarget=n1tgk0uanvisvon1r26lc036k0w7.htm&docsetVe...
data want;
merge have1(in=t1) have2(in=t2) have3(in=t3);
by ID;
if t1& t2 & t3;
run;
@Sultana wrote:
need to match any account listed in either or both of the tables.
Need to find the same account number in all the dataset.
IMO those are contradictory statements.
Match Merging is documented here: https://documentation.sas.com/?docsetId=lrcon&docsetTarget=n1tgk0uanvisvon1r26lc036k0w7.htm&docsetVe...
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts 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.