SUB Feature

For tables that report responses to multiple-response questions, you can use the SUB or SUB- instruction to report the total number of mentions for a group of rows. In such tables, a net row shows the number of respondents who answered the question. The sub row shows the total number of responses and reflects the fact that respondents were permitted multiple responses. For single-response questions, NET and SUB are equivalent.

There are two ways to program rows using "SUB" logic:

1st method:

To use the SUB instruction, write SUB followed by the number of rows to include.

For example:

SUB 3

means, ‘sub the next 3 rows.’ SUB can refer only to rows that immediately follow the sub row.

You can use SUB with banner column logic.

For example:

Banner Text		Banner Logic
TOTAL RESPONDENTS	250	TN
TOTAL TEAMS WATCHED	277	SUB 4
SPARROWS	41	Q25 (1)
RATTLE SNAKES	22	Q26 (1)
LADY BUGS	74	Q27 (1)
JACK RABBITS	140	Q28 (1)

2nd method:

SUB

Row 1

Row 2

Row 3

ENDSUB

For this method you will program a row with the logic "SUB" above the rows you want to include and then a row with the logic "ENDSUB" after the rows. The benefit of using the SUB/ENDSUB logic is that you can add or remove rows from within the logic without the need to change the SUB logic row.

You can use either SUB method to set up a ‘sub’ to add rows within rows that are part of another sub.

There is one way to program rows using "SUB-" logic:

To use the SUB- instruction, write SUB- followed by the number of rows to include.

For example:

SUB-3

means, ‘sub the previous 3 rows.’ SUB- can refer only to rows that immediately precede the sub row.

You can use SUB- with banner column logic.

For example:

Banner Text		Banner Logic
TOTAL RESPONDENTS	250	TN
SPARROWS	41	Q25 (1)
RATTLE SNAKES	22	Q26 (1)
LADY BUGS	74	Q27 (1)
JACK RABBITS	140	Q28 (1)
TOTAL TEAMS WATCHED	277	SUB-4

Ranking (Sorting) SUB Rows:

You can rank (sort) SUB rows. Rows within SUB rows are ranked and then the SUB rows themselves are ranked. For example, the previous subtotal, when ranked, might look like:

SUB:	TOTAL TEAMS WATCHED	277
	JACK RABBITS	140
	LADY BUGS	74
	SPARROWS	41
	RATTLE SNAKES	22

You specify ranking by table using Setup|Tables|Table Options. You can rank in ascending or descending order.

SUB with mean summaries:

You can use SUB with mean summaries to get a grand mean. This method makes it easy to get the useful grand mean, by dividing the total value of responses by the number of responses. For example:

		Row Logic	Row Options
SUB:	Grand Mean for Brand A	SUB3	SM (Mean)
	Mean Fit for Brand A	BRANDA_FIT (1-5)	SM (Mean)
	Mean Cost for Brand A	BRANDA_COST (1-5)	SM (Mean)
	Mean Style for Brand A	BRANDA_STYLE (1-5)	SM (Mean)

This results in the calculation of the grand mean for 'Brand A'.