Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Re: replace a string variable


From   "Paolo Grillo, MD" <paolo.grillo@guest.unimi.it>
To   statalist@hsphsun2.harvard.edu
Subject   st: Re: replace a string variable
Date   Mon, 09 May 2005 16:11:21 +0200

Dear Statalist
I have a dataset with a string variable named VEND. It contains a lot of different companies with a varied different names although often they indicate the same company.
For example for three different firms

STRYKER ITALIA SRL
STRYKER ITALIA SRL -
STRYKER ITALIA SRL S
         STRYKER SRL
       STRYKERITALIA
   STYKER ITALIA SRL
              SULZER
       SULZER MEDICA
SULZER OR ITALIA SPA
  SULZER ORTHOPEDICS
SULZER ORTHOPEDICS I
   SULZER ORTHPEDICS
    SULZER ORTOPEDIC
SULZER ORTOPEDICA IT
SULZER ORTOPEDICS IT
       SULZER PROTEK
        SULZERMEDICA
              ZIMMER
    ZIMMER - NEX GEN
          ZIMMER ARL
       ZIMMER S.R.L.
ZIMMER S.R.L.     (C
          ZIMMER SRL



Where the names are easily
STRYKER
SULZER
ZIMMER

How can I replace these strings with the same cluster name?
Do you know if there is a similar command as
. replace vend if  vend=="zimmer***"
or I have to build a do file with a lot of -substr- and -index- command
Thanks in Advance
Paolo Grillo

-- 



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 

Paolo Grillo MD
Nephrologist 
Statisticians
EPOCA Research Center for Occupational, Clinical & Environmental Epidemiology
Department of Occupational and Environmental Health "Clinica L. Devoto"
University of Milan
Via San Barnaba 8
20122 Milano - ITALY
Tel: +39 02 503-20148
Fax: +39 02 503-20126
E-Mail paolo.grillo@guest.unimi.it


* * For searches and help try: * http://www.stata.com/support/faqs/res/findit.html * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/



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