Proc SQL Count help

marleeakerson — Wed, 08 Jul 2020 16:13:11 GMT

hello,

i have a very basic proc SQL question.

What should the syntax be to count the number of different observations in a variable? For instance in the table below

ID Variable

1 X

2 X

3 Y

4 X

How would I find the total count of X and Y appearances in the "Variable" column using proc SQL?

Thank you!

Re: Proc SQL Count help

novinosrin — Wed, 08 Jul 2020 16:19:40 GMT


data have;
input ID     Variable $;
cards;

1          X

2          X

3          Y

4          X
;

proc sql;
create table want as
select variable, count(variable)as count
from have
group by variable;
quit;

topic Proc SQL Count help in New SAS User

Proc SQL Count help

Re: Proc SQL Count help