Australian Bureau of Statistics

Rate the ABS website
ABS Home > Statistics > By Catalogue Number
ABS @ Facebook ABS @ Twitter ABS RSS ABS Email notification service
1406.0.55.002 - User Manual: ABS Remote Access Data Laboratory (RADL), Mar 2006  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 22/02/2012  Reissue
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product  

OUTPUT

What do the different output types mean?
How do I validate my results?
Can I save my datasets in the RADL?
How should I store output exported from the RADL?
How do I produce aggregate data in Comma Separated Value format?
Can the RADL output be produced in HTML format?
Is graphical output available from the RADL?

What do the different output types mean?
There are several different categories of output files and there are different use and storage obligations for each. For further information see the Checking submitted jobs and output section of the User Manual: ABS Remote Access Data Laboratory (RADL).

General release output: This output has low confidentiality risk and is considered safe for sharing or publishing. General release output files are attached in the Results section of your job, and can be saved in your own environment.

Keep secure output: This output is too detailed for general release. Keep Secure output cannot be shared with other users unless they also have been approved by the ABS to access that CURF. Keep secure output files are attached in the Results section of your job and can be saved in your own environment. The Keep secure output must be stored securely or destroyed after viewing. For more information on how to store microdata securely see the Secure storage of ABS CURF microdata page of the User Manual: Responsible Use of ABS CURFs.

Withheld output: This output has been deemed risky and requires manual clearance by an ABS RADL Administrator. Withheld output can occur when output exceeds file size limits, contains a large number of single contributor cells or your code uses certain commands. Withheld output is not provided with the job results, but can be requested from the job results page. For further information see the Requesting withheld output if the status of your RADL job is “On Hold” section of the User Manual: ABS Remote Access Data Laboratory (RADL). Withheld output that is approved to be released is usually released as Keep secure output.

Denied output: Output that has been denied will not be generated. This occurs when the output contains too much detail for the system to release. Denied output cannot be requested.

How do I validate my results?
The 'CURF reference documentation' link in the navigator of the RADL contains frequency and weighting reports. These reports have been made available to assist users in validating their results.

Can I save my datasets in the RADL?
Datasets created in the RADL can be saved to your personal workspace in the RADL. For instructions, see How to save files to your personal workspace in this User Manual: ABS Remote Access Data Laboratory (RADL). Datasets cannot be saved outside your personal workspace (for example to your hard drive).

How should I store output exported from the RADL?
For information on the storage of microdata output see the Secure storage of ABS CURF microdata section of the User Manual: Responsible Use of ABS CURFs.

How do I produce aggregate data in Comma Separated Value format?
The RADL has a method for producing Comma Separated Value (CSV) format output in all three languages. When producing these outputs, it is important to remember that output can and may be denied due to file size limits, so you may want to limit the amount you wish to output per job.

SAS
The %PrintCSV macro in SAS provides users with the ability to produce protected aggregate output in CSV format. The macro should be invoked by the user directly after creating the aggregate dataset by using, for example, Proc Freq or Proc Summary. The macro outputs these datasets in CSV format to the relevant output file.

proc freq data=CURFLEVEL1 noprint;
tables age*sex /out=out_table;
run;
%printCSV;

There is also an option to suppress printing of column headings:

proc freq data=CURFLEVEL1 noprint;
tables age*sex /out=out_table;
run;
%printCSV(title=none);

The "%PrintCSV" macro should be used instead of a data step which includes a 'put' statement:

proc freq data=CURFLEVEL1 noprint;
tables age*sex/out=out_table;
run;
data _null_;
set out_table;
put sas ',' sex ',' age ',' count;
run;

To apply the "%PrintCSV" correctly remove the data step which includes the 'put' statement:

proc freq data=CURFLEVEL1 noprint;
tables age*sex/out=out_table;
run;
%PrintCSV

SPSS
The List command for SPSS will create output in a format similar to the CSV format but must only be used in conjunction with aggregated datasets.

get file saved.AGGREGATEFILE.
list VARIABLE1 VARIABLE2 VARIABLE3 VARIABLE4 VARIABLE5 VARIABLE6 VARIABLE7.

STATA
There is no equivalent function for Stata.

Can the RADL output be produced in HTML format?
The RADL does not support HTML output. RADL output is produced in txt format. See also How do I produce aggregate data in Comma Separated Value format?.

Is graphical output available from the RADL?
Graphical output not available in the RADL due to the risk of disclosure.

Previous PageNext Page


Bookmark and Share. Opens in a new window


Commonwealth of Australia 2014

Unless otherwise noted, content on this website is licensed under a Creative Commons Attribution 2.5 Australia Licence together with any terms, conditions and exclusions as set out in the website Copyright notice. For permission to do anything beyond the scope of this licence and copyright terms contact us.