Change character date in format $13. to ddmmyy10. numeric

[stancemcgraw]

Hi all,

  My date of arrivals were in excel as '1/1/18' and there must have previously been some character code in the column, because when I imported to SAS it changed to $13. and looks like '43101' except it's now in character. Any ideas how to change it back to the original numeric date? Either mmddyy10 or ddmmyy10?

Data have;

DOA

43101

43101

43102

43103

43104

43105

data want;

DOA

1/1/18

1/1/18

1/2/18

1/3/18

[Tom · Accepted solution]

To change the string values to date values first convert to a number and then adjust for the difference in how Excel and SAS count dates.  Then you can attach any date type format you want to have the values display in a human readable way.

date = input(doa,32.)+'30DEC1899'd ;
format date date9.;