topic Re: Incorrect year from character date to SAS date in SAS Programming

Incorrect year from character date to SAS date

Miracle — Wed, 14 Jul 2021 11:40:44 GMT

Dear All,

Could you please point me out the what's wrong with my code?
Why it is giving me the year of 2020 instead of 2021?
Thanks a lot.

data _null_;
strdate="13 APR 2021";
sasdate=input(strdate,date9.);
format sasdate yymmdd10.;
put strdate=; 
put sasdate=;
run;

strdate=13 APR 2021
sasdate=2020-04-13

Re: Incorrect year from character date to SAS date

Kurt_Bremser — Wed, 14 Jul 2021 11:46:37 GMT

You set strdate with a length of 11, but read only 9 characters in the INPUT function (because you use the date9. informat), so you get the result of converting "13 APR 20".

Either remove the blanks, or use the date11. informat.