Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: managing data


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: managing data
Date   Fri, 5 Dec 2008 16:51:54 -0000

I share David Elliott's concerns here. 

This does not seem a well posed problem to me, quite apart from appearing a very weird request without some rationale. 

First, the example contradicts the description. In your example, individuals end up with 2 events each. 

Second, what rule do you have for expanding your events to 4 each? If individuals have 1 event each, that could be copied three times. But if individuals have 2 or 3 events each, which is to be copied to fill out the data? 

More generally, as I can't see that data management here can (or should purport to) create information that doesn't exist, it would be interesting to know the problem behind this problem, as I guess there's a better solution to it than this. 

Nick 
n.j.cox@durham.ac.uk 

Rodrigo Briceño

I have a database of individuals with have suffered
from some events (muscular pain). The maximum amount of events an
individual could suffer in the database is 4. What I need is to copy
the information available (the row of data for each individual) the
number of times required, so those individuals that have 3, 2 or 1
event,  end in the new database with 4 events all. So for example
(maximum number of events is 2 in this case):

old database:
id event x
1  1      30
2  1      15
2  2      15

new database
id event x
1  1      30
1  1      30
2  1      15
2  2      15

I'm using stata 9 and my OS is windows vista. Thanks for your help.

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



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