BookmarkSubscribeRSS Feed
11205213
Fluorite | Level 6

Hello, 

I need to give statistics for two groups (1 or 0) of one of my variable. 

I have to use proc means but I don't know how to seperate groups of my variable ? 

 

Proc means data=mydata;

         VAR min

         WHERE is_member=1;

run;

 

3 REPLIES 3
novinosrin
Tourmaline | Level 20

Are you looking for a class statement?

 

Proc means data=mydata;

  class groups;

         VAR min;

         WHERE is_member=1;

run;

Astounding
PROC Star

I think CLASS is the right tool but the program would be even simpler:

 

proc means data=mydata;

class is_member;

var min;

run;

11205213
Fluorite | Level 6
Thank you it works !!

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1376 views
  • 3 likes
  • 3 in conversation