Date is entered as numeric with this format 20191024 I need to format it to mmddyyyy

[GN0001]

Hello team,

I have a column of date which is all numeric, they are not characters. I need to format it as mm/dd/yyyy.

I do what I can, this doesn't get resolved.

the result has to be 10/24/1999

Regards,

Blue & Blue

[ballardw · Accepted solution]

If the value is numeric you just need to change the actual number involved to a date value and apply a format.

One example:

data example;
   x =  20191024;
   x = input(put(x,f8.),yymmdd8.);
   format x mmddyy10.;
run;

Which is easier than parsing out the month, day and year with other methods.

Caveat: if you have single digit month or day: 201911 (instead of 20190101) then you have more work to do.

[GN0001]

Hello teammate,

This response saved my life. Thank you very much for it.

I need to know what 

put(x,f8.)

do.

Thanks for the response.

blue & blue

[Tom]

The INPUT() function converts strings into values based on the informat  being used.

But your variable is numeric, not a character strings.  So the PUT() function converts values into strings, based on the format being used.  The 8. format tells SAS to format the number as an 8 digit string.

[GN0001]

Hello Tom,

What a great response.

Thanks,

Blue & Blue