I am trying to aggregate data of a variable number of measurements per day. Because it is a setting in which multiple variables are measured and not all occur in each case, there are missing values. I need to know the number of measurements that is aggregated for each different variable while aggregating over the date (the N break value).

Unfortunately, SPSS appears to count in the missing values when aggregating, giving me one N value corresponding to the total number of measurements on that day over which it aggregates, even if some (or all) variables contain missing values. Does anyone know a way to circumvent this?

Any help would be much appreciated!

Lucie