Thanks James. Perfect for the job at hand (I added str8 for Stata 7).
On 7 Feb 2004, at 17:21, James Hesford wrote:
If you don't have duplicate oral contraceptives in variable, stk, a
simple solution seems to be:
gen oral = "OVYS" if index(stk,"OVYS")
replace oral = "MICROG" if index(stk, "MICROG")
replace oral ="FEMOD" if index(stk, "FEMOD")
replace oral = "LOGED" if index(stk, "LOGED")
Items not have matches are blank, but you can replace this with BLANK
by making this your first command (i.e., gen oral = BLANK followed by
the series of replacements).
Database of 41,000 clinic visits with 26 variables for each visit.
One variable is a string (stk) of contraceptives prescribed,
containing 1 to 4 types, separated by commas.
stk
NONE,OVYS
NONE,NONE,NONE,MATES6,NATURAL
NONE,MICROG
NONE,NONE
NONE,FEMODE,NATURAL
NONE,NONE
LOGED
NONE,NONE,MICROG,MATES6,NATURAL
NONE
NONE,LEVONEL,MICROG
MICROG
NONE,NONE,LOG
NONE,NONE,NONE
NONE,MATES6,NATURAL
NONE,NONE
MICROG,ULTRA
NATURAL
NONE,MICROG,NATURAL
Some are oral contraceptives:OVYS MICROG FEMODE, LOGED
The position of the oral contraceptives in the string varies.
I want all the oral contraceptives in one column:
OVYS
blank
MATES6
MICROG
blank
FEMO
blank
LOGED
How?
Help gratefull received.
Paul
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
Dr Paul O'Brien
Westside Contraceptive Services
Raymede Clinic, Exmoor St, London
W10 6DZ
020 8962 4450 - tel
020 8962 4451 - fax
07900 495 118 - mob
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
