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'.

Related topics:

Banner logic

Mean Summary tables

Logic