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

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

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 |
Mon, 13 Dec 2010 09:32:11 +0000 |

Eric and Keith, thank you very much! Both of the methods you provided work well. Grace ---------------------------------------- > Subject: RE: st: How to list all the observation meeting the conditions which are the former results? > Date: Mon, 13 Dec 2010 09:49:28 +1100 > From: Keith.Dear@anu.edu.au > To: statalist@hsphsun2.harvard.edu > > Or maybe something like this? > > > preserve > keep if z==5 > keep x y > duplicates drop > sort x y > tempfile pairs > save `pairs' > restore > sort x y > merge m:1 x y using `pairs' > list if _merge==3 > > > > > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu > [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Eric Booth > Sent: Monday, 13 December 2010 9:26 AM > To: > Subject: Re: st: How to list all the observation meeting the conditions > which are the former results? > > <> > > You could build your -if- conditions in a macro, see the example below: > > **********************! > //1. dataset_target// > /* > you will apply the conditions in which z<=5 > in the "dataset_source" to this dataset later on > */ > > clear > set obs 5000 > foreach a in x y z { > g `a' = int(abs(runiform()*50)) > } > sa "dataset_target.dta", replace > > > > > //2. dataset_source// > /* > this is the dataset where you get the values > of x & y where z<=5 > */ > > clear > set obs 50 > foreach a in x y z { > g `a' = int(abs(runiform()*50)) > } > > l if z<=5 > > //3. put x&y pairs where z<=5 in global macro // > global myif > forval n = 1/`=_N' { > if `=z[`n']'<=5 { > global myif | (x==`=x[`n']' & y==`=y[`n']') $myif > di in r "$myif" > } > } > global myif:subinstr global myif "|" "" > global myif if $myif > > > *--Here are the conditions where z<=5--* > di in y "$myif" > > *--list these obs. in source dataset--* > li z $myif > > > > //4. use conditions in global $myif on target dataset(s)// > u "dataset_target.dta", clear > li z $myif > **********************! > > - Eric > __ > Eric A. Booth > Public Policy Research Institute > Texas A&M University > ebooth@ppri.tamu.edu > Office: +979.845.6754 > Fax: +979.845.0249 > http://ppri.tamu.edu > > > > On Dec 12, 2010, at 8:38 AM, Grace Jessie wrote: > > > 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/

**References**:**st: How to list all the observation meeting the conditions which are the former results?***From:*Grace Jessie <gracejessie@hotmail.com>

**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>

**RE: st: How to list all the observation meeting the conditions which are the former results?***From:*Grace Jessie <gracejessie@hotmail.com>

**Re: st: How to list all the observation meeting the conditions which are the former results?***From:*Eric Booth <ebooth@ppri.tamu.edu>

**RE: st: How to list all the observation meeting the conditions which are the former results?***From:*"Keith Dear" <Keith.Dear@anu.edu.au>

- Prev by Date:
**st: regress with vce(robust) and hascons** - Next by Date:
**Re: st: How to define an external Mata class within the namespace of an ado-file** - Previous by thread:
**RE: st: How to list all the observation meeting the conditions which are the former results?** - Next by thread:
**st: Different FE estimates** - Index(es):