Diana,
One way of searching a string for a certain match (regardless of its position) is to do the following
generate str15 grp = "A.I.F" if regexm(name, "A.I.F")
This will create a string variable called 'grp' which will equal A.I.F if A.I.F appeared anywhere within the variable 'name'. This works because -regexm(name, "A.I.F")- returns 1 if the statement if true and 0 if it is false. So Stata will create a variable called 'grp' and assign it the value A.I.F if the statement is true and missing if it is not.
As an extension to this, if your data looks like this
A.I.F. GMBH
A.I.F. COMPANY
QANTAS
AIR NEW ZEALAND
and you also want to identify, say, QANTAS flights, then you can add this line to your code
replace grp = "QANTAS" if regexm(name, "QANTAS")
You'll have to be careful if your data looks something like this
A.I.F. GMBH
A.I.F. COMPANY
QANTAS A.I.F
AIR NEW ZEALAND
because the value A.I.F, which was created with the -generate- statement, will be replaced with QANTAS in the -replace- statement.
-- Matt
[email protected]
-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of Diana Eastman
Sent: Friday, 26 September 2008 7:36 AM
To: [email protected]
Subject: st: Regexr Stata
Hi all,
I have a variable called "name" which lists several different airlines.
I need to write some code that will identify a regular expression within
these names and assign them a value in the new variable "group_name"
For instance, for the two names:
A.I.F. GMBH
A.I.F. COMPANY
I would want the group_name to be only "A.I.F." (the part of the string
they both share). The identifying string does not occur in the same
position across the names.
Any help is greatly appreciated.
*
* 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/
*
* 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/
