Dear Svend,
Thanks for your time. It really seems that will work.
> Subject: Re: st: using the command substr in stata
> Date: Wed, 30 Jul 2008 09:44:37 +0200
> From: [email protected]
> To: [email protected]
>
>
> Carmen wrote:
>
> I have a string variable called disease_ICD (oldvar) which has
> the values of "International Statistical Classification of
> Diseases and Related Health Problems - ICD 9 and ICD 10"
>
> I need to create a new variable disease_ICDgroup (newvar)
> containing grouped values of disease_ICD (oldvar). The
> equivalent in EPI INFO is:
>
> . Define newvar TEXTINPUT
>
> . IF(substring(oldvar,1,3)>="001"AND substring(oldvar,1,3)<"799"THEN
> ASSIGN newvar ="1" END
>
> . IF(substring(oldvar,1,3)>="A00"AND substring(oldvar,1,3)<"U99"THEN
> ASSIGN newvar ="1" END
>
> . IF(substring(oldvar,1,3)>="800"AND substring(oldvar,1,3)<"999"THEN
> ASSIGN newvar ="2" END
>
> . IF(substring(oldvar,1,3)>="V00"AND substring(oldvar,1,3)<"Y99"THEN
> ASSIGN newvar ="2" END
>
> Note: The first three characters from oldvar are the same
> in all banks (more than 20 banks) which allowed me to create
> ranges and commands that can be used in all banks.
>
> How do I do this in STATA?
>
> ===============================================================
>
> First, I would generate a help variable -old3- since this is used
> repeatedly:
>
> generate str old3 = substr(oldvar,1,3)
>
> Next, it goes:
>
> generate str newvar = ""
> replace newvar = "1" if old3>="001" & old3<"799"
> replace newvar = "1" if old3>="A00" & old3<"U99"
> replace newvar = "2" if old3>="800" & old3<"999"
> replace newvar = "2" if old3>="V00" & old3<"Y99"
>
> I wonder, however, if you want -newvar- to be string; numaric
> variables are handier:
>
> generate newvar = .
> replace newvar = 1 if old3>="001" & old3<"799"
> replace newvar = 1 if old3>="A00" & old3<"U99"
> replace newvar = 2 if old3>="800" & old3<"999"
> replace newvar = 2 if old3>="V00" & old3<"Y99"
>
> Note that you may use the relational operators> and < with
> strings. The rule is that strings follow dictionary sequence;
> however, all uppercase letters come before lowercase, numbers
> come before letters, and spaces or blanks come before
> anything else. So:
>
> " " < "12" < "2" < "A" < "AA" < "Z" < "a"
>
> You could have found information about the substr() function by:
>
> findit substring
>
> Hope this helps
> Svend
> __________________________________________
>
> Svend Juul
> Institut for Folkesundhed, Afdeling for Epidemiologi
> (Institute of Public Health, Department of Epidemiology)
> Vennelyst Boulevard 6
> DK-8000 Aarhus C, Denmark
> Phone: +45 8942 6090
> Home: +45 8693 7796
> Email: [email protected]
> __________________________________________
>
> *
> * 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/
_________________________________________________________________
Use video conversation to talk face-to-face with Windows Live Messenger.
http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_video_072008
*
* 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/
