Another way to control the format of crosstabulations is to limit the output of the FREQ procedure to a few specific statistics. Remember that when crosstabulations are run, PROC FREQ produces tables with cells that contain:

• cell frequency
• cell percentage of total frequency
• cell percentage of row frequency
• cell percentage of column frequency

You can use options to suppress any of these statistics. To control the depth of crosstabulation results, add any combination of the following options to the TABLES statement:

• NOFREQ suppresses cell frequencies
• NOPERCENT suppresses cell percentages
• NOROW supresses row percentages
• NOCOL suppresses column percentages

Example

Suppose you only want to use the percentages of Sex and Weight combinations in the data set Clinic.Diabetes. To block frequency counts and row and column percentages, add the NOFREQ, NOROW, and NOCOL options to your program's TABLES statement.

     proc format;
        value weight low-139='< 140'
                     140-180='140-180'
                     181-high='> 180';
     run;
     proc freq data=clinic.diabetes;
        tables sex*weight / nofreq norow nocol;
        format weight weight.;
     run;