hello
I want to obtain the previous date. my date format is YYMMN6.
for example I have 201501, I want that the program give the previous month 201412
thanks
data want;
set have;
previous_date=intnx('month',date,-1,'b');
format previous_date yymmn6.;
run;
All month arithmetic should be done with INTNX function (or in some situations the INTCK function). SAS has done the hard work to do month arithmetic, so you don't have to.
data want;
set have;
previous_date=intnx('month',date,-1,'b');
format previous_date yymmn6.;
run;
All month arithmetic should be done with INTNX function (or in some situations the INTCK function). SAS has done the hard work to do month arithmetic, so you don't have to.
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: