Reporting Techniques - The Language of SAS
Simply fill in the form below to sign up for our Newsletter:
captcha 
Sign Up for our Newsletter

Training @ Newtyne

Course Length:

This is a two-day course.

Course Summary:

The Reporting Techniques course includes more in-depth techniques for generating reports and output using the Output Delivery System and the REPORT and TABULATE Procedures.

What you will 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
  • Customize 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
  • Summarizing data with the FREQ, MEANS and TABULATE procedures

 


 

If the dates below do not suit please contact us on +44 (0)131 225 6952 as alternative dates can be arranged.

 


 

Don't Delay - Book Today!

Select a date and click on the button below to register.