Ziad wrote:
I have adherence level for 6 different drugs (drug1, drug2, etc..),
inside cohort datafile, followed over 12 months.
At every visit there are data for 3 out of 6 drugs and I want to have
new variable having the minimal value for drug adherence, example
below
id visit drug1 drug2 drug3 drug4 drug5 drug6 minval
1 2 10 20 30 . . . 10
2 2 40 30 . 50 . . 30
etc..
================================================================
egen minval = rowmin(drug1-drug6)
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, work: +45 8942 6090
Phone, home: +45 8693 7796
Fax: +45 8613 1580
E-mail: [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/