Is it possible to loop over SAS datasets?

Question

I have 60 sas datasets that contain data on consumers individual characteristics such as `id, gender, age, amountSpent, ....` Each dataset shows data only for one time period (data1 is Jan, data2 is Feb...). I cannot merge them because of the size and some other issues. How can I write a multiple loop to go through each of the datasets, do some manipulations and save the estimated values to a temporary file. SAS does not have a `for` loop. How can I use `do`?

Answer 1

Here's one solution involving 3 sample datasets named data1, data2 and data3. The macro call can be changed to any starting and ending number, such as (1,60)

/* create sample datasets 1 - 3 */

data data1;

input month $ id $;

datalines;

jan2014 001

jan2014 002

;

run;

data data2;

input month $ id $;

datalines;

feb2014 001

feb2014 002

;

run;

data data3;

input month $ id $;

datalines;

mar2014 001

mar2014 002

;

run;

%macro months(start,end);

%do i=&start. %to &end.;

data m;

set data&i.;

if id='002'; /*** any processing you want goes here ***/

run;

%if &i = &start. %then %do;

data temp; set m; run;

%end;

%else %do;

proc append data=m base=temp force; run;

%end;

%end;

%mend months;

%months(1,3)