This section describes the options available in the Define Recode window. It is intended as a reference.
If you are new to recodes, see the introduction to recodes in SuperCROSS, which contains a full guide to creating recodes with worked examples.
Define Recode Window
Use the Define Recode window to create and modify recodes:
The name of the recode.
- Leave this unchanged to edit the field or recode you opened.
- Change it to create a new recode field.
The list of available values for this field.
|Recode Values||The list of values currently include in the recode. Only values that appear in this list will display in the table.|
- Use Names
- Use Codes
- Use Both
Use these options to specify whether to display values using their names, codes, or a combination of both.
Changing this setting will not change any values already added to the Recode Values list. You can therefore use this option to include a combination of names, codes and combinations of both in your recode if necessary.
|>> Singly >>||Click to add the selected Field Values to the recode as individual items.|
|>> Group >>|
Click to add the selected Field Values to the recode as a group.
Make sure you set the Group Name first before adding the group.
|>> Subitems >>||For hierarchical fields, click to add|
|<< Remove <<||Click to remove the selected Recode Values from the recode.|
|Group Name||When adding a group to the recode, set this to the group name and then click >> Group >>|
|Total Name||When creating a total for the recode, select the values you want to include in the total, set this to the total name, and then click Add Total.|
|Select all||Click to select all the Recode Values. You can use this when creating totals and when you need to remove all the values from the recode.|
|Add Total||Click to add a total to the recode based on the selected Recode Values.|
|Footnote||Enter text here to display as a footnote whenever the recode is used in a table.|
Define Recode Window - Summation Options
When you are recoding the summation options, the Define Recode window has some additional options that only apply to summation options:
The Weight By drop-down list becomes available when you are using a weighted database. The exact options available will depend on the weighting configuration.
Select one of the following:
|Unweighted Sum||Lets you add unweighted measures with no functions.|
|Replicate Weights||Lets you add functions such as Jack-Knife. If a replicate weight is selected and a non replicate function is added for a measure, the first weight in the replicate weight collection is used in the function.|
|Main Weight|| |
If Unweighted Sum is selected, you can select from the following functions. Click >> Add >> to add the function to the currently selected value in the Recode Values list.
|Sum||The total of all the values.|
|Mean||The total of all the values divided by the number of values.|
|Standard Deviation||How spread out a distribution is, defined as the square root of the variance.|
|Variance||How spread out a distribution is. This function is closely related to the Standard Deviation. The variance is defined as the average squared deviation of each number from its mean.|
|First Quartile||Cuts off the lowest 25% of data.|
|Last Quartile||The last quartile cuts off highest 25%.|
|First Decile (10%)||Cuts off the lowest 10%.|
|Second Decile (20%)||Cuts off the lowest 20%.|
|Third Decile (30%)||Cuts off the lowest 30%.|
|Fourth Decile (40%)||Cuts off the lowest 40%.|
|Median (50%)||Cuts the data set in half (the median is the middle of a distribution).|
|Sixth Decile (60%)||Cuts off the lowest 60%.|
|Seventh Decile (70%)||Cuts off the lowest 70%.|
|Eighth Decile (80%)||Cuts off the lowest 80%.|
|Last Decile (90%)||Cuts off the lowest 90%.|
|Gini||A measure of inequality of a distribution, defined as a ratio with values between 0 and 1. The numerator is the area between the Lorenz curve of the distribution and the uniform (perfect) distribution line; the denominator is the area under the uniform distribution line.|
|Largest (3)||Maximum and next 3 largest values from contributing unit records.|
|Smallest (3)||Minimum and next 3 smallest values from contributing unit records.|
|Count Distinct||A count of the number of distinct results.|
If Replicate Weights or Main Weight is selected, additional functions will be available to select. The exact functions available will depend on how weighting has been configured.
|Confidentiality - At Level|
The fact table to use when determining whether to apply the concealment rule. This setting only applies to concealment rules, not to rounding rules.
This setting applies only to concealment rules, not to rounding rules. It is used when the rule is based on the number of contributors to a cell value: SuperCROSS needs to know which fact table to use when counting the number of contributors.
You can also set the level to Default, which means that each measure is summed at its own level. For example, for a database containing two tables, Person and Household:
- With the level set to Default: contributors to, or percentages for, a measure from the Person table will be counted at the Person level and contributors to or percentages for a measure from the Household table will be counted at the Household level. If there are two people in one household, using a measure from the Person level will count two contributors, but using a measure from the Household level would count only one.
- With the level set to Household: contributors to or percentages for a measure from either table will be counted at the Household level. If there are two people in one household, and you are using a measure from the Person table, using the Person level will count two contributors, but using the Household level would count only one.
|Confidentiality - Rule|
A rounding rule (confidentiality or concealment rule) for the selected measure in the Recode Values list. The following rounding rules are available by default without any configuration.
There may also be a number of concealment rules available for selection, if these have been defined in a confid.ini file for this database:
|Rule||Description||Effect of Applying Rule|
|None||No rule is applied to the selected field (when None is selected, no footer displays).||None|
|0-3 Rounding||Randomly changes any values of 1 and 2 in the table to either 0 or 3.|
- 0 is not changed
- 1 is changed to 0 with probability 2/3
- 1 is changed to 3 with probability 1/3
- 2 is changed to 0 with probability 1/3
- 2 is changed to 3 with probability 2/3
- Values of 3 and above are not changed
|Random Rounding||All values/numbers in the table are rounded up or down to base 3.|| |
|1-4 Rounding||Randomly changes any values in the table between 1 and 4 inclusive to a random number between 1 and 4 with equal probability distribution.|
- 0 is not changed
- 1 is changed to 1, 2, 3 or 4 with equal probability
- 2 is changed to 1, 2, 3 or 4 with equal probability
- 3 is changed to 1, 2, 3 or 4 with equal probability
- 4 is changed to 1, 2, 3 or 4 with equal probability
- Values of 5 and above are not changed.
This rule is similar to random rounding in that all values are rounded. However, the amount by which values are rounded depends on the size of the value.
- 0 is not changed
- Values from 1 to 18 are randomly rounded to one of the two nearest multiples of 3
- Values of 19 randomly round to 18 or 20
- Values from 20 to 100 randomly round to one of the two nearest multiples of 5
- Values greater than 100 randomly round to one of the two nearest multiples of 10.
Save and Reload Recodes
You can save and reload recodes. See save and load recodes for more information.
Delete a Recode
To delete the recode:
- Go to the Fields window.
- Select the recoded field (recoded fields appear in bold).
- Click Delete.