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

stancemcgraw — Sat, 26 Sep 2020 00:06:22 GMT

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

43102

43103

43104

43105

data want;

DOA

1/1/18

1/2/18

1/3/18

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

Tom — Sat, 26 Sep 2020 13:29:35 GMT

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.;

topic Re: Change character date in format $13. to ddmmyy10. numeric in SAS Programming

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

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