Match Merge using Proc SQL - SAS Snipplr Social Repository

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

Choose a language for easy browsing: