Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: reshape command without a j( ) variable using Stata 8
From
Karen Rappaport <[email protected]>
To
[email protected]
Subject
Re: st: reshape command without a j( ) variable using Stata 8
Date
Tue, 15 Feb 2011 08:45:48 -0800 (PST)
Hello Nick and anyone else out there who might be able to help,
My data is a long data set that contains information about a substance (X) in
supplements, including multi-purpose vitamins and other supplements some
patients take. Each supplement a patient takes that contains X is a separate
observation. (I deleted from the data set all supplements that do not contain X,
which I was able to do because I had a variable that was an "ingredient
variable".) I want to calculate the amount of X patients are getting through
supplements. In cases in which patients are getting X through only one
supplement, it will be easy to instruct stata to calculate the amount of X
consumed. But some patients are taking two or more supplements that contain X.
Their unique patient numbers appear in the data set as many times as the number
of different supplements they take that contain X.
I want to make the data set wide so that it looks something like this:
Patient_1 MedID_A Medic_A Days_90_A . . . MedID_B Medic_B Days_90_B. . .
Right now, my data set looks like this:
Patient_1 MedID Medic Days_90 . . .
Patient_1 MedID Medic Days_90 . . .
Hope this helps!
Is there another command I might use instead of "reshape"?
Karen
----- Original Message ----
From: Nick Cox <[email protected]>
To: [email protected]
Sent: Mon, February 14, 2011 11:54:20 PM
Subject: Re: st: reshape command without a j( ) variable using Stata 8
It's not that clear that this will benefit much from -reshape-. In any
case the -reshape- syntax requires you to specify stubnames, not
variable names, so not knowing -j()- is not your only problem. The key
questions are: What is you want to do that you think will be easier
after a -reshape-? What do you want to do that seems difficult with
your present data structure?
Nick
On Tue, Feb 15, 2011 at 1:47 AM, Karen Rappaport
<[email protected]> wrote:
> 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?
*
* 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/
*
* 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/