Visualizing Categorical Data: table

The table macro ( get table.sas)

Construct a grouped frequency table, with recoding

Usage

Parameters

DATA=

The name of the input dataset. [Default: DATA=_LAST_]

VAR=

Names of all factor (classification) variables to be included in the output dataset. The observations are summed over any other factors, weighted by the WEIGHT= variable, if any.

CHAR=

If non-blank, forces the VAR= variables to be converted to character variables (using formatted values) in the output dataset. If CHAR= a numeric value (e.g., CHAR=8), it specifies the length of each character variable; otherwise, the character variables default to length 16.

WEIGHT=

Name of a frequency variable, if the input dataset is already in frequency form. If not specified, each observation is assumed to be one case.

ORDER=

Specifies the order of the variable levels used in the PROC FREQ step. ORDER=INTERNAL|FREQ|DATA| FORMATTED are valid option values.

FORMAT=

A list of variable(s), format pairs (suitable for a FORMAT statement). The FORMAT= option may be used to recode the values of any of the VAR= variables.

OUT=

The name of output dataset. The variables in the output dataset are the VAR= variables, plus COUNT, the frequency variable for each cell. [Default: OUT=TABLE]

Limitations

Example

  %include vcd(table);        *-- or include in an autocall library;
  %include vcd(mosaic);
  %include data(berkeley);

  %table(data=berkeley, var=gender admit, weight=freq, char=Y,
         format=admit admit. gender $sex., order=data, out=berk2);
  %mosaic(data=berk2, var=Gender Admit);

The formats admit. and $sex. are created with PROC FORMAT:

  proc format;
     value admit 1='Admitted' 0='Rejected';
     value $sex  'M'='Male'   'F'='Female';

See also