Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: RE: Dropping Countries
From
Nick Cox <[email protected]>
To
"'[email protected]'" <[email protected]>
Subject
st: RE: Dropping Countries
Date
Wed, 24 Nov 2010 10:29:25 +0000
bysort Countryname (ses) : drop if missing(ses[1]) & missing(ses[_N])
If, after -sort-ing on -ses- within -CountryName-, it is true that the first observation for a country contains a missing value and also that the last observation does, then they all do.
See if more detail is needed
SJ-2-1 pr0004 . . . . . . . . . . Speaking Stata: How to move step by: step
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . N. J. Cox
Q1/02 SJ 2(1):86--102 (no commands)
explains the use of the by varlist : construct to tackle
a variety of problems with group structure, ranging from
simple calculations for each of several groups to more
advanced manipulations that use the built-in _n and _N
Nick
[email protected]
ajjee
I have the data for near 180 countries for many variables over 26 years but
I want to drop that countries which have no data for a specific variable.
tab countryname if ses==.
CountryName | Freq. Percent Cum.
-----------------------------+-----------------------------------
Algeria | 26 2.30 2.30
Angola | 26 2.30 4.59
Armenia | 26 2.30 6.89
Azerbaijan | 11 0.97 7.86
Belarus | 11 0.97 8.83
Benin | 26 2.30 11.13
Bermuda | 26 2.30 13.43
Bosnia and Herzegovina | 12 1.06 14.49
Burkina Faso | 26 2.30 16.78
Cameroon | 26 2.30 19.08
Congo, Dem. Rep. | 26 2.30 21.38
Congo, Rep. | 26 2.30 23.67
Cote d'Ivoire | 26 2.30 25.97
Dominica | 26 2.30 28.27
Equatorial Guinea | 26 2.30 30.57
Now I want to drop only countries where ses is missing for all years. Is
there any command to do so?
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/