Column format (REPORT command)

The following options can be used to format break columns:

(width). Column width for the break column. If no width is specified for a variable, REPORT determines a default width using the criteria described under Defaults. If ONEBREAKCOLUMN is ON, the column width specified or implied by the first BREAK subcommand is used. If you specify a width that is not wide enough to display numeric values, REPORT first rounds decimal digits, then converts them to scientific notation if possible, and then displays asterisks. Value labels or string values that exceed the width are wrapped.

(OFFSET). Position of the break column contents. The specification is either n or CENTER specified in parentheses. OFFSET( n ) indicates the number of spaces to offset the contents from the left for value labels or string values, and from the right for numeric values. OFFSET(CENTER) centers contents within the column. If AUTOMATIC is in effect, the default is CENTER. If MANUAL is in effect, the default is 0: value labels and string values are left-justified and numeric values are right-justified. If ONEBREAKCOLUMN is ON, the offset is applied along with the indentation specified on INDENT, always from the left. The specification of CENTER on OFFSET is ignored.

(UNDERSCORE). Use underscores below case listings. Case listing columns produced by FORMAT LIST are underscored before summary statistics are displayed. You can optionally specify the names of one or more report variables after UNDERSCORE; only the specified columns are underscored.

(TOTAL). Display the summary statistics requested on the next SUMMARY subcommand for all the cases in the report. TOTAL must be specified on the first BREAK subcommand and applies only to the next SUMMARY subcommand specified.

(NOTOTAL). Display summary statistics only for each break. This is the default.

(SKIP(n)). Skip n lines after the last summary line for a break before beginning the next break. The default for n is 1.

(PAGE). Begin each break on a new page. If RESET is specified on PAGE, the page counter resets to the PAGE1 setting on the FORMAT subcommand every time the break value changes for the specified variable. PAGE cannot be specified for listing reports with no break levels.

(NAME). Display the name of the break variable next to each value or value label of the break variable. NAME requires enough space for the length of the variable name plus two additional characters (for a colon and a blank space) in addition to the space needed to display break values or value labels. NAME is ignored if the break column width is insufficient.

(NONAME). Suppress the display of break variable names. This is the default.

Example

SORT DIVISION BRANCH DEPT.
REPORT FORMAT=AUTOMATIC MARGINS (1,70) BRKSPACE(-1)

  /VARIABLES=SPACE(DUMMY) ' ' (4)
             SALES 'Annual' 'Sales' '1981' (15) (OFFSET(2))
             EXPENSES 'Annual' 'Expenses' '1981' (15) (OFFSET(2))

  /BREAK=DIVISION
         BRANCH (10) (TOTAL) (OFFSET(1))
  /SUMMARY=MEAN

  /BREAK=DEPT 'Department' (10)
  /SUMMARY=MEAN.
  • This example creates a report with three break variables. BRANCH breaks within values of DIVISION, and DEPT breaks within values of BRANCH.
  • FORMAT sets margins to a maximum of 70 columns and requests that summary lines be displayed on the same line as break values. Because LIST is not specified on FORMAT, only summary statistics are displayed.
  • VARIABLES defines three report columns, each occupied by a report variable: SPACE, SALES, and EXPENSES.
  • The variable SPACE is a dummy variable that exists only within REPORT. It has a null heading and a width of 4. It is used as a space holder to separate the break columns from the report columns.
  • SALES has a three-line heading and a width of 15. The values of SALES are offset two spaces from the right.
  • EXPENSES is the third report variable and has the same width and offset specifications as SALES.
  • The leftmost column in the report is reserved for the first two break variables, DIVISION and BRANCH. Value labels are displayed, since this is the default for AUTOMATIC. The break column has a width of 10 and the value labels are offset one space from the left. Value labels more than nine characters long are wrapped. The default column heading is used. TOTAL requests a summary line at the end of the report showing the mean of all cases in the report.
  • The first SUMMARY subcommand displays the mean of each report variable in its report column. This line is displayed each time the value of DIVISION or BRANCH changes.
  • The third break variable, DEPT, occupies the second column from the left in the report. The break column has a width of 10 and has a one-line heading. Value labels are displayed in the break column, and those exceeding 10 characters are wrapped.
  • The second SUMMARY subcommand displays the mean for each report variable when the value of DEPT changes.