CODEWITHSUNDEEP
stata
Marlen
Marlen

Reputation: 9

Deleting missing values

I'm trying to clean my panel data set in Stata, which includes data on GDP growth rates for different countries over 5 years. I would like to delete all rows, which have missing values (denoted as .. in the data set). Each row has an id (gene row_id = _n). For example, if I want to delete all missing values of the variable YR2013, I use the code: drop if YR2013==. and the error message type mismatch appears. Can someone tell me how to delete the values?

Upvotes: 0

Views: 141

Answers (1)

Nick Cox
Nick Cox

Reputation: 37183

The type mismatch message indicates that your variable is really string. That being so 

drop if missing(real(YR2013)) 
destring YR2013, replace

is a way forward, as your variable will be no use otherwise.

A more general recipe is 

destring *, ignore("..") replace

Upvotes: 2

Related Questions