Hi, i need to count the number of observation that meets 2 conditions: i need to count the observations if column a is valued x and column b is valued y. Can you help?
That is the number in the last observation.
Or you can use PROC FREQ.
if a='x' and b='y' then count+1;
Is that what you want?
That is the number in the last observation.
Or you can use PROC FREQ.
by using proc freq statement , you count the no of observation
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.