topic Re: loop in SAS Programming

loop

asdfsa — Tue, 10 Jul 2018 11:14:49 GMT

I made macro %dataload

and want to load data once by using loop.. not that listing

%dataload(year=16,month=09);
%dataload(year=16,month=10);
%dataload(year=16,month=11);
%dataload(year=17,month=12);
%dataload(year=17,month=01);
%dataload(year=17,month=02);
%dataload(year=17,month=03);
%dataload(year=17,month=04);
%dataload(year=17,month=05);
%dataload(year=17,month=06);
%dataload(year=17,month=07);
%dataload(year=17,month=08);
%dataload(year=17,month=09);
%dataload(year=17,month=10);
%dataload(year=17,month=11);

can I use do loop?

for example

%let start_year=16

%let end_year=18

do i = start_year to end_year;

do j= 1 to 12;

%dataload(year=i,month=j)

end;

Re: loop

Kurt_Bremser — Tue, 10 Jul 2018 11:47:40 GMT

The macro PREprocessor does its work (generating code!) before any Base SAS code starts to run. Since your macro will leave Base SAS code in its place, that will destroy any data step logic.

To call a macro from a data step (using values created in the data step), use call execute().

Re: loop

gamotte — Tue, 10 Jul 2018 12:01:33 GMT

Hello,

You have to use macro loops (and use & to resolve macrovariables values) :

%let start_year=16
%let end_year=18

%do i = &start_year. %to &end_year.;
    %do j= 1 to 12;
        %dataload(year=&i.,month=&j.)
    %end;
%end;

Edit : Note that a macro loop can only be used inside a macro :

%macro mymacro;

/* macro code */

...

%mend;

%mymacro;

Re: loop

Reeza — Tue, 10 Jul 2018 15:15:51 GMT

You can.

Is something not working for you?

CALL EXECUTE is usually simpler however.

@asdfsa wrote:

I made macro %dataload

and want to load data once by using loop.. not that listing

%dataload(year=16,month=09);
%dataload(year=16,month=10);
%dataload(year=16,month=11);
%dataload(year=17,month=12);
%dataload(year=17,month=01);
%dataload(year=17,month=02);
%dataload(year=17,month=03);
%dataload(year=17,month=04);
%dataload(year=17,month=05);
%dataload(year=17,month=06);
%dataload(year=17,month=07);
%dataload(year=17,month=08);
%dataload(year=17,month=09);
%dataload(year=17,month=10);
%dataload(year=17,month=11);

can I use do loop?

for example

%let start_year=16

%let end_year=18

do i = start_year to end_year;

do j= 1 to 12;

%dataload(year=i,month=j)

end;

end;

Re: loop

s_lassen — Wed, 11 Jul 2018 10:42:59 GMT

As @gamotte already implied, you would have to use a macro loop. One possibility is to rewrite your %dataload macro to a recursive version:

%macro dataload(year=,month=,from=,to=);
  %if %length(&from) and %length(&to) %then %do;
    %do from=&from %to &to;
      %if %substr(&from,3)=13 %then /* new year */
        %let from=%eval(&from+88);
      %dataload(year=%substr(&from,1,2),month=%substr(&from,3));
      %end;
    %return;
    %end;
  /* here goes the contents of the original macro */
%mend;

You could then call the macro as

%dataload(from=1609,to=1711);