I am in the process of converting data merges into proc sql joins. I have the following merge DATA test ; MERGE data 1 data 2 (KEEP=one two three IN=_2); BY one two ; RUN; This is my proc sql code proc sql; create table test1 as select a.*, b.one, b.two,b.three from data1 as a outer join data2 as b on a.one=b.one and a.two=b.two; quit; I am getting 11 extra observations in the proc sql than the merge. I am not sure why that is happening. Any help greatly appreciated.
... View more