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

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

Correcting Shifted Dates




Report •
Related Solutions

Ask Question