topic Re: Create loop for running existing macros in SAS Programming

Create loop for running existing macros

india2016 — Thu, 19 Apr 2018 16:00:33 GMT

Hello All,

I am stuck while creating macro.

I have one macro and want to run this macro 52 times with 52 dates so I should create one macro that will run existing macro for 52 dates but I have that are in disorder( e.g. 20171213, 20171215,20171219).But I can write manually.

Want create TEST macro which will run existing macro..

NOTES:

1) FCF macro will take date one by one and create multiple datasets ..

2) TEST macro wants to create that run 52 times..

%macro test;

%fcf;

%mend fcf;

%mend test;

So how should I give these 52 dates in my macro so that existing macro will take all values and run for that dates.Should I give keyword parameter macro? with 52 dates and that will run for all dates.

Re: Create loop for running existing macros

Reeza — Thu, 19 Apr 2018 16:08:52 GMT

CALL EXECUTE.

Use a data step loop to create your dates and then call the macro once for each date.

Once your STR variable looks like the correct code (%fcf(date);) then you can uncomment the call execute str and it will execute the str.

data call_macro;

do date='01Jan2018'd to '31Dec2018'd;
str = catt('%fcf(', put(date, date9.), ');');
*call execute (str);
end;

run;

@india2016 wrote:

Hello All,

I am stuck while creating macro.

I have one macro and want to run this macro 52 times with 52 dates so I should create one macro that will run existing macro for 52 dates but I have that are in disorder( e.g. 20171213, 20171215,20171219).But I can write manually.

Want create TEST macro which will run existing macro..

NOTES:

1) FCF macro will take date one by one and create multiple datasets ..

2) TEST macro wants to create that run 52 times..

%macro test;

%fcf;

%mend fcf;

%mend test;

So how should I give these 52 dates in my macro so that existing macro will take all values and run for that dates.Should I give keyword parameter macro? with 52 dates and that will run for all dates.

Re: Create loop for running existing macros

Astounding — Thu, 19 Apr 2018 16:12:03 GMT

This might be helpful:

https://blogs.sas.com/content/sastraining/2015/01/30/sas-authors-tip-getting-the-macro-language-to-perform-a-do-loop-over-a-list-of-values/