Displaying 1 result from an estimated 1 matches for "hgba1c".
2008 Apr 24
1
re shaping "long-form" longitudinal data from sql query
...is having to ramp up to full speed very quickly due
to an unfortunate abrupt staffing change at my job :)
I have longitudinal data that looks like this:
PID OBSDATE DaysAgo CleanValue
NAME
1 1410164934000610 8/17/2004 13:03:38 1345 6.2 HGBA1C
2 1410164934000610 11/16/2004 10:39:51 1254 7.1 HGBA1C
...etc
I'd like to end up with a wide-format table like:
PID OBSDATE.1 DaysAgo.1 CleanValue.1 [...] OBSDATE.n DaysAgo.n
CleanValue.n
The problem: Every patient's on a different schedule, so there'...