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 on April 23, and its replacement, statalist.org is already up and running.


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

Re: st: drop range of variables meeting condition in another variable


From   Nick Cox <njcoxstata@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: drop range of variables meeting condition in another variable
Date   Mon, 18 Mar 2013 20:26:35 +0000

Last line should be

drop `todrop'

Nick

On Mon, Mar 18, 2013 at 8:02 PM, Nick Cox <njcoxstata@gmail.com> wrote:
> At a guess, you want to -drop- all gene variables that are identically
> zero. That is
>
> findname gene*, all(@==0)
>
> drop `r(varlist)'
>
> where -findname- is to be found by -search findname- and downloaded
> from the Stata Journal files.
>
> It is not so difficult without -findname-, either.
>
> foreach v of var gene* {
>        su `v', meanonly
>        if r(max) == 0 local todrop `todrop' `v'
> }
> drop `v'
>
> Nick
>
> On Mon, Mar 18, 2013 at 7:53 PM, Tamer Farag
> <tfarag@medicine.umaryland.edu> wrote:
>
>> I am working with a case control dataset with gene clusters variables.  I have approx 100 observations, a handful of essential variables, but approx. 14,000 variables for each observation that represent gene clusters (absent/present, 0/1).  The gene variables are all located next to each other in the dataset (i.e., gene1-gene14000).
>>
>> I would like to drop variables for gene clusters that are not present among my cases.  Obviously, specifying each gene cluster variable would be impractical.
>>
>> Is there any way to do this in Stata?  I'm stumped.

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


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