st: Re: how to select all the numerical variable

[Dan Blanchette <dan.blanchette@duke.edu>]

So now that you have a list of all the numeric variables
in the local macro r(varlist) you need to create a -foreach- loop:

ds, has(type numeric)

foreach var of varlist `r(varlist)' {
  replace `var' = .  if `var' == 0.0001
}

Best,

Dan Blanchette
Research Associate
Center for Entrepreneurship and Innovation
Duke University's Fuqua School of Business
dan.blanchette@duke.edu


----- Original Message ----- From: "Martin Weiss" <martin.weiss1@gmx.de>

sysuse auto, clear
ds, has(type numeric)
di in red "Numeric vars: `r(varlist)'"

HTH
Martin
_______________________

----- Original Message ----- From: "Martin Wang" <zwang215@gmail.com>

To: "statalist" <statalist@hsphsun2.harvard.edu>
Cc: "zwang215" <zwang215@gmail.com>
Sent: Friday, June 19, 2009 7:06 PM
Subject: st: how to select all the numerical variable



    Dear Statalist,


    Can I ask a question? Is there any way that I can select all the numerical variable in a dataset? For example, I want to use:

    for var equity net_income cash_fixinv : replace X=. if X==0.0001


    But I have a lot of numerical variables like equity, net_income... but I don't want to list all of them. Is there any way to get around of this?

    Many thanks in advance!

    Martin


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