Roll Number | Class | Age | Gender | Subject | Sports |
001 | 1 | 10 | M | Maths | Cricket |
002 | 1 | 11 | M | English | Tennis |
003 | 2 | 9 | F | Maths | Football |
004 | 4 | 7 | F | Science | Football |
005 | 3 | 7 | M | Maths | Cricket |
006 | 5 | 10 | F | Science | Tennis |
007 | 3 | 7 | F | Art | Cricket |
Questions
This sounds a lot like a homework assignment.
So, what have you tried so far?
Proc Freq will likely do 1 and 4
Data step with IF or WHERE for 2
Proc Sort for 3
And why are all of your questions number 1???
Indeed it is a home work.
I had been trying to download the SAS software to work on it but the computer is restricted as it is company owned.
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!
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.