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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: