Statalist


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

st: Reshape-Like Question


From   Alan Neustadtl <alan.neustadtl@gmail.com>
To   Statalist <statalist@hsphsun2.harvard.edu>
Subject   st: Reshape-Like Question
Date   Tue, 3 Mar 2009 19:05:13 -0500

I am using Stata V10 and have a dataset with repeated blood glucose
measurements per day.  The data are ordered by patient id (pid) and
within patients by the date of the glucose readings (datestamp).  In
other words, there is one record per patient/blood glucose reading.

I would like a new dataset with one record per patient id/date but
with one variable for each reading that day.  For example, in a month
with thirty days where a patient took at least one blood glucose
measurement per day, there would be thirty records.  There would be a
variable corresponding to each blood glucose measurement.

The following data indicate what I currently have and what I would
like to have.  I have put a blank line between groups to make the data
more readable but these breaks do not exist in the Stata dataset.

This strikes me as a -reshape- problem but the dates are duplicates so
-reshape- fails.  If this is not a reshape problem I don't even know
what to call it to search the Statalist archives.

Any suggestions/pointers are welcome.


ORIGINAL DATA
pid   site datestamp bglevel enrolldate fuploaddate
1424  PBCI 10jan2006 253     09jan2006  13jan2006
1424  PBCI 10jan2006 185     09jan2006  13jan2006
1424  PBCI 10jan2006 252     09jan2006  13jan2006

1424  PBCI 13jan2006 223     09jan2006  13jan2006
1424  PBCI 13jan2006 173     09jan2006  13jan2006
1424  PBCI 13jan2006 156     09jan2006  13jan2006

1428  PBCI 10jan2006 208     11jan2006  11jan2006
1428  PBCI 10jan2006 226     11jan2006  11jan2006
1428  PBCI 10jan2006 242     11jan2006  11jan2006
1428  PBCI 10jan2006 279     11jan2006  11jan2006

1428  PBCI 11jan2006 222     11jan2006  11jan2006
1428  PBCI 11jan2006 184     11jan2006  11jan2006
1428  PBCI 11jan2006 204     11jan2006  11jan2006


NEWLY SHAPED DATA
pid   site datestamp enrolldate fuploaddate bg1 bg2 bg3 bg4
1424  PBCI 10jan2006 09jan2006  13jan2006   253 185 252   .
1424  PBCI 13jan2006 09jan2006  13jan2006   223 173 156   .

1428  PBCI 10jan2006 11jan2006  11jan2006   208 226 242 279
1428  PBCI 11jan2006 11jan2006  11jan2006   222 184 204   .

Thanks,
Alan
*
*   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