topic Re: Macros Help in New SAS User

Macros Help

saikiran_nemani — Sun, 12 May 2019 06:48:10 GMT

%end;
);
%end;

/* Macro jumps here if it has already been run with these parameters. */

%The_End:
%if &rflag=YES %then
%do;
NOTE: Remote submit to SASSRVP complete.
MLOGIC(RSUBMIT):  Ending execution.
ERROR: The %END statement is not valid in open code.

MPRINT(GRAB_INSTALL_DATA):   proc sql;
SYMBOLGEN:  Macro variable INCLUDE_XICMS resolves to Y
MLOGIC(GRAB_INSTALL_DATA):  %IF condition &include_xicms.=N is FALSE
SYMBOLGEN:  Macro variable ST_DAT resolves to &be_date.
WARNING: Apparent symbolic reference BE_DATE not resolved.
WARNING: Apparent symbolic reference BE_DATE not resolved.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
       operand is required. The condition was: &be_date.
SYMBOLGEN:  Macro variable END_DAT resolves to &en_date.
WARNING: Apparent symbolic reference EN_DATE not resolved.
WARNING: Apparent symbolic reference EN_DATE not resolved.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
       operand is required. The condition was: &en_date.
MLOGIC(GRAB_INSTALL_DATA):  %IF condition %sysevalf(&st_dat) <
      %sysfunc(intnx(Month,%sysfunc(today()),0)) and   %sysevalf(&end_dat) >=
      %sysevalf('01jan2008'd) is FALSE
ERROR: The macro GRAB_INSTALL_DATA will stop executing.
MPRINT(GRAB_INSTALL_DATA):   create table allfails as select * from
staging.ads_daily_failed_installs where scheduled_date ge intnx('month',today(),0) and SITEID
ne 34 and type in ('A','D','T','H','V','U','F','4','#','-','2')
MLOGIC(GRAB_INSTALL_DATA):  Ending execution.

Re: Macros Help

PaigeMiller — Sun, 12 May 2019 11:17:03 GMT

%The_End: %if &rflag=YES %then %do; NOTE: Remote submit to SASSRVP complete. MLOGIC(RSUBMIT): Ending execution. ERROR: The %END statement is not valid in open code.

This error happens because you are using %IF %THEN %DO outside of a macro. You can't do that (unless your have SAS 9.4TS1M5 or later, which obviously you don't).

SYMBOLGEN: Macro variable ST_DAT resolves to &be_date.

WARNING: Apparent symbolic reference BE_DATE not resolved.

You macro variable ST_DAT is replaced by the text &be_date, a macro variable which does not have a value, so your SAS program does not know how to continue.

Re: Macros Help

Tom — Sun, 12 May 2019 15:27:26 GMT

Looks like you are using SAS/Connect to remote submit some code to another SAS session?

Looks like your program has gotten confused about what code is being sent to which session and so you have gotten code like %GOTO and %DO/%END that can only work inside of a macro definition pushed into open code.