topic INTNX Error in macro code - number not recognized as number in function in SAS Programming

INTNX Error in macro code - number not recognized as number in function

wendydawn — Mon, 28 Aug 2023 18:26:51 GMT

Hello,

I'm new to macros and have some very simple code which seems to be working. I tested it by printing out the dates and dates2 tables:

CODE

%MACRO createtables (row, seeddate);

data dates;
runmonth = &seeddate.;
run;

%mend;

createtables (row=1, seeddate=mdy(2,1,2022));

data dates2;
set dates;
testa = put(runmonth,yymmdd10.);
run;

But when I take the next step using rundate in INTNX, I get an error that rundate is not a number. What am I doing wrong?? Thanks in advance for your help.

CODE

%MACRO createtables (row, seeddate);

data dates;
runmonth = &seeddate.;
startdate = %sysfunc(intnx('month',runmonth,-12,'B'));
run;
%mend;

%createtables (row=1, seeddate=mdy(2,1,2022));

Re: INTNX Error in macro code - number not recognized as number in function

PaigeMiller — Mon, 28 Aug 2023 19:05:59 GMT

No need for %sysfunc to call a data step function inside a data step. Just use the data step function.

%MACRO createtables (row, seeddate);
    data dates;
        runmonth = &seeddate.;
        startdate = intnx('month',runmonth,-12,'B');
    run;
%mend;

You can simplify this code even further

%macro createtables (row, seeddate);
    data dates;
        startdate = intnx('month',&seeddate,-12,'b');
    run;
%mend;

Also, if you MUST use %sysfunc, do not put quotes around month and do not put quotes around B. But even so, you can't use %sysfunc here because it cannot access any data step variables, in this case it cannot access data step variable RUNMONTH.

Re: INTNX Error in macro code - number not recognized as number in function

wendydawn — Mon, 28 Aug 2023 19:09:03 GMT

Thank you so much! I really appreciate your response. I feel like I tried everything but the simplest solution. 🙃 I still have a lot to learn about data steps vs other types of steps.

Re: INTNX Error in macro code - number not recognized as number in function

Tom — Mon, 28 Aug 2023 19:18:03 GMT

@wendydawn wrote:

Thank you so much! I really appreciate your response. I feel like I tried everything but the simplest solution. 🙃 I still have a lot to learn about data steps vs other types of steps.

You need to learn how to use data steps first. Do not bother trying to learn how to use code to create code (the macro language) until you know how to create the code yourself.