Merging datasets using sas macro code?

[esilio]

Dear all,

I'm quite new to macro, and my question is:

I'm trying to merge 12 datasets together, named data_1 to data_12 with id and already sorted, and my code is

%macro mergedata;

%do i=1 %to 12;

data merged_data;

merge data_&i;

by id;

%end;

run;

%mend;

and it resulted in only the data from data_12. it seems that data_1 to data_11 were replaced and disappeared.

How should I rewrite that? Thank you very much!

[SAS_inquisitive · Accepted solution]

%macro mergedata;
data merged_data;
  merge
%do i=1 %to 12;
 data_&i
%end;
  ;
  by id;
run;
%mend;

[Astounding]

When writing a macro language program, you always, always, always have to know what the program would look like if you were not using macro language.  

@SAS_inquisitive has the right idea here.  It just needs a slight tweak, removing the extra semicolon here:

%do;

[esilio]

thanks a lot for advice. really helped a lot !

[esilio]

solved! thanks a lot