From: "Nick Cox" <[email protected]>
Reply-To: [email protected]
To: <[email protected]>
Subject: st: RE: two STATA questions
Date: Tue, 27 Feb 2007 01:25:37 -0000
Answers sprinkled below.
Nick
[email protected]
Ni Frank
> Hi, I have two basic questions on STATA.
Please read, learn and inwardly digest
http://www.stata.com/support/faqs/res/statalist.html#spell
Also, there is no reason to invent your own conventions.
Write -drop- and -keep- below. This is explained in the FAQ
(again).
> 1) There are 50 varialbes, w05100, w05200,....,w10000. We
> want to DROP
> those obversations for which at least one of the above
> variables takes
> value of 0. When I use "drop if w*==0, it said "W* invalid name".
> Does anybody know what's wrong?
That's illegal. You can't put a wildcard there after -if-. An expression
can go there, but a wildcard doesn't qualify as an expression.
Here is one way to do it.
gen byte count = 0
qui forval i = 5100(100)10000 {
replace count = count + (w0`v' == 0)
}
drop if count
> 2) Now, if we want to KEEP those obersvations for which at least one
> of the variables w05100, w05200, ....,w09900 takes value of 0. How to
> do that?
It's the same story, except for -keep- instead of -drop-.
*
* 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/
_________________________________________________________________