DATA Step, Macro, Functions and more

Cannot input YYYYmmm char variable

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Cannot input YYYYmmm char variable

[ Edited ]

 

I have a char variable containing dates such as : 2008Dec ; 2009Jan ...

I want to convert it to numeric datetime and then format it as DATE9.

 

However it seems that yymon7. works only as format. What should I use then?

 

data new; set old;
	Date_num = input(Date, yymon7.);
format Date_num DATE9.;
run;

 

 

 


Accepted Solutions
Solution
‎02-18-2017 04:35 AM
Super Contributor
Posts: 251

Re: Cannot input YYYYmmm char variable

[ Edited ]

If you really can't change your source data to monyy before your final step gets hold of it, you can do it this way:

data old;
do date = '2008dec', '2009jan', '2009dec';
   output;
   end;
stop;
run;

data new; 
set old; Date_num = input(substr(date, 5, 3) || substr(date, 1, 4), monyy7.); format Date_num DATE9.; run;

View solution in original post


All Replies
Solution
‎02-18-2017 04:35 AM
Super Contributor
Posts: 251

Re: Cannot input YYYYmmm char variable

[ Edited ]

If you really can't change your source data to monyy before your final step gets hold of it, you can do it this way:

data old;
do date = '2008dec', '2009jan', '2009dec';
   output;
   end;
stop;
run;

data new; 
set old; Date_num = input(substr(date, 5, 3) || substr(date, 1, 4), monyy7.); format Date_num DATE9.; run;
☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 139 views
  • 1 like
  • 2 in conversation