Map series of repeated measures to calendar using start date

Posted by ladyc on Jul 22, 2016; 7:12pm
URL: http://spssx-discussion.165.s1.nabble.com/Map-series-of-repeated-measures-to-calendar-using-start-date-tp5732809.html

Howdy,

I have a dataset with the following variables:

Subject_ID
StartDate
W1
W2
W3
...
W10

Each individual (Subject_ID) was measured weekly for 10 weeks (resulting in 10 repeated measurements, the W1-W10 variables). The subjects were enrolled into the study on a rolling basis, with the date of their first measurement saved as StartDate. Thus, W3 was collected on StartDate + 2 weeks. We have an interest in quickly seeing whether some odd blips seen in the repeated measures are related to outside factors that came and went over time. Is there an easy way to transform/manipulate this data with SPSS so we can graph the W1-W10 data for all of the subjects against the actual date corresponding to each measurement? I could do it manually in excel, etc, but it would take quite a while. I have coding experience, but I'm new to SPSS syntax. I'm also not certain there isn't a way to do it through the GUI that I just haven't figured out. Does anyone have any ideas about how to go about this?

Erin