Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Grace Jessie <gracejessie@hotmail.com> |
To | <statalist@hsphsun2.harvard.edu> |
Subject | RE: st: How to list all the observation meeting the conditions which are the former results? |
Date | Sun, 12 Dec 2010 14:38:48 +0000 |
Thank you for reply. It seems the problem has not been solved. I do not want to list all the observations meeting "z<5". Firstly, I get the combination of x and y appearing in the results of "z<5". Then I want to list all the observations with the combination of x and y, maybe in the current data or in another data. In my firt posting, "I know -levelsof- can solve the problem if not the combination but just one variable." For example, levelsof x if z<5,loc(a) foreach i of loc a { l if x==`i' } Now I doubt if not a variable but a combination (such as two variables), how to do it? Grace ---------------------------------------- > From: eric.de_souza@coleurope.eu > To: statalist@hsphsun2.harvard.edu > Date: Sun, 12 Dec 2010 15:13:40 +0100 > Subject: RE: st: How to list all the observation meeting the conditions which are the former results? > > input x y z > .... > gen id = _n > l > preserve > keep if z<5 > l > restore > > This way you have the observation numbers in the original dataset > > Or do you want something else? > > Eric de Souza > College of Europe > BE-8000 Brugge (Bruges) > Belgium > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Grace Jessie > Sent: 12 December 2010 13:46 > To: statalist@hsphsun2.harvard.edu > Subject: st: How to list all the observation meeting the conditions which are the former results? > > Dear statalists, > How to list all the observation meeting the conditions which are the former results? > For example, > . clear > . input x y z > x y z > 1. 1 2 8 > 2. 1 2 2 > 3. 2 3 4 > 4. 2 3 9 > 5. 2 4 8 > 6. end > . l > +-----------+ > | x y z | > |-----------| > 1. | 1 2 8 | > 2. | 1 2 2 | > 3. | 2 3 4 | > 4. | 2 3 9 | > 5. | 2 4 8 | > +-----------+ > . l if z<5 > +-----------+ > | x y z | > |-----------| > 2. | 1 2 2 | > 3. | 2 3 4 | > +-----------+ > Now I want to list all the observations for each x and y combination in the former results,i.e.,(x==1 & y==2) | (x==2 | y==3). > I know I can type "l if (x==1 & y==2) | (x==2 | y==3)". > However, typing one by one is troublesome if the number of the combinations for the former results is large. > I know -levelsof- can solve the problem if not the combination but just one variable. > Is there a way like -levelsof- ? > Thank you! > Grace > > * > * 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/ > > * > * 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/ * * 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/