topic Re: SAS Code for Converting Number Value to Date Format in SAS Procedures

SAS Code for Converting Number Value to Date Format

sufiya — Wed, 20 May 2020 18:23:33 GMT

Hi,

Would anyone know how to convert number value to date format?

right now this is my data output - the "RUN_MONTH" is the month

And I want the "RUN_MTH" column to change to Month date format.

I was thinking of using Data set to update the column but this code does not work out.

data Plan set Plan; format RUN_MTH date9.;
RUN_MTH=datepart(RUN_MTH); run;

Could someone please let me know the correct way to format this column?
Thank you,

Kurt_Bremser — Wed, 20 May 2020 18:31:14 GMT

If you have just the month number, use the MDY function to create the whole date:

run_mth = mdy(run_mth,1,2020);
format run_mth date9.;

sufiya — Wed, 20 May 2020 20:14:56 GMT

Thank you @Kurt_Bremser 😊