topic Re: Convert Dates Imported as 99999999 into Date Format in SAS in SAS Programming

Convert Dates Imported as 99999999 into Date Format in SAS

rangarat — Thu, 07 Feb 2019 13:22:28 GMT

I am converting dates in numeric format in my Access database that I've imported into SAS into date format in SAS. There are a few that are entered as 99999999 in Access and have converted into dates. How would I handle these?

Re: Convert Dates Imported as 99999999 into Date Format in SAS

PaigeMiller — Thu, 07 Feb 2019 13:25:08 GMT

I would probably handle these as missing values in SAS.

Re: Convert Dates Imported as 99999999 into Date Format in SAS

rangarat — Thu, 07 Feb 2019 13:27:14 GMT

Hi! I think I'm expecting it to be more complicated than this, and maybe this is the solution. I was also curious about those dates that have a month and year, but no day (it's entered as 12/99/10 for example). Is it safe to handle these as missings, too?

Re: Convert Dates Imported as 99999999 into Date Format in SAS

PaigeMiller — Thu, 07 Feb 2019 13:54:36 GMT

@rangarat wrote:
Hi! I think I'm expecting it to be more complicated than this, and maybe this is the solution. I was also curious about those dates that have a month and year, but no day (it's entered as 12/99/10 for example). Is it safe to handle these as missings, too?

How can anyone here across the internet answer this question? We don't know the situation you are in, what the data is, why you are using this data, or what analysis will be performed. And we don't even know what you mean by "safe".

Re: Convert Dates Imported as 99999999 into Date Format in SAS

ballardw — Thu, 07 Feb 2019 15:24:53 GMT

@rangarat wrote:
Hi! I think I'm expecting it to be more complicated than this, and maybe this is the solution. I was also curious about those dates that have a month and year, but no day (it's entered as 12/99/10 for example). Is it safe to handle these as missings, too?

Actually with that specific example you cannot be sure which of any of those "fields" is a day, a month or a year. That could be the 10th day of an unidentified month in 2012 of 1912 (or 1812), the unspecified month for day 12 in 2010 or 1910 as well as an unknown day in month 12.