Hello
I downloaded WDI in panel format from World Bank website, did some cleaning in excel and imported it to Stata but xtset command results to:
xtset CountryNum Year, yearly
panel variable: CountryNum (unbalanced)
time variable: Year, 1967 to 2016, but with gaps
delta: 1 year
Is there a way to find out which year is missing so I could just drop years from that and earlier? Earlier years mostly have missing data anyway.. Or is there a better solution to this? Hoping for a response. Thank you!
I downloaded WDI in panel format from World Bank website, did some cleaning in excel and imported it to Stata but xtset command results to:
xtset CountryNum Year, yearly
panel variable: CountryNum (unbalanced)
time variable: Year, 1967 to 2016, but with gaps
delta: 1 year
Is there a way to find out which year is missing so I could just drop years from that and earlier? Earlier years mostly have missing data anyway.. Or is there a better solution to this? Hoping for a response. Thank you!
Comment