Richard Goldstein
>
> I am trying to count, within each observation, across
> a set of variables (about 190 of them), the number of
> times a particular type of missing occurs (denoted
> .b for numeric variables and "888888" for string variables).
> Note that the set of variables includes both numeric and
> string variables (and I would strongly prefer not to
> separately list them in two statements using Nick Cox's
> -rcount- if I don't have to).
I'd avoid that too if I were me. However, I can't
see how to avoid some bifurcation of code to
cope with these distinct cases. How about
gen mymiss = 0
foreach v of var <myvarlist> {
cap replace mymiss = mymiss + (`v' == "888888")
cap replace mymiss = mymiss + (`v' == .b)
}
OR
gen mymiss = 0
ds, has(type numeric)
foreach v of var `r(varlist)' {
replace mymiss = mymiss + (`v' == .b)
}
ds, has(type string)
foreach v of var `r(varlist)' {
replace mymiss = mymiss + (`v' == "888888")
}
Nick
[email protected]
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
