topic Re: Date conversion from string using date9. got same number from different year in SAS Programming

Date conversion from string using date9. got same number from different year

tinaz5012 — Wed, 17 Mar 2021 15:57:31 GMT

I am testing on conversion of string to date with the following code:

%sysmstoreclear;

data test2;
dt1="05/DEC/2019";
dt2="30/SEP/2020";
dt3="05/dec/2020";
num1=input(dt1,date9.);
num2=input(dt2,date9.);
num3=input(dt3,date9.);
run;

the result is shown in the below picture, num1 and num3 have same value. Can anyone please advise what is the reason caused this?

Re: Date conversion from string using date9. got same number from different year

FreelanceReinh — Wed, 17 Mar 2021 16:13:52 GMT

Hello @tinaz5012 and welcome to the SAS Support Communities!

The date9. informat reads only the first 9 characters of the strings dt1, dt2, dt3, e.g., "05/DEC/2019" (i.e., 5th December 2020). Use the date11. informat to read all 11 characters.

Re: Date conversion from string using date9. got same number from different year

Reeza — Wed, 17 Mar 2021 16:12:46 GMT

That isn't a date9 format so it's getting garbled, date9 doesn't have separators. So SAS is reading only the 20 portion, the fact that the last two work correctly is just a coincidence.

Date11 will work fine.

Re: Date conversion from string using date9. got same number from different year

juanormelli — Wed, 17 Mar 2021 17:13:26 GMT

data test2;
  dt1="05/DEC/2019";
  dt2="30/SEP/2020";
  dt3="05/dec/2020";
  dt4="30/SEP/2021";
  num1=input(dt1,date11.);
  num2=input(dt2,date11.);
  num3=input(dt3,date11.);
  Num4=input(dt4,date11.);
  format num1 num2 num3 num4 MONYY.;
run;

the date9 format. take only the first nine numbers of the date to get them all use the date11., according to the code below I used Format to debug and show that date11. really is it works.

Re: Date conversion from string using date9. got same number from different year

tinaz5012 — Wed, 17 Mar 2021 17:20:09 GMT

@FreelanceReinh @ree @juanormelli Thank you all for kindly help, appreciate it!