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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.