topic Re: Merging datasets using sas macro code? in SAS Programming

Merging datasets using sas macro code?

esilio — Wed, 05 Jul 2017 02:10:56 GMT

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 — Wed, 05 Jul 2017 03:01:08 GMT

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

Astounding — Wed, 05 Jul 2017 02:27:32 GMT

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 — Wed, 05 Jul 2017 02:36:44 GMT

solved! thanks a lot

esilio — Wed, 05 Jul 2017 02:37:25 GMT

thanks a lot for advice. really helped a lot !