1900 start date

[Sandra Summers]

Sorry, I made the mistake of posting this in an old thread with similar problem.

1900 Start Date
I have a very basic question. I have imported and XLS file into Stata. The year variable is %10.0g my years are 2013,2014,2015 ......2020

However the xtdescribe gives

code: 10000163, 10000216, ..., 10083476 n = 280
year: 1900, 2013, ..., 2020 T = 9
Delta(year) = 1 unit
Span(year) = 121 periods
(code*year uniquely identifies each observation)

I have checked the data and there are no 1900 in the list, and there are no missing values in the year column.

Please can you tell me how to correct the data for this? Many thanks

[Andrew Musau]

Can you copy and paste the result of the following:

preserve
egen todataex = tag(year)
keep if todataex
dataex
restore

[Jared Greathouse]

Another way of tackling the problem would be to do

su year
di r(min)

immediately after importing the data, since then you'd see if, in fact, 1900 is in there at all.

[Sandra Summers]

Thank you so much. I have now located the stray 1900 which I had missed.

I really appreciate you taking th etime to reply.