Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# RE: st: How to list all the observation meeting the conditions which are the former results?

 From DE SOUZA Eric 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 15:13:40 +0100

```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/
```