Nick Cox's -catenate- automates the generate command suggested by Svend.
ssc install catenate
catenate Drugs = Drug1 Drug2 Drug3, p(/)
Carter
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Svend Juul
Sent: Monday, November 05, 2007 7:12 AM
To: [email protected]
Subject: Re: st: Placing the content of 3 cells in 1 new cell?
Ziad wrote:
In Excel the person can have the content of 3 other cells in one cell,
for example
Drug1 Drug2 Drug3 Drugs
--------------------------------------------------------------
Panad Asp Val Panad/Asp/Val
by typing:
drugs=drug1&"/"&drug2&"/"drug3
Is it possible to do something similar in STATA?
-----------------------------------------------------------------
yes:
generate drugs = drug1 + "/" + drug2 + "/" + drug3
or:
egen drugs = concat(drug1-drug3), punct(/)
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/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/
