Convert char yyyymon to date (DATE9.)

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Convert char yyyymon to date (DATE9.)

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.


Accepted Solutions
Solution
‎05-18-2016 09:35 AM
Super User
Posts: 1,111

Re: Convert char yyyymon to date (DATE9.)

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;
Thanks,
Jag

View solution in original post


All Replies
Solution
‎05-18-2016 09:35 AM
Super User
Posts: 1,111

Re: Convert char yyyymon to date (DATE9.)

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;
Thanks,
Jag
Occasional Contributor
Posts: 5

Re: Convert char yyyymon to date (DATE9.)

Perfect , many thanks.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 380 views
  • 2 likes
  • 2 in conversation