topic Date is entered as numeric with this format 20191024 I need to format it to mmddyyyy in SAS Programming

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

GN0001 — Fri, 25 Feb 2022 23:04:23 GMT

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

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

ballardw — Fri, 25 Feb 2022 23:09:10 GMT

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.

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

GN0001 — Sun, 27 Feb 2022 22:40:24 GMT

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

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

Tom — Sun, 27 Feb 2022 23:45:01 GMT

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.

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

GN0001 — Mon, 28 Feb 2022 02:51:24 GMT

Hello Tom,

What a great response.

Thanks,

Blue & Blue