And, Optimist, to answer the rest of your question, I am planning to do the rest of the analysis in SAS. I work in public health and this is data from a pilot study we did looking at lifestyle patterns in a specific disease group....  the eventual goal is to quantify/describe how they are spending their time, and determine whether those who are spending more time sitting have higher levels of certain biomarkers in the blood. ... View more

Sure. So, I have 7 days of data per person, collected 24 hrs/day in 15-sec intervals, and as the data are organized currently, each 15-second interval is its own row. Eventually I would to have like a dataset that looks like this, where I have already removed all of the data for the chunks of time when I know (based on separate logs) that each person was sleeping. Participant      WearDay1   SittingHrs1   StandHrs1   SteppingHrs1     SitStandTransitions1    Steps1    WearDay2    SittingHrs2  StandHrs2... Guy Smiley     3/4/2014         9.1                  2.6                 1.8                            41                5596      3/5/2014           9.6                2.1 Kermit            11/21/2013      8.6                  4.1                 2.2                            68                7637      11/22/2014        8.8                3.2 PrairieDawn    5/9/2014         9.9                  1.9                  1.3                           32                2974       5/10/2014         8.7                1.5 Then I would create overall variables for each person's week, so that I know the average hrs/day each person spends sitting down, standing up, and stepping, as well as the average number of steps/day they take, and the average number of sit-to-stand transitions they make. *** EDited this to fix a couple of variable names. ... View more

So, I ran a single-variable PROC TRANSPOSE, which seems to have worked fine. The log said I have 1 observation and 40,320 variables, so that sounds good to me. But I can't really take a look at the data, because when I run PROC CONTENTS, SAS gets all gummed up and stops responding. Is this normal with huge datasets? How do you work with it if you can't look at it? ... View more

Ballard, I edited the original post to add one of my actual datasets in case that is helpful to anyone. I think I understand what you are saying about the time variable... if I understand correctly, you are suggesting that we could just enumerate the occurences. Since everyone has 1 week of data from their physical activity sensor ( ~40,320 15-second intervals of data), we could just number those 40,320 occurences, right, rather than labeling them by the actual date/time of the occurence?  The rub is that I need to remove blocks of data... so if someone slept from 11:21 pm - 6:07 a.m. between the first and second day, I need to be able to identify and delete all the rows that pertain to those dates and times. ... View more

Thank you everyone who has responded so far. This is my first time trying the forum so I didn't know whether anyone would chime in. I really appreciate this help. So, in re: Bootstrap_armada, I read the example you sent. That example seems a bit more straightforward because each family has data for the same three years: 96, 97, and 98. So they specify "id=year" and the new columns are labeled accordingly But will that still work for my example, when the values for the "time" variable are different for everyone? (Everyone started wearing their monitor on a different date)?  I need mine not to append the column name with a value, but basically just say "time1 time2 time3 time4" etc. because "time1" is different for every person. ** Edited to add that other than that bit, the page you sent is very helpful and I was able to understand what they're doing... so it seems promising... it's just the "id" piece I'm unsure about. ... View more

I think that may be my error in understanding the term. Sometimes in Excel I use the transpose feature, which switches columns and rows. So I assumed that proc transpose would reverse columns and rows, not turn multiple rows into a single row... ... View more

Re: kewong. Thank you, I will try this out. This may be a silly question, but where do I put that line of %multtransponse? Does it go within a data statement? And what about the huge amount of code that is at the bottom of the website you linked to... do I need all of that, or just the one line? Re: RW9, I need to sum the observations across time variables. If it helps, what I'm working with is physical activity data collected over an entire week. Each 15-second interval is its own row. So I need to create a summary variable for each day that adds up all of the physical activity. But also will need to mark and pull out the hours of the day when the person was sleeping (they were still wearing the monitor 24 hrs/day, even when asleep, so there are data from when they are rolling around in bed, etc., which I need to remove). ... View more