Hi there,
probably it is a boring subject, but I haven't found proper solutiion for it yet. Maybe you can help me:
I do have column of dates which are of type char, and looks like 2014Jan, 2014Feb, etc.
At the end I would like to have DATE9. format with the last day of the month e.g. 2014Jan -> 31JAN2014.
As a first step I try to convert each char date to yymon7. format by using input function, but it returns cells with '.' value.
WOuld you share your knowledge how to proceed?
Thanks a lot for help.
Please try intnx
data have;
x='2014jan';
x1=intnx('month',input(compress('01'||substr(x,5)||substr(x,1,4)),date9.),1)-1;
put x1=;
format x1 date9.;
run;
Please try intnx
data have;
x='2014jan';
x1=intnx('month',input(compress('01'||substr(x,5)||substr(x,1,4)),date9.),1)-1;
put x1=;
format x1 date9.;
run;
Perfect , many thanks.
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.