Conversion error datetime20.3 to yymmd7.

JS — Wed, 08 Feb 2017 22:35:17 GMT

I'm trying to convert a datetime20. to a yymmd7. but I'm running into a peculiar error. The data steps run fine, the values get converted... but the error remains.

Any thoughts?

Thank you!

Code

data have;
input time datetime20.;
format time datetime20.;
informat time datetime20.;
cards;
12SEP2013:10:19:43
;
run;

data want;
set have;
format time datetime20. want_date yymmd7.;
want_date = input(datepart(time),yymmd7.);
run;

Error -- Informat could not be found

485
NOTE 485-185: Informat YYMMD was not found or could not be loaded.

28 run;

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
27:19

Results -- Outputs and runs successfully despite error

time want_date
12Sep2013 10:19:43 2013-09

Re: Conversion error datetime20.3 to yymmd7.

Kurt_Bremser — Wed, 08 Feb 2017 22:43:58 GMT

You're overcomplicating things by a mile, and on the way you cause an unnecessary type conversion.

Do this instead:

want_date = datepart(time);

Re: Conversion error datetime20.3 to yymmd7.

JS — Wed, 08 Feb 2017 22:55:00 GMT

I see. I was trying to re-input the date unnecssarily. This works beautifully. Thank you!

topic Conversion error datetime20.3 to yymmd7. in SAS Programming

Conversion error datetime20.3 to yymmd7.

Re: Conversion error datetime20.3 to yymmd7.

Re: Conversion error datetime20.3 to yymmd7.