Date field in SAS imported in Python pandas Dataframe
Question: I have imported a SAS dataset in python dataframe using Pandas
`read_sas(path)` function. REPORT_MONTH is a column in sas dataset defined and
saved as DATE9. format. This field is imported as float64 datatype in
dataframe and having numbers which is basically a sas internal numbers for
storing a date in a sas dataset. Now wondering how can I convert this
originally a date field into a date field in dataframe?


Answer: I don't know how python stores dates, but SAS stores dates as numbers,
counting the number of days from Jan 1, 1960. Using that you should be able to
convert it in python to a date variable somehow.

I'm fairly certain that when data is imported to python the formats aren't
honoured so in this case it's easy to work around this, in others it may not
be.

There's probably some sort of function in python to create a date of Jan 1,
1960 and then increment by the number of days you get from the imported
dataset to get the correct date.

