need to change dataset

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Tue Aug 30, 2011 6:59 pm

need to change dataset

Postby Inge » Tue Aug 30, 2011 7:23 pm

I hope I can explain my problem well.
I have a big row of participants with 12 measuring points ( 1 for each month). The problem is that the baseline of these measurements, and so all the measuring points per participant are all in different months. I now need to count the measurements per month instead of per participant. The measurements go over a few years. I would like to get say the year 2009. Some participants started earlier and these measurements before 2009 should be put at the end of the row in the corresponding month. The same for participants that started later, these measurements after 2009 should be put in the corresponding months before they started.
Does anyone know how to do this without having to make a new dataset?
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: need to change dataset

Postby GerineL » Wed Aug 31, 2011 8:33 am

Can you maybe provide an example of what your dataset looks like exactly (including the variable(s) that indicate the month(s))?

Who is online

Users browsing this forum: No registered users and 1 guest