BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Harin_Jay
Calcite | Level 5

Hi 

 

I have a very basic code which I try to use to map the date ranges , yet majority of the time I get a symbolic reference error.

below is the code and i have added a screen shot on the error , 

Data check_1;
dateformob=(put(intnx('mon',"&SYSDATE."D,-1,'e'), date9.));
call symput('dateformob',put(intnx('mon',"&SYSDATE."D,-1,'e'), date9.));
rfd_dt=%SYSFUNC(today());
format rfd_dt date9.;
call symput('rfd_dt',%SYSFUNC(today()));
TIME_RANGE=intnx('month',today(),-6,'s');
call symput('TIME_RANGE',intnx('month',today(),-6,'s'));
format TIME_RANGE date9.;
YYMM=(put(intnx('mon',today(),-1,'e'), yymmn4.));
call symput('YYMM',put(intnx('mon',today(),-1,'e'), yymmn4.));
dt_=%SYSFUNC(today())-1;
format dt_ YYMMDDN8.;
dt= putn( dt_,vformat(dt_));
run;
%put &rfd_dt &TIME_RANGE &dateformob &YYMM &dt ;

 

Harin_Jay_0-1664787826868.png

If someone can help me resolve this would be great !! 

 

Thanks!! 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

Your %put statement refers to &dt. But the code you posted never creates &dt. It must come from other code not shown here that sometimes runs and sometimes doesn't run.

Also note, you use today() both with and without %SYSFUNC. Since all uses are in DATA step statements, omit %SYSFUNC when using today().

View solution in original post

3 REPLIES 3
Astounding
PROC Star

Your %put statement refers to &dt. But the code you posted never creates &dt. It must come from other code not shown here that sometimes runs and sometimes doesn't run.

Also note, you use today() both with and without %SYSFUNC. Since all uses are in DATA step statements, omit %SYSFUNC when using today().

Harin_Jay
Calcite | Level 5
thanks !!
PaigeMiller
Diamond | Level 26

In the code you show, &dt is never defined.

--
Paige Miller

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1026 views
  • 0 likes
  • 3 in conversation