| DURATION | PRICE | inc-VAT | |
|---|---|---|---|
| 2 | £850 | £1,020 | |
The Reporting Techniques course provides delegates with in-depth techniques for generating reports and output using the Language of SAS Output Delivery System (ODS) and the REPORT and TABULATE Procedures. | |||
WHAT YOU'LL BE TAUGHT...
Output Delivery System (ODS)
- Identifying ODS Objects
- Capturing ODS Output in Data Sets
- ODS Output Destinations
- ODS Options
- Exporting to Excel using ODS
PROC REPORT
- Options and Default Options
- Statements
- BREAK and RBREAK
- Computed Columns
- DEFINE Statement Attribute Options
- Other Options
PROC TABULATE
- Review of PROC Tabulate Syntax
- Customise Row and Column Headings
- Formatting Cell Data
- Percentages
- BY-Group Processing
- Output Data Sets
WHAT YOU SHOULD ALREADY KNOW...
In order to gain a suitable understanding from this course, it is expected that you should have attended the, 'Foundations: The Language of SAS' and 'Data Step Techniques: The Language of SAS' courses (or comparable course of study), or have completed nine months of developing code in the language of SAS covering topics including:
- Use of Global statements e.g. LIBNAME FILENAME and OPTIONS
- Access data sources including Data Sets and external files
- Use of functions to transform character data (e.g. SCAN, FIND, SUBSTR)
- Use of functions to transform numeric data (e.g. CEIL, INT, FLOOR, ROUND)
- Use of functions to transform dates (e.g. DAY, MONTH, YEAR, INTCK)
- KEEP and DROP to select variables
- IF and WHERE statements to select observations
- Conditional Processing with IF-THEN-ELSE
- Iterative DO Loops
- Conditional Do Loops - DO WHILE, DO UNTIL
- Compile-Time statements (e.g. LENGTH, RETAIN)
- Combining Data Sets vertically and horizontally
- Summarising data with the FREQ, MEANS and TABULATE procedures
