Do loop for changing dataset name

lalaktgrau — Thu, 18 Oct 2018 15:37:17 GMT

Hi all,

I have 5 datasets (Cohort1, Cohort2, Cohort3...).

I have a long program with a macro variable &DATA whenever I am calling one of the datasets above.

Is there a way to write a do loop that will run my entire program on all the cohorts?

Re: Do loop for changing dataset name

Bluebonnet16 — Thu, 18 Oct 2018 16:02:37 GMT

Hi,

something like this maybe?

%macro cohort;

%do i=1 %to 5;

data cohort&i;

infile or set statement here, and you can add &var to create variable different for each year;

.....

run;

%end;

/*you can insert your second macro here that will run for each cohort separately*/

%mendcohort;

%cohort;