topic Converting number of days since Jan 1 1960 to YYYYMMDD in SAS Programming

Converting number of days since Jan 1 1960 to YYYYMMDD

Wolverine — Wed, 24 Apr 2019 12:54:57 GMT

Seems like this should be a very simple task, but I've been searching and I can't find a straight answer.

I have a variable named IMGDate that contains the number of days since Jan 1 1960. For example, 21164 represents Sept 27, 2017.

I want to convert this variable so that 21164 is in 20170927 format.

Kurt_Bremser — Wed, 24 Apr 2019 13:06:33 GMT

Use the YYMMDDN8. format.

Rick_SAS — Wed, 24 Apr 2019 13:10:35 GMT

There are several SAS formats that show dates. My favorite is DATA9., but here is a link to some others.

Just use the FORMAT statement to assign a format to a variable:

data A;
format IMGDate DATE9.;
IMGDate = 21164;
run;

proc print; run;