topic Converting Date number to Date9. in SAS Data Science

Converting Date number to Date9.

mlogan — Wed, 09 Sep 2015 16:19:09 GMT

Hi,

I have a date1 variable with number (20140220) and I need to convert it to Date9. format (20FEB2014)

Any comments highly appreciated

Regards

Re: Converting Date number to Date9.

Rick_SAS — Wed, 09 Sep 2015 17:06:04 GMT

One way is to convert the number to a character string and then use the INPUT function to apply a date format:

data A;
format d DATE9.;         /* display d as date */
date1 = 20140220;
c = put(date1, 8.);      /* convert to char */
d = input(c, anydtdte.); /* read with "anydate" format */
run;

proc print; run;

Re: Converting Date number to Date9.

Tom — Sat, 12 Sep 2015 13:28:47 GMT

Since it is already a number you could convert the value to a SAS date value and apply the DATE9. format to the variable.

data want ;
    set have ;
    date1 = input(put(date1,8.),yymmdd8.);
    format date1 date9. ;
run;