Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Fw: repeated observations or multiple responses or bad data entry?


From   "Irina McKeehan Campbell, Ph.D." <[email protected]>
To   [email protected]
Subject   st: Fw: repeated observations or multiple responses or bad data entry?
Date   Wed, 17 Sep 2003 16:15:41 -0400

I didn't see this posted.

----- Original Message ----- 
From: "Irina McKeehan Campbell, Ph.D." <[email protected]>
To: <[email protected]>
Sent: Sunday, September 14, 2003 7:47 PM
Subject: repeated observations or multiple responses or bad data
entry?


: Dear Statalisters,
: Thanks for your help.
: I have received a patient dataset of the following format:
: ID    var1    var2    var3    var4QUESTION1    var5RESPONSE1    var6
: var7......
: 1    x1        x2        x3            x4q1            x5r1
: x6        x7 .....
: 1    x1        x2        x3            x4q1            x5r2
: x6        x7 ....  everything is duplicated except Response 2 for
: Question 1  (mtple response issue)
: 1    x1        x2        x3            x4q1            x5r3
: x6        x7......everything the same except Response 3 to Q1
: 1    x1        x2        x3            x4q2            x5r1
: x6        x7 .....everything the same except Q2 & R2
: 1    x1        x2        x3            x4q3            x5r1
: x6        x7 .....everything the same except Q3 & R3
: .....
: 2   x1        x2        x3            x4q1            x5r1
: x6        x7 ...
: 2  x1         x2        x3            x4q2            x5r2
: x6        x7 ...
: 2  x1         x2        x3            x4q1            x5r1
: x6        x7 ...
: ....
: 3  x1         x2        x3            x4q2            x5r1
: x6        x7.....no missing values for Questions not answered
: 3  x1         x2        x3            x4q2            x5r2
: x6        x7.....
: ....
:
: I have read the multiple responses (Cox, drum) and repeated
measures,
: I have no unique ID and so cannot reshape the dataset, I need to
: combine all the responses from all the questions to construct some
: indices and need to have all this info on "one row/ID"; Stata sees
the
: data as duplicates but I cannot drop the observation as the response
: variable is unique.... How do I get into a matrix of unique
: (nonrepeating IDs) by unique variables (even if the rows become very
: long)...There are 11,700 observations (rows)(responses to ~30
: questions) for unique N=242. So I need to collapse the dataset into
: 242 rows with X  columns.
: Irina
:
: Irina Campbell
: ________________________________________________________________
: Irina V. McKeehan Campbell, Ph.D., M.P.H.
: Director of Clinical Development and Quality Care
: Cogent Healthcare, Inc.
: www.cogenthealthcare.com
: tel/fax: (845) 358-6607
: mobile:  (914) 844-6145
: [email protected]
:
:
:
:
:
:
:
:
:
:
:
:

*
*   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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index