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,