Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | John Whitmer <jcwhitmer@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: RE: Data Filtering Question ... |
Date | Fri, 24 Sep 2010 14:14:28 -0700 |
Excellent! this worked perfectly, and I can now concatenate! Best, John On Sep 24, 2010, at 2:08 PM, Dimitriy V. Masterov wrote: You can try this: list if (hascontent_binary==1) & (totalstudents > 10 & !mi(totalstudents)) & inrange(TotalHits, 50,100000) On Fri, Sep 24, 2010 at 4:26 PM, John Whitmer <jcwhitmer@gmail.com> wrote: > Martin, > > This appears to work when I enter it into the filter menu, but when I enter an additional filter, it removes the previous one. I tried the first filter, which worked well, but when I added the second filter, there were additional records - I'm assuming that it deleted the first one. > > Is there a way to apply multiple filters from that window simultaneously? > > I've tried the command window, which takes a long time to process, but did not filter out any observations. > > Again, much appreciate your help. > > Best, John > > On Sep 24, 2010, at 1:17 PM, Martin Weiss wrote: > > > <> > > You are more than welcome, John! You could also -browse if...- > > > HTH > Martin > > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu > [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of John Whitmer > Sent: Freitag, 24. September 2010 22:15 > To: statalist@hsphsun2.harvard.edu > Subject: Re: st: RE: Data Filtering Question ... > > Thank you, thank you, thank you!! > > -John > > On Sep 24, 2010, at 1:11 PM, Martin Weiss wrote: > > > <> > > *********** > list if hascontent_binary==1 > list if totalstudents > 10 & !mi(totalstudents) > list if inrange(TotalHits, 50, 100000) > *********** > > > HTH > Martin > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu > [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of John Whitmer > Sent: Freitag, 24. September 2010 22:04 > To: statalist@hsphsun2.harvard.edu > Subject: st: Data Filtering Question ... > > I just installed Stata v11 this morning, and have been getting my hands > dirty. As you might tell, I'm analyzing a dataset from a Learning > Management System for a university. > > I'm flummoxed about how to filter data. I'd appreciate your help, I've > tried the help files and searched the web to little avail. I've found the > "Filter Observations" menu, but all my expressions are returning errors. > > Here are examples of the filters I'd like to run: > > Variable "hascontent_binary" =1 > Variable "totalstudents" > 10 > Variable "TotalHits" is between 50 and 100,000 > > Apologies for the newbie question - you can relieve a headache today! > > Thanks, John > > > ********************************************* > John Whitmer > E: jcwhitmer@gmail.com > P: 530.554.1528 > C: 530.574.8827 > Skype: john.whitmer > > > > > * > * 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/ > > ********************************************* > John Whitmer > E: jcwhitmer@gmail.com > P: 530.554.1528 > C: 530.574.8827 > Skype: john.whitmer > > > > * > * 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/ > > ********************************************* > John Whitmer > E: jcwhitmer@gmail.com > P: 530.554.1528 > C: 530.574.8827 > Skype: john.whitmer > > > > > * > * 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/ ********************************************* John Whitmer E: jcwhitmer@gmail.com P: 530.554.1528 C: 530.574.8827 Skype: john.whitmer * * 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/