This is the first time I’ve been on this sub, so I am sorry if this unconventional or isn’t the right place for this question.
I need to reorganize a giant longitudinal data set in SPSS this summer. Rather than have a couple research assistants and I do it by hand, I was wondering if there might be some way to do it through syntax or some external program, saving literal months and hundreds of dollars in the process.
The data is currently organized so that each row starts off with the date that Event 1 happened, followed by a block of variables related to that date. After that, there are dates of other events which happened prior to Event 1, with each date having its own corresponding block of variables. After the events which happened before Event 1 comes the same thing, but with events which happened after Event 1 and before data collection took place.
Now, for each participant, all of these events happened on different dates. There are also different numbers of events prior to and after Event 1. Event 1 would also be on a different date for every participant.
What I need to do is organize the data so that for each participant these events (and their corresponding blocks of variables) are listed in chronological order. So starting with Prior Event 1 and ending with Post Event n.
Anything you can give me would be much appreciated. I apologize if I was being a bit vague about the nature of the data, I’m not supposed to discuss it with anyone. If this isn’t the right place for this question, it would also be greatly appreciated if you could point me in the right direction.