BookmarkSubscribeRSS Feed
gstanse
Calcite | Level 5

Hi Everyone, 

 

So I'm learning SAS in my analytics class and I'm having trouble dropping a value. I'm trying to determine the number of dependents per employee based on gender by each marital status. Though I cant include the 0 values that are in the dependents column in my calculation.

 

Here's a snippet of the table. 

 Gender Dependents

M0
F2
F1

 

The code I'm using brings up the table that I'm looking for, though I can't figure out how to exclude the 0 value for the Dependents column.

 

proc means data=orion.salariesl;
	var Dependents;
	class Employee_Gender Marital_Status;
run;
1 REPLY 1
ChrisNZ
Tourmaline | Level 20

Add a where clause:

  where DEPENDENTS ne 0;

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 657 views
  • 0 likes
  • 2 in conversation