topic Looping to get 41 files having the year 1000 until year1000+900 in SAS Programming

Looping to get 41 files having the year 1000 until year1000+900

Noomen — Tue, 10 Nov 2020 23:29:14 GMT

Hi all,

I need 41 files from Y1980 to Y2020 with one variable (index) going from year*1000 to year*1000+900.

So for Y1980, Index will range from 19800000 to 19800900.

I wrote the following but the result is not as expected.

%macro myloop;
%do i=1980 %to 2020;
data Y&i;
%do index=&i*1000 %to &i*1000+900;
output;
%end;
run;
%end;

%mend;

%myloop;

Re: Looping to get 41 files having the year 1000 until year1000+900

SASKiwi — Tue, 10 Nov 2020 23:36:09 GMT

Looks like you are confusing macro and SAS code loops. Is this more like it?

%macro myloop;
%do i=1980 %to 2020;
data Y&i;
do index=&i*1000 to &i*1000+900;
output;
end;
run;
%end;

%mend;

 

%myloop;

Re: Looping to get 41 files having the year 1000 until year1000+900

Kurt_Bremser — Wed, 11 Nov 2020 07:06:21 GMT

The macro language is a code generator, and the code you created through it looks like this:

data Y1980;
output;
output;
output;
/* repeat 901 times all in all */
output;
run;

To create or manipulate data, you use the data step language, to create code, you use the macro language.

Macro variables (&index in your case) are only "visible" to the macro processor, not to the created code (unless you use them as parts of the created code).

topic Looping to get 41 files having the year *1000 until year*1000+900 in SAS Programming

Looping to get 41 files having the year *1000 until year*1000+900

Re: Looping to get 41 files having the year *1000 until year*1000+900

Re: Looping to get 41 files having the year *1000 until year*1000+900

topic Looping to get 41 files having the year 1000 until year1000+900 in SAS Programming

Looping to get 41 files having the year 1000 until year1000+900

Re: Looping to get 41 files having the year 1000 until year1000+900

Re: Looping to get 41 files having the year 1000 until year1000+900