/ Published in: SAS
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
data oldids; infile cards; input idfield2 matchfield; cards; 1 100 2 200 ; data unmatched; infile cards; input idfield2 matchfield; cards; . 100 . 200 ; PROC SQL NOPRINT; UPDATE unmatched SET idfield2 = (SELECT idfield2 FROM oldids WHERE unmatched.matchfield EQ oldids.matchfield); QUIT;
URL: http://jaredprins.squarespace.com/blog/2008/6/3/match-merge-using-proc-sql.html