Hi, If you really need to do a merge of both Table1 and Table2 and end up with you "wanted" data set you will need to merge and then dedup as follows. Data Table3; merge Table1 Table2; by id; Run; Proc sort data=Table3 nodupkey; by id; Run; Alternatively you could use a number of ways to get to get to your "wanted" dataset without creating / using Table2 - like... Proc sort data=Table1 (keep=id name) nodupkey out=Table3; by Id; Run; Or if you want so other stats try Proc Summary data=Table1 nway missing; class id name; output out=Table3; Run;
... View more