|Page tools: Print Page Print All|
Using the TableBuilder
Many continuous items contain special codes such as '00. Not applicable'. In these cases the data item can also be found under the appropriate level in the variable list in Table view. Special codes are automatically excluded from calculations of sums, means, medians or ranges.
The example below shows how special codes are displayed in the Data Item List. Minimum and maximum limits and the minimum increments for ranging continuous items are also detailed in the data item list.
Multiple response data items
A number of data items allow a respondent to have more than one response. For these items, a person is counted against each category they responded to and consequently the sum of the categories may be different to the total. The table below displays the multiple response data item 'Type(s) of activity for which aid(s) or equipment used' with the Person weight. For example, a person who uses an aid for Toileting, Dressing and Eating will be counted against each of these three categories.
Multiple response data items are identified in the Data Item List in the label using the indicator ‘<multiple response>’.
Understanding what is being counted
The SDAC TableBuilder has four weights available in 'Summation Options'. These weights are used to specify what is counted in tables. Tables can be created to sum to the total count of households, families, income units and people. For more information about how SDAC is weighted, see ‘Estimation methods’ on the Explanatory notes page (cat. no. 4430.0).
It is critical that the correct weight is used when creating tables. For SDAC TableBuilder the default summation is the Person weight, and without changing the summation option, all tables will automatically count the number of people in the table.
Generally, you should use the weight which corresponds to the level of analysis you are undertaking. For example, use the Household weight for items on the household level or use the Person weight for items on the person level. You can, however, select different weights for tables. When changing the summation option, or using data items from multiple levels, estimates should be considered carefully to understand what the table is counting. Some examples of interpreting data from different levels are provided below.
For the counting unit of each level of data in SDAC, see the File Structure page. For more general information, and instructions on how to change summation options in TableBuilder, see the Summation options, ranges and quantiles page.
Using a weight from a lower level with a data item on a higher level (one to many relationship)
The table below uses the family level item ‘Number of persons with a disability in family’ with the Person weight. In this table, 1,749,300 people live in a family with 2 people with a disability. As family level data is only applicable to people living in households, the 195,700 people in cared accommodation are ‘Not applicable’. The data item has also been collapsed for families with 4 or more people with a disability, using the custom data view.
Using a weight from a higher level with a data item on a lower level (many to one relationship)
The table below uses the person level data item ‘Accessibility and Remoteness Index of Australia (ARIA)’ with the Household weight. For geography data items, the value of the data item is the same for all people in the household. In this table, 89,600 households are located in Remote Australia. This excludes people living in cared accommodation as the household weight is applicable only to households. If the Person weight was used with this data item, persons living in cared accommodation would be included in the count.
The table below uses the condition level data item ‘Type of long term condition reported’ with the Person weight, and includes only people who have Endocrine, nutritional and metabolic disorders. In this table, the total shows 2,360,800 people have one or more endocrine, nutritional and/or metabolic disorder(s), 1,065,600 people have Diabetes and 1,148,200 people have High cholesterol. As some people may have multiple conditions (e.g. Diabetes and High cholesterol), the sum of categories is greater than the total (2,760,200 versus 2,360,800).
· applying minimum and maximum values, and minimum increments, to continuous items
· perturbing the data
· applying sparsity rules (including zero value cells and table suppression)
Where an item triggers sparsity rules, the ‘custom data’ view can be used to collapse categories into usable formats.
Information on perturbation and sparsity can be found in the TableBuilder, User Guide (cat. no. 1406.0.55.005).
These documents will be presented in a new window.
4430.0.30.002 - Microdata: Disability, Ageing and Carers, Australia, 2018 Quality Declaration
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 20/11/2019