topic Re: Cannot input YYYYmmm char variable in SAS Programming

Cannot input YYYYmmm char variable

KonstantinV — Sat, 18 Feb 2017 08:04:35 GMT

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;

Re: Cannot input YYYYmmm char variable

LaurieF — Sat, 18 Feb 2017 09:28:34 GMT

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;