st: reshape command without a j( ) variable using Stata 8

[Karen Rappaport <karenmrappaport@yahoo.com>]

I  have a data set that I want to reshape from long to wide using Stata 8.  It 
contains 2748 unique respondent sequence numbers and a total of 3191  
observations. It is a data set of patients and medications they take.  Some 
patients take two medications.
Here are the variables:
seqn (unique patient number; numeric)
medID (medication ID number; string)
medic (medication name; string)
days90 (number of days medication taken in last 90 days; numeric)
days30 (number of days medication taken in last 30 days; numeric)
quant (quantity of medication taken daily)
serving (label serving size; double)
reason (reason for taking medication; double)

At first, I thought this would be a straight forward case of reshaping "long to 
wide" with more than one variable.

reshape wide medID medic days90 days30 quant serving reason ,  i(seqn) j( ??? )

Essentially, all variables are shaped long to  wide so that I have only one set 
of observations per patient or "seqn".  (Is this essentially correct?) But what 
do I put in the j(  ) position? 

Thank you!
Karen



      
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/