3235.3.55.001 - Population Estimates by Age and Sex, Australia, 2002, Jun 2002  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 14/08/2003   
   Page tools:  

System Requirements
These files are in SuperTABLE format. To use them, you need SuperTABLE on your PC. You can download it free from Space-Time Research at (then run the file to install it), or contact your organisation's Information Technology support area. For more information, please see SuperTABLE Help.

Classifications

Estimated Resident Population (ERP)Estimate of the number of residents in Queensland as at 30 June
Year2002
GeographyERP by Australia, Statistical Division, Statistical Subdivision, Statistical Local Areas and Local Government Areas
AgeFive year age groups (ie. 0-4, 5-9, 10-14.........75-79, 80-84, 85+)
SexMale, Female


The Geographic Classification field is hierarchic. State and sub-state data can be obtained from this field by following these instructions. It is necessary to select your desired geography in order to avoid double-counting, leading to incorrect totals being displayed in your table.

Selecting hierarchical fields:

Open the 'Fields' dialogue box if it is not already open (select Cross then Fields from the menu or Ctrl+F) and recode the 'Geographic Classification (ASGC XXXX)' hierarchical field:
  1. Highlight the Geographic Classification (ASGC XXXX) field in the 'Fields' dialogue box.
  2. Choose the Recode button. The 'Define Recode' dialogue box will be displayed.

There are two hierarchies within the Geographic Classification (ASGC XXXX) field; LGA/SLA and SD/SSD/SLA. Therefore two field values, both labelled 'Total' (or the relevant state for state datacubes eg 'New South Wales'), will be displayed at the top of the Field Values list box and are the top items in the hierarchy. If this field is already in the table, the two field values will be displayed at the top of the Recode Values list box, and need to be removed. Choose the Select All button then the Remove button to move them across to the Field Values list box.

Double-click the across-arrow symbol in front of the 'Australia' (or relevant state) field value. The next sub-menu items will be displayed. Continue double-clicking the across-arrow symbol to reveal sub-menu items until the sub-menu item displays with the down-arrow symbol pointing downwards indicating that all the sub-menu items have been displayed.

Values can be grouped or added singly and other sub-area values, from anywhere within the hierarchy, can also be selected and included.

To make the selections more obvious, choose the Use Both option, which displays both the ASGC code and name, specifying the level (eg state, SSD, SD, LGA or SLA).

HINTS & TIPS
  1. To expand all the sub-items of a value, hold down the 'Shift' key on the keyboard and double-click the across-arrow symbol.
  2. To select all SLAs (in Australia, a particular state, SD or SSD), select the sub-menu item (eg 'Total' or 'New South Wales'), choose the Subitems button and select the SLA displayed (only the first SLA is displayed, but all will be selected). The same process can be used for selecting all SDs or SSDs. The Use Both option is particularly useful here.