topic Re: WARNING: Apparent symbolic reference MAXDATE not resolved in SAS Programming

WARNING: Apparent symbolic reference MAXDATE not resolved

Ronein — Mon, 19 Jul 2021 06:27:33 GMT

Hello,

I am trying to create a sas macro variable but I get a warning

WARNING: Apparent symbolic reference MAXDATE not resolved

I see that the process didn't work well and I dont know why

Data ttt;
format  Pdate date9.;
Input Pdate :date9.;
Cards;
13FEB2020 
18Mar2020
21Jun2020
19May2021
;
Run;


%macro exist;
%if %sysfunc(exist(ttt)) %then %do;
 proc sql noprint;
 select max(Pdate)
  into :MaxDate  trimmed
  from  ttt
;
quit;
%end;
%Else %do;
%let MaxDate=22159;
/*01SEP2020*/
%End;
%mend;
%exist 

%put &MaxDate;
/*WARNING: Apparent symbolic reference MAXDATE not resolved.*/

Re: WARNING: Apparent symbolic reference MAXDATE not resolved

andreas_lds — Mon, 19 Jul 2021 06:38:28 GMT

If you want a global macro-variable, you have to use %global-statement.

Re: WARNING: Apparent symbolic reference MAXDATE not resolved

Ronein — Mon, 19 Jul 2021 06:46:19 GMT

Great!

May you please explain why do we need to use global macro variable in this example

 Data ttt;
format  Pdate date9.;
Input Pdate :date9.;
Cards;
13FEB2020 
18Mar2020
21Jun2020
19May2021
;
Run;

%global MaxDate;
%macro exist;
%if %sysfunc(exist(ttt)) %then %do;
 proc sql noprint;
 select max(Pdate)
  into :MaxDate  trimmed
  from  ttt
;
quit;
%end;
%Else %do;
%let MaxDate=22159;
/*01SEP2020*/
%End;
%mend;
%exist 
%put &MaxDate;

Re: WARNING: Apparent symbolic reference MAXDATE not resolved

ballardw — Mon, 19 Jul 2021 15:06:12 GMT

@Ronein wrote:

Great!

May you please explain why do we need to use global macro variable in this example

 Data ttt;
format  Pdate date9.;
Input Pdate :date9.;
Cards;
13FEB2020 
18Mar2020
21Jun2020
19May2021
;
Run;

%global MaxDate;
%macro exist;
%if %sysfunc(exist(ttt)) %then %do;
 proc sql noprint;
 select max(Pdate)
  into :MaxDate  trimmed
  from  ttt
;
quit;
%end;
%Else %do;
%let MaxDate=22159;
/*01SEP2020*/
%End;
%mend;
%exist 
%put &MaxDate;

You have a %put referencing the variable Maxdate AFTER the %exist has executed. That is why you need Maxdate to be global in this case. ANY time you use a macro variable outside of the scope of a running macro you are going to need that macro variable to be global.

Re: WARNING: Apparent symbolic reference MAXDATE not resolved

Rick_SAS — Mon, 19 Jul 2021 17:17:41 GMT

I'd like to point out that, in most applications, the following two statements are equivalent, but the second is much easier to read and understand:

%let MaxDate=22159; /* 01SEP2020 */
%let MaxDate='01SEP2020'd;