st: Chosing minimum value out of 6 variables

["Ziad El-Khatib" <Ziad.El-Khatib@ki.se>]

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/