Descriptive Statistics Tables

Column Statistics - TABLE4 Examples

Use TABLE4 to produce COLUMN summary statistics on result and change from baseline for a parameter, dose and time point (displayed as rows). It has an option for counting the number of subjects below and above the reference range that is commonly used for laboratory data. Examples of this type of table are labs, vital signs and ECGs.

The TABLE4 macro requires that the data to the macro is structured in the parameter/classification or test/value format. Observations used as baseline data to calculate a change from baseline value must be flagged with a variable (e.g., B_FLAG=1) for baseline observations and missing for all others.

Note that TABLE4 defaults SQUEEZE to Y, causing the table to use the minimum number of columns possible. This is set as the default, since TABLE4 generally requires more space than other report macros. To control column widths (for example, by using the ROW var=width option), it is necessary to set SQUEEZE=N.

TABLE4 examines data passed to the macro to determine decimal place assignment. Using the RESET parameter, TABLE4 finds the maximum number of decimals occurring within a group of data. Based on this number of decimal places on the input data, TABLE4 assigns decimal places for data in the table based on the following factors:

  • Values from input data, such as MIN or MAX, are formatted with the maximum number of decimal places found on an input value within the RESET group.
  • Statistics on the STATS parameter (which are not actual data values, like MIN) receive one extra decimal place, with the following exceptions:
    • Statistics given a decimal offset in the SETDEC parameter receive the additional decimal places specified on SETDEC.
    • The SETDEC /FIXED option assign a fixed number of decimal places for statistics instead of a decimal offset.