/ Published in: SAS
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
/*Have 2 datasets*/ data table1; INPUT id sex $ age; DATALINES; 1 F 35 2 M 50 3 F 45 3 M 24 3 F 52 1 M 44 2 F 34 1 M 40 3 F 47 2 M 35 ; run; data table2; INPUT id name $; DATALINES; 1 A 2 B 3 C ; run; /*create Macro*/ %MACRO domerge(ds1=, ds2=, resultdataset=); proc sort data=&ds1; by id; run; proc sort data=&ds2; by id; run; data &resultdataset; merge &ds1 &ds2; by id; run; %MEND domerge; /*Use the macro*/ %let t1 = table1; %let t2 = table2; %MACRO domerge(ds1=, ds2=, resultdataset=); proc sort data=&ds1; by id; run; proc sort data=&ds2; by id; run; data &resultdataset; merge &ds1 &ds2; by id; run; %MEND domerge;
URL: http://jaredprins.squarespace.com/blog/2008/3/31/reusable-data-merge-macro.html