topic How to convert a numeric to date format in SAS? in SAS Programming

How to convert a numeric to date format in SAS?

WishShahid — Tue, 18 Apr 2023 17:56:48 GMT

Hi,

I have a dataset with date variables in numeric form, for example, 20984. I would like change it to YYYYMMDD10.

I have attempted

Data TESTDATA;

Set TESTDATA;

mortality = input (put(deathdate, 8.) YYMMDD10.);

format mortality YYMMDD10.;

run;

But it failed and provides values for example 2002-07-23 which is incorrect. The data is from year 2016 and 2017.

Any help is appreciated. Thanks!

Re: How to convert a numeric to date format in SAS?

PaigeMiller — Tue, 18 Apr 2023 18:03:30 GMT

May I ask what date 20984 represents? It may be that it is supposed to represent 14JUN2017. If so, there is no need to "convert" it to anything, and you certainly cannot convert it to have a specific format, that would be an incorrect use of the language.

All you have to do is assign the proper format to the variable.

data testdata1;
    set testdata;
    format deathdate yymmdd10.;
run;

or use any other date format you want.

Better yet

proc datasets library=work;
    modify testdata;
    format deathdate yymmdd10.;
run; quit;

and now you don't have to read every row in the entire data set just to assign a format to one variable.

Re: How to convert a numeric to date format in SAS?

WishShahid — Tue, 18 Apr 2023 18:26:11 GMT

Thank you for your response! Yes date 20984 represents 14JUN2017. I am a new user of sas. I would like to export this SAS file to SPSS. I have attempted to export into SPSS or excel where I do not get equivalent values in date format.

Re: How to convert a numeric to date format in SAS?

PaigeMiller — Tue, 18 Apr 2023 18:34:36 GMT

Your SPSS question probably belongs in a new thread with appropriate subject line. Or better yet, ask in an SPSS forum.