aggregated data

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

Posts: 1
Joined: Fri May 05, 2017 7:06 am

aggregated data

Postby Evahaussperling » Fri May 05, 2017 8:14 am

Dear all,

I have a dataset with the ID of subjects as rows and cortisol measures at different time points during the day as columns. I want to know which subjects have measures at all time points and which do not. So I want to count the number of valid values for each subject. For example subject 1 may have data on the 6 time points of the day but subject number 2 only 3 or 4. How can I do this in SPSS? My supervisor told me to use the aggregate function but to be honest I've tried and it does not give me what I want.

Thank you very much,


Who is online

Users browsing this forum: No registered users and 2 guests