Hi. I am a new STATA user that is working on a secondary analysis for my
dissertation research. I am trying to reconfigure a file that was set up with
multiple record cases. For example, a particular id# may be contained in
this file numerous on the following variables: event # (gcount) and edate
(month, day, year of the event). I am trying to convert the data from long
form to wide form so that each id# is only represented in this file once and
have run into some difficulty with the RESHAPE command. I know based upon
what I have read in the Reference manual and the FAQ reshape information that
I must need to create some additional variables because the j(edate variable)
is not unique for each id #. Let me explain that the reason the edates are
not unique is because an individual may have experienced mutiple events, such
as a fall, on any given date. I wondered if anyone might be able to point me
in the right direction for how I should proceed with creating additional
variables? I have included a condensed version of my syntax and output below.
Thanks in advance for your help,
Beth
. reshape wide gcount, i(id) j(edate)
(note: j = 11928 11946 11956 11959.............)
edate not unique within id;
there are multiple observations at the same edate within id.
Type "reshape error" for a listing of the problem observations.
r(9);
reshape error
i (id) indicates the top-level grouping such as subject id.
j (edate) indicates the subgrouping such as time.
The data are in the long form; j should be unique within i.
There are multiple observations on the same edate within id.
The following 253 out of 3741 observations have repeated edate values:
id edate
75. 45 06/26/1994
76. 45 06/26/1994
92. 52 06/21/1994
93. 52 06/21/1994
(data now sorted by id edate)
*
* 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/
