Good morning,
I was wondering whether there is a countif function like the one in Excel that can count across rows...
Have
Mary |
Mary |
Mary |
Jim |
Jim |
Jim |
Jim |
Jim |
Steven |
Steven |
Want
Mary | 3 |
Jim | 5 |
Steven | 2 |
Thank you!
PROC FREQ.
Proc freq data=sashelp.class;
Table Age/Out=Age_Categories;
run;
PROC FREQ.
Proc freq data=sashelp.class;
Table Age/Out=Age_Categories;
run;
You also can use PROC SQL or PROC MEANS:
proc sql;
create table want as
select distinct name,
count(name) as count_names
from have
group by name;
quit;
proc means data=have;
class name;
output out=want
(where=name ne ' '
drop=_type_
rename=_freq_=count_names);
run;
Check the documentation regarding the NWAY option and you won't need the where data set option.
Also check out TYPES and WAYS statements.
Proc Freq! Of course!
Thank you.
I wish i knew how to use sql. I keep on bumping to it. It is on my list!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.