topic Re: Macro within a macro in SAS Programming

Macro within a macro

di_niu0 — Mon, 01 Mar 2021 15:36:44 GMT

Hello, I have a problem with the below code. %gettime is a macro which gives the 100th day after the start date and outputs a table. I would like to get table1 which gives the 100th day after date1, table2 which gives 100th day after date2...Until date12. But the code only gives me table1. I am not sure what's wrong with the code.

Thank you in advance!

%macro date;

%do i=1 %to 12;

%getdate(

start = date&i,

out = table&i);

%end;

%mend;

%date;

Re: Macro within a macro

Tom — Mon, 01 Mar 2021 15:59:29 GMT

Not much information to work with:

Try this:

Modify the definition of the GETDATE macro and add this statement:

%local i;

Re: Macro within a macro

di_niu0 — Mon, 01 Mar 2021 15:58:41 GMT

Hello, thank you for your reply. Do you mean add %local i into the GETDATE macro?

Re: Macro within a macro

Tom — Mon, 01 Mar 2021 16:04:33 GMT

Yes. Your posted code is setting I=1 then calling GETDATE. The %DO loop then increments I by 1 and tests if it is greater than 12. So GETDATE must be changing I to a value that is 11 or larger. If you tell GETDATE to use a LOCAL macro variable instead of the existing macro variable then it will not modify the variable being used for the %DO loop.

Re: Macro within a macro

Reeza — Mon, 01 Mar 2021 16:04:37 GMT

Look up CALL EXECUTE.

The documentation has an example.

@di_niu0 wrote:

Hello, I have a problem with the below code. %gettime is a macro which gives the 100th day after the start date and outputs a table. I would like to get table1 which gives the 100th day after date1, table2 which gives 100th day after date2...Until date12. But the code only gives me table1. I am not sure what's wrong with the code.

Thank you in advance!

%macro date;

%do i=1 %to 12;

%getdate(

start = date&i,

out = table&i);

%end;

%mend;

%date;

Re: Macro within a macro

di_niu0 — Mon, 01 Mar 2021 16:07:06 GMT

Thank you!

Re: Macro within a macro

classe_i_k — Mon, 01 Mar 2021 16:08:04 GMT

I'm happy to help. However can you give an overview of your macro getname.