I'm trying to link different business locations to appropriate zip codes using a do-file. I have business names in a name variable and created a new variable to hold the zipcode. Some of the business names are similar but they have a location indicator at the end such as "Office - Allendale" and "Office-Grand Rapids". I tried using a replace command with an if statement but it doesn't appear that I can use wildcards in that. Is there a way for me to do this? Below is how I'm currently doing it...
replace zip="49401" if locationname==" Office - Allendale"
This works for just a few instances but I have a health system with hundreds of entries so trying to avoid having to individually manage each one since they have the embedded location descriptor" Thank you!
Related Posts with wildcard in string variable
Can Stata 16 frames be appended?Fellow Statalsters (especially StataCorp) Many thanks to StataCorp for Stata 16. The frames are a s…
Mixed-effects logistic regression for panel dataHello, I am using mixed-effects logistic regression for panel data in STATA 15, and I was wondering …
Combining local macros in StataI am trying to create a loop that copies specific files (which have a specific identifier at the end…
Blog entry on quickly setting up Python with Stata 16Here is my first blog entry on how to quickly set up Python with Stata 16 https://fintechprofessor.c…
Ereturn Scalar on MI Estimate?Hi All, I currently am trying to perform a bootstrap on mi estimate: logistic. However, when I run …
Subscribe to:
Post Comments (Atom)
0 Response to wildcard in string variable
Post a Comment