Australian Bureau of Statistics
4402.0.55.001 - Microdata: Childhood Education and Care, Australia , June 2011
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 25/10/2012
|Page tools: Print Page Print All RSS Search this Product|
USING THE CURF
There are a series of unique identifiers on records at each level of the file. Household's have a household identifier (ABSHID) and children have a child identifier (ABSPID). Repeating datasets also have identifiers to identify the type of care used by the income unit (ABSIID) and the child's care (ABSCID).
File level identifiers
The following are the identifiers:
1. Income unit = ABSHID
2. Income unit care = ABSHID, ABSIID
3. Child = ABSHID, ABSPID
4. Child care = ABSHID, ABSPID, ABSCID
All these identifiers are on each level.
As well as uniquely identifying all units, the identifiers are vital to copying attributes from one type of counting unit to another, for associated units. For example, an income unit variable such as the labour force status of parents can be copied to all the children within the family. The means by which this might be done in SAS is illustrated below:
PROC SORT DATA=CEC11E.CEC11EHH OUT=CEC11EHH; BY ABSHID;
PROC SORT DATA =CEC11E.CEC11EPN OUT=CEC11EPN; BY ABSHID ABSPID;
DATA MERGFILE (KEEP=ABSHID ABSIID ABSPID ABSCID LFSPAR);
MERGE CEC11EHH CEC11EPN;
SORT CASES BY ABSHID.
/KEEP=ABSHID ABSIID ABSPID ABSCID.
SORT CASES BY ABSHID ABSPID.
MATCH FILES FILE=SORTEDCH
The following is an example of an income unit where the data item LFSPAR has been copied from the income unit level onto the child level.
A number of questions included in the survey allowed respondents to provide one or more responses. Each response category for one of these 'multi-response questions' (or data items) is basically treated as a separate data item. These data items have the same general data item identifier (SASName) but are each suffixed with a letter – A for the first response, B for the second response, C for the third response, D for the fourth response and so on.
For example, the multi-response data item 'All sources of income of parent(s)' (with a general SASName of ASCIPAR – see data item list), has five response categories. Consequently, five data items have been produced - ASCIPARA, ASCIPARB, ASCIPARC, ASCIPARD and ASCIPARE.
Each data item in the series (i.e. ASCIPARA-- ASCIPARE) will have two response codes: A 'Yes' response (for the first in the series (code 1), for the second in the series (code 2) etc.) and a 'Null' response (code 0) indicating that the response was not relevant for the respondent. The first data item in the series includes a 'Not Applicable' response (i.e. value of first character in series) which comprises the respondents not asked the questions (e.g. ASCIPARA with value of 9).
It should be noted that the sum of individual multi-response categories will be greater than the population or number of people applicable to the particular data item as respondents are able to select more than one response. Multi-response data items can be identified in the data item list as SASNames followed by a range of letters in brackets; for example, ASCIPAR(A-E).
USING REPEATING DATASETS
The income unit and child levels are counting units, whereas the income unit care, child care and day care levels are repeating datasets. The repeating datasets in the CEaCS are a set of data with a counting unit which may be repeated for a child or an income unit. For example, a child may have more than one instance of child care. Also, the child will have summary records in addition to base records.
Consider a child who attended long day care and family day care and also received care from a grandparent. At the child care level this child would have three base child care records (long day care, family day care and grandparent care) because they attended three separate instances of child care. This child would also have summary records that are aggregates of care information (for example a record summarising all formal care the child attended).
Repeating datasets are only useful when common information is collected for each instance of a counting unit. For example, each child in a family has several instances of care (CARINDX) with a cost of care after the Child Care Benefit and Child Care Rebate (COSTCCR) associated with it, for last week and usual instances (USLWFLG). Therefore, each child care unit has a cost of care after CCB and CCR (COSTCCR) associated with it. This enables a table to be run on all instances of care.
To run a table on the dataset outlined above, the following SAS code (or equivalent) can be used. This will give you output that shows the frequency of each cost (dollar value) for each type of care usually used by the single child:
PROC FREQ DATA=CEC11E. CEC11ECC;
WHERE USLWFLG = 2;
Note that although the output above only relates to a single child, the totals are a count of all conditions for that child. That is, the table above shows the frequency of different costs for each type of care for an individual child.
As with the child level file, some data items in a repeating dataset are only applicable to a particular sub-population of the dataset. For instance, the item "Main reason intends to claim for the cost of formal care" from the child care level is only applicable for formal care. Records outside the sub-population will appear as a "Not applicable" e.g. children with just informal care or no care. In the child care level the usual or last week flag must be used. Refer to 'Using Flag Items'.
In addition, note that if you want to create ranged hours or cost tables which include custom totals for type of care (for example, all formal care excluding occasional care) you need to sum hours and cost for the types of care included in your total to the child level before ranging the result.
USING FLAG ITEMS
Usual or last week flag
There is a usual or last week care flag USLWFLG that allows users to look at a child's care usage for the reference week (last week) or their usual care usage. This flag is on the child care level. A similar flag at the Income unit care level (IUCSFLG) filters whether the care used by the family is on a usual or last week basis. These flags also include or exclude preschool from care used last week or usually.
It is imperative that the usual or last week care flags be used when any data items from the child care level or the income unit care level are used, regardless of whether the care level data items are used alone or with other child level or income unit level data items. If these flags are not used for child care or income unit care data items, the data will be incorrect.
The categories of the flags are:
1. Care usually used including preschool
2. Care usually used excluding preschool
3. Care used last week including preschool
4. Care used last week excluding preschool
Labour force scope flag
In households where all adults were out on scope of the LFS, no information was obtained for the 2011 CEaCS. However, as long as at least one parent in the household was in scope for the LFS, information about children aged 0–12 years and some information about their parents were able to be included in the 2011 CEaCS.
There is a labour force scope flag (LFSFLAG) to indicate whether the income unit is out on scope. This flag indicates if one parent in a family was out on scope or coverage. Limited employment and demographic data is available for these families.
Information about the working arrangements used by parent/guardians to help care for their child was not available for parent/guardians who were out on scope or coverage of the labour force for any reason.
To enable analysis at a regional level, each record on the CURF contains a state/territory identifier (STATECF) and two sub-state identifiers – Capital city/Balance of state/Territory (AREAOUT) and Remoteness structure (AREAREMC). The AREAOUT geographic data item has two output categories – Capital city and Balance of state/Territory. Only the capital city statistical divisions (as defined in the Australian Standard Geographical Classification ASGC (cat. no. 1216.0)) of the six states are included in the Capital city category. All other regions in Australia, including the territory capitals Darwin and Canberra, are classified to the Balance of state/Territory category.
Conditions of Use of Geographic Data Items
To provide CURF users with greater flexibility in their analyses, the ABS has included several sub-state geography data items (as described above) on the Expanded CURF.
Conditions are placed on the use of these items. Tables showing multiple data items, cross tabulated by more than one sub-state geography at a time are not permitted due to the detailed information about small geographic regions that could be presented. However, simple cross-tabulations of population counts by sub-state geographic data items may be useful for clients in order to determine which geography item to include in their primary analysis, and such output is permitted.
CURF FILE NAMES
The 2011 CEaCS Expanded CURF can be accessed through the RADL and is available in SAS, SPSS and STATA formats. The CURF comprises the following files:
These files contain the data for the CURF in SAS format.
CEC11EHH.SAS7BDAT - the CEaCS CURF income unit level file in SAS for Windows format.
CEC11EIC.SAS7BDAT - the CEaCS CURF income unit care level file in SAS for Windows format.
CEC11EPN.SAS7BDAT - the CEaCS CURF child level file in SAS for Windows format.
CEC11ECC.SAS7BDAT - the CEaCS CURF child care level file in SAS for Windows format.
These files contain the data for the CURF in SPSS format.
CEC11EHH.SAV - the CEaCS CURF income unit level file in SPSS format.
CEC11EIC. SAV - the CEaCS CURF income unit care level file in SPSS format.
CEC11EPN. SAV - the CEaCS CURF child level file in SPSS format.
CEC11ECC. SAV - the CEaCS CURF child care level file in SPSS format.
These files contain the data for the CURF in STATA format.
CEC11EHH.DTA - the CEaCS CURF income unit level file in STATA format.
CEC11EIC. DTA - the CEaCS CURF income unit care level file in STATA format.
CEC11EPN. DTA - the CEaCS CURF child level file in STATA format.
CEC11ECC. DTA - the CEaCS CURF child care level file in STATA format.
Data Item List
The Data item list contains all the data items, including details of categories and code values, that are available on the Expanded CURF. It is available on the Downloads tab.
FORMATS.SAS7BCAT - the SAS format file which provides labels for associated code values in the SAS version of the CURF.
FREQUENCIES_CEC11EHH.TXT - contains weighted and unweighted frequency counts for all income unit unit level data items. The file is in plain text format.
FREQUENCIES_CEC11EIC.TXT - contains weighted and unweighted frequency counts for all income unit care level data items. The file is in plain text format.
FREQUENCIES_CEC11EPN.TXT - contains weighted and unweighted frequency counts for all child level data items. The file is in plain text format.
FREQUENCIES_CEC11ECC.TXT - contains weighted and unweighted frequency counts for all child care level data items. The file is in plain text format.
These documents will be presented in a new window.
This page last updated 24 October 2012