Help using Base SAS procedures

How to delete answers/entries in SAS

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

How to delete answers/entries in SAS

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 Smiley Sad


Accepted Solutions
Solution
‎03-10-2012 08:03 PM
Super User
Posts: 19,770

How to delete answers/entries in SAS

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;

View solution in original post


All Replies
Solution
‎03-10-2012 08:03 PM
Super User
Posts: 19,770

How to delete answers/entries in SAS

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;

Contributor
Posts: 67

How to delete answers/entries in SAS

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 141 views
  • 0 likes
  • 2 in conversation