Re: st: Is there a way to replace a variable with a missing value without knowing if it is numeric or string?

[Phil Clayton <philclayton@internode.on.net>]

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" <agupta@compasslexecon.com> 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/