topic Re: How to use proc freq to count in SAS Programming

How to use proc freq to count

JillChen0131 — Wed, 30 Mar 2022 23:04:06 GMT

I have the dataset as below:

Student Group Class Grade

001 7 2 A

002 7 1 B

003 5 3 A

004 5 4 C

005 6 2 B

I want to use proc freq to get total count for each group according to each grade, also for each class under each group. And proc transpose to get the final dataset will look like as below: (n is the count for each class, N is the count for each Group)

Group Grade

class A B C

7 N N N

1 n n n

2 n n n

5 N N N

3 n n n

4 n n n

6 N N N

1 n n n

2 n n n

Re: How to use proc freq to count

mkeintz — Thu, 31 Mar 2022 00:28:41 GMT

This report layout is done far more simply by PROC TABULATE. No transposing required:

proc tabulate data=have  order=data noseps;
  class group class grade;
  table group*class,grade * F=comma6.0;
run;

Primary documentation at Tabulate Procedure

Re: How to use proc freq to count

ballardw — Thu, 31 Mar 2022 00:36:51 GMT

Do you want a data set or a report (people read these)?

Proc freq will generate the counts you want but not display it that way.

Here is where I would start:

proc tabulate data=have;
   class group class grade;
   table group*(all=' ' class=' '),
         grade*n=' '
         /misstext=' '
   ;
run;

The =' ' are suppressing default text. This procedure defaults to repeating sub-group headings (your Class variable). The All provides a summary line. Done this way with the parentheses with it and Class it will be summary of the all of the Class variable counts. The order of appearance of values, such as the Group variable will normally be in formatted value order. You did not specify if the order was critical. There are several ways to force orders but depend on having a more complete data set and may involving SORTing the data or creating helper formats combined with options.

Re: How to use proc freq to count

JillChen0131 — Thu, 31 Mar 2022 01:43:38 GMT

I would need a dataset.

Re: How to use proc freq to count

ballardw — Thu, 31 Mar 2022 02:56:52 GMT

@JillChen0131 wrote:

I would need a dataset.

How will you use a data set?

The structure you are showing with a group in one column and not repeating, then a blank for the total row in grade is going to be extremely difficult to use for any purpose I can think of.

Proc Tabulate will create an output data set, it just won't look like that because of the flexibility of creating many more nestings of rows and column headings.