Re: st: Identify and Replace Values

[Eric Booth <ebooth@ppri.tamu.edu>]

<>

Try using -subinstr()-

	replace var = subinstr(var, " ", "_", .)

~ Eric

__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754

On Jul 12, 2010, at 2:05 PM, Tobias Friedli wrote:

> Thanks. This would be exactly what i am looking for. But it seems like this command was introduced in Stata 11 and i am stil working with Stata 10. Can i download this function somehow, so i can use it in Stata 10? Or is there a similar function?
> 
> On Mon, 12 Jul 2010 20:56:03 +0200
> "Martin Weiss" <martin.weiss1@gmx.de> wrote:
>> <>
>> ***********
>> h strtoname
>> ***********
>> HTH
>> Martin
>> -----Original Message-----
>> From: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Tobias Friedli
>> Sent: Montag, 12. Juli 2010 20:35
>> To: statalist@hsphsun2.harvard.edu
>> Subject: Re: st: Identify and Replace Values
>> Thank you very much, it seems to work like a charm. Only Problem is, that the some Model-names contain spaces and then Stata says "invalid name". I know there is a command to relpace all the spaces by an underscore, but i can't find it anymore. Anybody knows this command? Thanks
>> On Mon, 12 Jul 2010 13:52:46 -0400
>> Jeph Herrin <stata@spandrel.net> wrote:
>>> how about
>>> levelsof traded_model, local(traded)
>>> levelsof new_model, local(new)
>>> local onlytraded : list traded - new
>>> local onlynew    : list new - traded
>>> local others     : list onlynew | onlytraded
>>> replace traded_model="others" if inlist(traded_model,"`others'")
>>> replace new_model   ="others" if inlist(new_model,"`others'")
>>> hth,
>>> Jeph
>>> On 7/12/2010 12:18 PM, Hobst wrote:
>>>> Hello
>>>> 
>>>> I have a huge dataset containing automotive brand-swiching data. I have a
>>>> variable called traded_model and another variable called new_model. in order
>>>> to output a symmetric swiching matrix i need to identify all the expressions
>>>> that are eigther only in traded_brand or only in new_brand and replace
>> the
>>>> expression with "others". For example a model called "318d" exists in
>>>> traded_model but not in new_model, so all the "318d" should be replaced
>> by
>>>> "others".
>>>> 
>>>> Does anyone have an idea how i can programm that? I dont get it to work, and
>>>> doing it manually is close to impossible as there are more than 1000
>>>> different model names.
>>>> 
>>>> Any help is much appreciated, thank you.
>>> *


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