[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"fhuebler@gmail.com" <fhuebler@gmail.com> |

To |
"statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |

Subject |
st: Increase speed of -replace- |

Date |
Thu, 8 May 2008 12:31:52 -0700 |

I am looking for a way to increase the speed of -replace-. I have a long string variable consisting of several words that should be reduced to a shorter string, depending on the text in each observation. The problem can be reproduced with the auto data. Assume that we want to replace the text in the variable "make" by a single word. Assume further that the text we are looking for (e.g. "Chev.") is not necessarily at the beginning of the string but that it can be anywhere in the variable. My solution is shown below but it is slow with more than 200 -replace- commands and about 150,000 observations. Is there a faster solution? sysuse auto replace make = "AMC" if strpos(make,"AMC")>0 replace make = "Buick" if strpos(make,"Buick")>0 replace make = "Cadillac" if strpos(make,"Cad.")>0 replace make = "Chevrolet" if strpos(make,"Chev.")>0 replace make = "Dodge" if strpos(make,"Dodge")>0 Thanks, Friedrich * * 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/ Privileged, confidential or patient identifiable information may be contained in this message. This information is meant only for the use of the intended recipients. If you are not the intended recipient, or if the message has been addressed to you in error, do not read, disclose, reproduce, distribute, disseminate or otherwise use this transmission. Instead, please notify the sender by reply e-mail, and then destroy all copies of the message and any attachments. * * 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/

- Prev by Date:
**st: RE: Increase speed of -replace-** - Next by Date:
**st: propensity score matching** - Previous by thread:
**Re: st: Re: Increase speed of -replace-** - Next by thread:
**st: propensity score matching** - Index(es):

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