Hi all! I'm write a macro to merge two datasets by their ID. Each subject has multiple IDs, so the variable name has to be passed as an argument in the macro. Here's my code:
%macro merge(data1 =, data2 =, ID =, new=, );
proc sql;
create table &new AS
Select *
from &data1 as a Full join &data2 as b on &data1&ID = &data2&ID;
quit;
run;
%mend
May I know what went wrong? Thanks for the help.
... View more
