This article is part of The Definitive Guide to Uploading and Preparing Data.
Sometimes you need to create a net on multiple response variables.
A net in this scenario, is defined as "at least one mention of". In Crunch, you can do this by creating a new subvariable which is added to the overall multiple response variable.
Note: at present, a new feature is under construction that will enable annotated subtotals (in bold) on multiple response variables in the same way as subtotals on categorical variables. It is likely the feature will be released in early 2021. In the meantime, please consider the alternatives below - Crunch Automation and the web app.
When making nets like this, you need to be mindful where there are different levels of missing data amongst the contributing variables. Do you want the net to consider only the common sample (ie: with no missingness, or "complete cases") or do you want to consider the entire sample or only the sample that has at least one value that is non-missing? You should check your subvariable to ensure it has the desired level of missingness before combining it into an array.
In the web app
There are two ways of approaching this in the web app.
The easiest way is to use the Subtotals button in the Properties of a multiple response variable.
- Create a new subtotal
- Drag-drop the subvariables that you want to include in the netting
- Given it a name
- Save
An alternative is below - it is somewhat more cumbersome.
- derive a new variable that will be the net (eg: use the Filter Builder)
- include it into the multiple response variable definition
- Create a new dichotomous variable using the Filter Builder.
- Edit an existing multiple response variable using Edit Variable under its Variable Properties.
- Note: in doing this, at present, you cannot build the net subvariable by referring to same array that you want to add it to. You should go back to referring to source variables when building a new derivation.
Note: at present, a new feature is under construction that will enable annotated subtotals (in bold) on multiple response variables in the same way as subtotals on categorical variables. It is likely the feature will be released in early 2021. In the meantime, please consider the alternatives below - Crunch Automation and the web app.
Crunch Automation
- You can create a net on a multiple response variable using a combination of Crunch Automation commands.
- Note: you cannot change the order of subvariables using scripting (in the web app you can do this with drag-drop). For that reason, if you want to interspere the nets subvariables with the other subvariables, then you should define a new multiple response variable in the order of subvariables you want (including the net subvaribales)
- For example:
- CREATE CATEGORICAL CASE to define the net variable(s)
- CREATE MULTIPLE DICHOTOMY to derive a new multiple response variable
Note: at present, a new feature is under construction that will enable annotated subtotals (in bold) on multiple response variables in the same way as subtotals on categorical variables. It is likely the feature will be released in early 2021. If you need further help making nets on multiple response variables using Crunch Automation, please contact Crunch Support.