excel to stata

October 11, 2011 at 09:48:07
Specs: mac os10.7
i am attempting to transfer excel data into stata. i use stat transfer to do this. the conversion unfortunately, causes all transferred dates to be off by 4 years. i assume this is due to the excel preference that starts dates counting in 1904. however, when i uncheck this option in excel it changes all my dates to ones 4 years earlier.

is there a way to turn off the excel option to start dates in 1904 without changing all the dates in the spreadsheet.


See More: excel to stata

Report •

#1
October 11, 2011 at 13:21:26
Look here under the heading:

Correcting Shifted Dates

http://support.microsoft.com/kb/180162

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question