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]
Re: st: Is there a way to replace a variable with a missing value without knowing if it is numeric or string?
From
Phil Clayton <[email protected]>
To
[email protected]
Subject
Re: st: Is there a way to replace a variable with a missing value without knowing if it is numeric or string?
Date
Fri, 26 Jul 2013 18:14:59 +1000
The easiest solution is probably the brute force approach:
foreach var in name age position startdate {
capture replace `var' = . if indicator == 1
capture replace `var' = "" if indicator == 1
}
A more elegant solution might use -ds-, -confirm- or the "type" macro extended function (-help extended_fcn-), but the above solution is fast and simple.
Phil
On 26/07/2013, at 5:18 PM, "Gupta, Ani" <[email protected]> wrote:
> I have a series of variables, - say name, age, position, startdate - some of which are numeric and some of which are string. I want to replace their values with missing values if another variable, indicator is equal to 1.
>
> In other words I want to be able to write something like this:
>
> foreach var in name age position startdate {
> replace `var' = _missing_ if indicator == 1
> }
>
> Is there a way I can do this in a single loop for numeric and string variables?
>
>
> *
> * 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/
*
* 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/