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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.