I have a question on match-merging. Can someone pls help, or direct me to where I can find a forum dedicated to base sas topics?
I don't understand why the 2nd obs in the output shows 32 for age. Shouldn't values from xx OVERWRITE values in yy when the BY variable matches? I expected age to be 23. My merge statement says: merge yy xx;
----------
data xx;
infile cards;
input name $ age $ height;
cards;
Adam 23 160
;
run;
data yy;
infile cards dsd dlm=' ';
input name $ age $ weight;
cards;
Adam 200
Adam 32 180
;
run;
data merge_yyxx;
merge yy xx;
by name;
run;
proc print data=merge_yyxx;
run;
-------
Output:
Obs name age weight height
1 Adam 23 200 160
2 Adam 32 180 160
... View more