data have;
yearmonth='200801';
run;
What is the best way to have same variable as date?
I mean it must be shown as 200801 again, but in date format.
Thanks,
Is this what you are looking for?
yearmonth2=input(yearmonth,yymmn6.);
And use
Format yearmonth2 yymm6.;
for display.
Good point, @ballardw!
data have;
yearmonth='200801';
yearmonth2=input(yearmonth,yymmn6.);
Format yearmonth2 yymmn6.;
run;
That's OK. 🙂
data have;
yearmonth='200801';
run;
data want;
format date yymmn6. date2 mmddyy10.;
set have;
date = input(put(yearmonth,$6.),yymmn6.);
date2 = intnx('month',date,0,'end');
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.