topic Re: Converting date to date9. gives wrong dates in SAS Programming

Converting date to date9. gives wrong dates

advmsj — Mon, 24 Aug 2020 16:52:54 GMT

Hi there, when converting dates imported from excel to date9. I am receiving the wrong dates. When reviewing the proc contents, I noticed the format and informat of my imported variable is $10. Does anyone have a suggestion on how I can properly convert the dates to date9.?

Re: Converting date to date9. gives wrong dates

Kurt_Bremser — Mon, 24 Aug 2020 17:01:07 GMT

So you have certain values in your date column that are neither dates nor missing (empty), which causes PROC IMPORT to import that as character. Either fix the values in the spreadsheet, or run a correcting data step on the imported dataset:

data import2 (drop=_date);
set import (rename=(date=_date));
date = input(_date, informat.);
format date date9.;
run;

Insert the fitting informat in place of "informat.".

Re: Converting date to date9. gives wrong dates

advmsj — Mon, 24 Aug 2020 17:14:10 GMT

Perfect, thank you!