SAS Programming

[Sultana]

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.

[Reeza · Accepted solution]

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...