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: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 1349 views
  • 3 likes
  • 3 in conversation