Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Generate a new variable from a string variable containing specific words


From   Richard Goldstein <richgold@ix.netcom.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Generate a new variable from a string variable containing specific words
Date   Tue, 13 Nov 2012 07:46:44 -0500

use the inrange function:

gen byte newvar=inrange(icd,"I60","I69")

rich

On 11/13/12 7:40 AM, Kamarul Imran wrote:
> Hi all,
> 
> I assume my question is not difficult, but it seems I can not find my
> way around it. Let us say, I have a string variable named 'icd' and
> can be inputted as
> 
> input str8 icd
> "I60.2"
> "B25.3"
> "C34.3"
> "I65.4"
> "I68.1"
> end
> 
> I would like to generate a new variable that shows as 1 whenever
> variable 'icd' contain words from I60 to I69, and 0 whenever variable
> 'icd' does not have that. So for my example, i will have a new
> variable showing 1 for the 1st, 4th and 5th observation and 0 for
> others.
> 
> How can I do that. Really appreciate if someone can help.
> 
> Regards,
> 
> Kamarul Imran Musa
> School of Medical Sciences,
> USM, Malaysia
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


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