Advanced Search

Return to Snippet

Revision: 6497
at May 24, 2008 18:44 by webonomic
Initial Code 
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;
Initial URL 
http://jaredprins.squarespace.com/blog/2008/6/3/match-merge-using-proc-sql.html
Initial Description 









Initial Title





Match Merge using Proc SQL









Initial Tags





sql









Initial Language





SAS