How to delete answers/entries in SAS

[ginak]

Hello, I am not sure how to correctly phrase my question into a simple subject line.

Basically, I have a survey Question "What is the number of graduate courses you took for training?"

and I have as answers:

0    frequency: 47

1    frequency: 7

2    frequency: 4

3    frequency: 2

6    frequency: 1

I want to do a PROC MEANS on this variable, NUM_CLASSES. So I already did that, I get a mean of 0.4.

Here is my question: I want to get rid of all 47 of the 0's and run a PROC MEANS on NUM_CLASSES without the 0's. How can I do so? I was thinking of creating a new variable in a DATA step and somehow writing a for loop indicating to get rid of the 0's.

Thank you so much! I figure it is relatively simple, but I'm having trouble figuring it out

[Reeza · Accepted solution]

Use a where statement to exclude observations.

Assuming your variables are:

num_classes - number of class, freq - count (ie 47, 7)

proc means data=have;

var num_classes;

weight freq;

run;

proc means data=have;

where num_classes>0;

var num_classes;

weight freq;

run;

[ginak]

thank you! The freq part didn't work , so I commented it out and the rest of the code worked Thanks!