Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From   DE SOUZA Eric <eric.de_souza@coleurope.eu>
To   "'statalist@hsphsun2.harvard.edu'" <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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index