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.
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 25. 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.