Help with dropping value

gstanse — Sat, 04 Apr 2020 03:53:39 GMT

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

M	0
F	2
F	1

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;

Re: Help with dropping value

ChrisNZ — Sat, 04 Apr 2020 04:23:02 GMT

Add a where clause:

where DEPENDENTS ne 0;

topic Re: Help with dropping value in SAS Programming

Help with dropping value

Re: Help with dropping value