topic Re: Macro error: Expecting an integer constant in New SAS User

Macro error: Expecting an integer constant

CHELS — Tue, 02 Jul 2019 16:14:18 GMT

I have a macro for propensity score as follow:

%macro prop_score (DatIn=, CatVar=, ConVar=, Outcome=, Event=, Iter=);

proc logistic data = &DatIn descending;
class &CatVar;
model &Outcome (event = "&Event") = &CatVar &ConVar /link=logit FIRTH Maxiter=&Iter ;
output out = ps_los pred = ps xbeta = logit_ps;
run;

%mend prop_score;

When I try to evoke the Macro with the following, it kept giving me ERROR 22-322: Expecting an integer constant at the MAXITER option but I did specify an integer?

%prop_score (DatIn = Dat,
                       CatVar = %Str( A B C D) ,
                       ConVar = E,
                       Outcome = F,
                       Event = D,
                       Iter=15000);

Re: Macro error: Expecting an integer constant

tsap — Tue, 02 Jul 2019 16:43:41 GMT

Its hard to tell without more information, but it looks to me like the error isn't being produced by the MAXITER option. It seems like the error would be from somewhere around the "&Event" and &CatVar area. Are you actually using these macro values (E, F,D, %Str( A B C D), etc), or is this just dummy data that you plugged in for the post? I ask mainly because from every proc logistic step I've seen, the 'event=' is typically populated with a '1' or '0', and not a letter character. Additionally, I only typically see the section that follows that to have one value to explain what the '1' or '0' stands for. Where based on your logic it stands for "%Str( A B C D)". If that makes sense. Have you successfully run the code outside of the macro statement with values hard coded prior to building it into the macro statement?

Re: Macro error: Expecting an integer constant

CHELS — Tue, 02 Jul 2019 16:54:03 GMT

Hi there!

Yes I am able to run it outside of the Macro. Actually I found the error~ I missed a comma (stupid error). Nevertheless, thank you for your help!

Re: Macro error: Expecting an integer constant

Reeza — Tue, 02 Jul 2019 17:40:04 GMT

Please mark the question as solved to close this. In the future, please post your actual code and log, errors like that are easily found in the log.