Hi
I have a requirement to check : first date of the current month & last month's first date +1
So today's date is : 2/12/2018
I want the first range as : 02/01/2018 ( 2nd jan 2018)
second range : 01/02/2018 (1st of feb 2018)
I have tried :
%LET PRE_MO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -1),DATE9.) ;
I am getting PRE_MO AS : 01JAN2018 , but I want it be increased by 1
I am trying : R = INTNX(('MONTH',AEENDTC1,0,"BEGINNING")),DATE9. ; ( to get the first day of this month)
But error shows :
R = INTNX(('MONTH',AEENDTC1,0,"BEGINNING")),DATE9. ;
_ _
_ _
_ _
79 22
79 22
79 22
_
_
_
200
200
200
: Expecting a ).
LIke this?
data test;
today="12feb2018"d;
first=intnx("month", today, -1, "b")+1;
second=intnx("month", today, 0, "b");
format today first second date9.;
run;
%LET PRE_MO = %eval(%SYSFUNC(INTNX(MONTH, &CURR, -1,b))+1) ;
%put %sysfunc(putn(&pre_mo,date9.));
Work with dates (and date-time values) as numbers rather than formatted values whenever possible.
Use the formatted values only when absolutely necessary, for example when displaying results for human eyes.
LIke this?
data test;
today="12feb2018"d;
first=intnx("month", today, -1, "b")+1;
second=intnx("month", today, 0, "b");
format today first second date9.;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: