MAXCOUNT subcommand (RESPONSE RATE command)

The optional MAXCOUNT subcommand specifies the maximum cumulative total of the DENOMINATOR variable to use to color-code the output table and to use as a reference line on the cumulative count line chart. For each category of the GROUP total, the cumulative total is the sum of the DENOMINATOR values for all preceding categories plus the current category. For example, if DENOMINATOR represents number of customers, then the cumulative total for any GROUP category is the total number of customers for all groups up to and including that group.

The following alternatives are available for specifying maximum count:

COUNT=ALL. No maximum. This is the default if the subcommand is omitted.

COUNT=value. Use the specified value as the maximum cumulative total. The value must be a positive integer.

PERCENT=value. Determine the maximum cumulative total based on the specified percentage of the overall total. The value must be greater than 0 and less than 100.

  • If MAXCOUNT is specified without MINRATE, all rows with a cumulative total for the DENOMINATOR variable less than or equal to the specified maximum are displayed with a green background, and all subsequent rows are displayed with a red background.
  • If MINRATE is also specified, rows are only displayed with a green background if the maximum cumulative total is not exceeded and the cumulative response rate is higher than the specified minimum. For example, if the response rate is less than the specified minimum, the row will be displayed with a red background regardless of the cumulative total.

Example

RESPONSE RATE
  /VARIABLES 
   NUMERATOR=Responses
   DENOMINATOR=Customers
   GROUP=PostalRank
 /MAXCOUNT=6000.