My apologies for misspeaking earlier. In the proc means step I am calculating the number of widths above a threshold for a given subject in a given session. My proc mixed code for the mixed effects ANOVA works perfectly. All I need is a way to keep anything less than the threshold in the data set and equal to zero. This would be the ideal table:   Condition, Session, ID, Count 1    1   a   0 1    2   a   0 1    3   a   0 1    4   a   5   So the 4th session is where the subject had a width greater than or equal to 5. ... View more

@PaigeMiller Sorry I'm new to SAS and I guess I didn't give the complete information needed. I am trying to find the total observations or frequency the width is above a given width. For this instance, I need to know the total observations a subject has per session at or above 5. I will then do a mixed effects ANOVA. That is where the power issue comes in. I have 1000 total observations condition*session*subject and when I set the width higher to say 20, I only have 90 observations. That is why I need to keep all the observations and have width = 0. Or some other way of keeping the widths below the threshold in the data set without excluding them.   Thank you for the code suggestion. I was able to get that to work, but when I ran it I still got the same number of observations (870) which is the number of condition*session*subject that had a width >=5.   Is there any other information I can provide? ... View more

Each subject has 1 condition, multiple sessions, and multiple widths per session. I am attempting to look at widths greater than 5, but need to include all data points, so the width =3 and width = 1 would need to be equal to 0.   Sample data: Condition, Session, Subject, Width 1       1       a       3        1       1       a       6 1       2       a       5 1       1       b       7 1       1       b       8 1       2       b       1 1       2       b       5 ... View more

Thank you for the responses, apologies for the confusion. I am interested in the sum of the values equal to or above 5. Anything less than 5 I still need to include in my analysis for power reasons, so I need it to equal 0. I could do this by making a data set using an if_ then_ statement, but for unrelated reasons I need to have it in this step.    Hopefully that makes more sense. Here is a better way of naming the variables that I think will be more helpful:   proc means data=data noprint; by condition session subject; where (width>=5); var width; output out=count_summary (width)=total;   Thank you! ... View more