You can try this:
egen minval = rowmin(drug1-drug6)
HTH
M.
On Mon, May 26, 2008 at 10:45 AM, Ziad El-Khatib <[email protected]> wrote:
> Hi,
> 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..
>
>
> any tips?
>
>
> Thank you in advance and best regards
> ziad
> *
> * 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/
