topic Counting categorical variables in sas studio in New SAS User

Counting categorical variables in sas studio

emma19901 — Thu, 13 Dec 2018 01:37:19 GMT

Hi, I am trying to count categorical variables on the following dataset., I need to count how many players have normal performance on the south team by month., This is an 8,000 observations dataset.

Player	performance	Team month
1	High	north 3
2	normal	south 7
3	low	north 5
4	High	north 9
6	normal	south -
7	low	north -
8	High	north

Re: Counting categorical variables in sas studio

ballardw — Thu, 13 Dec 2018 00:03:47 GMT

Do you need a data set for further processing (computer use) or a report (people read)?

This example code would provide a count all combinations of performance and team as a report.

proc freq data=have;
  tables performance*team / list missing;
run;

You can subset the data with where statement:

proc freq data=have;
  where performance='normal' and team='south';
  tables performance*team / list missing;
run;

Re: Counting categorical variables in sas studio

Ksharp — Thu, 13 Dec 2018 12:47:15 GMT

proc sql;

select count(distinct player)

from have

group by team,month;

quit;