How to create a macrovariable which holds the value of previousmonth end date time
For ex: '8/30/2011 23:59:59'
proc format;
picture mydtfmt
other = '%m/%d/%Y %H:%M:%S' (datatype=datetime);
run;
data _null_;
/* get first day of current month */
today=today();
first_day=mdy(month(today),1,year(today));
/* get last day of previous month and add time 23:59:59 */
want_d=first_day-1;
want_dt=dhms(want_d,23,59,59);
/* put calculated datetime into macrovariable with for m/d/Y H:M:S */
call symput('previousmonth',put(want_dt,mydtfmt.));
run;
%put &previousmonth;
proc format;
picture mydtfmt
other = '%m/%d/%Y %H:%M:%S' (datatype=datetime);
run;
data _null_;
/* get first day of current month */
today=today();
first_day=mdy(month(today),1,year(today));
/* get last day of previous month and add time 23:59:59 */
want_d=first_day-1;
want_dt=dhms(want_d,23,59,59);
/* put calculated datetime into macrovariable with for m/d/Y H:M:S */
call symput('previousmonth',put(want_dt,mydtfmt.));
run;
%put &previousmonth;
or, a bit easier:
data _null_;
call symput('prev_month_end',intnx('dtmonth', datetime(),-1,'E'));
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.