Dear listers
Sorry foe multiple postings, my puter froze and I thought nothing had gone
through.
Roni
--- Babigumira Ronnie <[email protected]> wrote:
> Hi Ken Higbee
> Thanks for the help, I will try to explain my problem to you using your
> example. Lets assume that a b and c are crops and we also know that they
> can take on a given set of values 1 2 3 4 5 8 9 10 (as such 6 7 and
> anything greater than 10 should be a problem and that's what I want to
> flash out)
>
> If we deal with them one by one
>
> Starting with a and going thru
>
> . egen ain = eqany(a), v(1/5 8/10) /*ain means a is in range*/
>
> . list a if !ain /*all observations out of range*/
>
> a
> 6. 6
> 7. 7
>
> .
> . egen bin = eqany(b), v(1/5 8/10)
>
> . list b if !bin
>
> b
> 4. 6
> 5. 7
> 9. 11
> 10. 12
>
> .
> . egen cin = eqany(c), v(1/5 8/10)
>
> . list c if !cin
>
> c
> 2. 6
> 3. 7
> 7. 11
> 8. 12
> 9. 13
> 10. 14
>
> Now, here is my thinking, since a b and c take on the same range of
> values, instead of going thru the above, I thought that (as you
> suggested)
>
>
> . egen z = eqany(a b c) , v(1/5 8/10)
>
> should list all the a's b's and c's out of the range, however, this is
> what I get
>
> . egen z = eqany(a b c) , v(1/5 8/10)
>
> . list if !z
>
> a b c z
>
> Nothing is listed. So my question is that am I misusing the command?
>
> Thanks
>
> Roni
>
> --- [email protected] wrote:
> > Babigumira Ronnie <[email protected]> asks:
> >
> > > I have 3 variables percr100 percr200 percr300 (perennial crops
> grown),
> > I
> > > know the range of these crops so I list illegal entries for percr100
> > using
> > >
> > > egen perbc1 = eqany(percr100), v(-7 440/446 660/670 770/789)
> > > list houscode percr100 if !perbc1
> > >
> > > then I look at the manual and eqany can be followed by varlist so
> > instead
> > > of doing the above for all the three, I
> > >
> > > egen perbc = eqany(percr100 percr200 percr300), v(-7 440/446 660/670
> > > 770/789)
> > > list houscode percr100 percr200 percr300 if !perbc
> > >
> > > And the results are wrong, it appears that only the first variable
> was
> > > inspected. Did I just misinterpret eqany. In the event that I did
> > (very
> > > likely) whats the way out
> >
> > Can you show us an example of how the results were wrong? Here
> > is a simple example I ran that worked just fine.
> >
> > . set obs 10
> > obs was 0, now 10
> >
> > . gen a = _n
> >
> > . gen b = _n+2
> >
> > . gen c = _n+4
> >
> > . egen z = eqany(a b c) , values(1 4 9 12)
> >
> > . list
> >
> > a b c z
> > 1. 1 3 5 1
> > 2. 2 4 6 1
> > 3. 3 5 7 0
> > 4. 4 6 8 1
> > 5. 5 7 9 1
> > 6. 6 8 10 0
> > 7. 7 9 11 1
> > 8. 8 10 12 1
> > 9. 9 11 13 1
> > 10. 10 12 14 1
> >
> > Ken Higbee [email protected]
> > StataCorp 1-800-STATAPC
> >
> > *
> > * 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/
>
>
> __________________________________________________
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
> *
> * 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/
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
*
* 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/