Hi there,
I seem to be having difficulty with the code below.
When I run the code I am getting the error message "too many ')' or ']'"
When I try to alter the brackets I get the error message "type mismatch"
Does anyone have any suggestions?
Tove Fitzgerald
-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ryan Kessler
Sent: Wednesday, 16 January 2013 1:48 PM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: How to identify multiple substrings within a string
input str50 string
"diarrhoea"
"nil diarrhoea"
"no vomiting/diarrhoea"
"no text text text text vomiting/diarrhoea"
"denies diarrhoea/vomiting"
end
gen nodi = (regexm(lower(string), "(nil |no |denies )(.*)(diarrhoea)") & length(regexs(2)) <= 10) tab nodi
Change the 10 as you see fit.
Ryan
On Tue, Jan 15, 2013 at 4:36 PM, ToveLysa Fitzgerald <ToveLysa.Fitzgerald@hnehealth.nsw.gov.au> wrote:
> Thank you, that piece of code picked up nil/no/denies cases but it also picked up some cases where nil/no/denies was completely irrelevant to the term diarrhoea as these terms preceeded a large amount of text prior to the occurrence of diarrhoea. Is there any way you can refine the code to limit the number of characters/spaces that occur between the terms nil/no/denies and diarrhoea?
> Tove Fitzgerald
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ryan
> Kessler
> Sent: Monday, 14 January 2013 12:03 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: How to identify multiple substrings within a string
>
> input str30 string
> "diarrhoea"
> "nil diarrhoea"
> "no vomiting/diarrhoea"
> "denies diarrhoea/vomiting"
> end
>
> gen nodi = regexm(lower(string), "(nil |no |denies )(.*)(diarrhoea)")
> tab nodi
>
> Best,
>
> Ryan Kessler
>
> On Sun, Jan 13, 2013 at 6:37 PM, Michelle T. Butler <Michelle.Butler@hnehealth.nsw.gov.au> wrote:
>> Hi all, I am searching a string variable for cases who don't have diarrhoea.I need to identify records where the terms nil, no or denies preceeds the term diarrhoea in the same sentence.I have already identified that these terms do not always immediately preceed diarrhoea eg. No vomiting/diarrhoea, so I am looking for a way to extract all observations where nil, no, denies occurs in close proximity to diarrhoea, ignoring spelling errors/upper/lower case variations etc.Thank you for your help,Tove Fitzgerald.
>>
>>
>>
>> *
>> * 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/
>
> *
> * 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/
>
> *
> * 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/
*
* 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/
*
* 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/
