Displaying 1 result from an estimated 1 matches for "obsdate".
Did you mean:
obs_date
2008 Apr 24
1
re shaping "long-form" longitudinal data from sql query
hi, I'm a total noob who 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 [.....