/*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;

http://jaredprins.squarespace.com/blog/2008/3/31/reusable-data-merge-macro.html

Reusable Data Merge Macro

data

SAS