I am trying to learn how to use PROC SQL. I am trying to figure out how to completely use PROC SQL to do the same logic and have the same output dataset as the code below. Pets1 and Pets2 datasets are both really wide and long so I try to subset the data before merging. I'm hoping I can accomplish the same using purely PROC SQL. proc sql noprint; create table temp1 AS select a, b, c from pets1 order by a, b; create table temp2 AS select a, b from pets2 order by a, b; quit; data A3; merge temp1 (in=A) temp2 (in=B); by a b; length s $10; if A and B then s= 'both'; else if A then s= 'temp1'; else if B then s= 'temp2'; run; Thank you.
... View more