Fundamental Report Writing with SAS

Attendees of this course should be familiar with the concepts of using procedures in Base SAS. Ideally attendees will be trained to the SAS Fundamentals level at least.

The course includes the following modules:

• FRW1 Introduction to Report Writing

Proc Report versus Proc Tabulate versus the Data Step
What is the Output Delivery System?
Best Practices for Report Presentation
Getting Started with Proc REPORT
Getting Started with Proc TABULATE
Getting Started with ODS
Workshop Session

• FRW2 Raw Data Listings with Proc report

Procedure Syntax, Options and Statistics
Creating a Basic Listing
Ordering Data
Controlling the Appearance of Columns
Creating Labels for Groups of Columns
Workshop Session

• FRW3 Creating Summary Tables with Proc Tabulate

Procedure Syntax, Options and Statistics
Creating Basic Summary Tables
Using the All keyword
Adding Statistics to Summary Tables
Formatting Results
Workshop Session

• FRW4 Using the Output Delivery System

ODS Syntax
Creating Output for Internet Browsers
Creating Output for Microsoft Excel
Creating Output for Microsoft Word
Creating Output for Portable Document Format Files
Changing the Appearance of Output
Workshop Session

• FRW5 Further Proc Report

Controlling Classification Levels
Working with Analysis Variables
Breaking Reports on Groupings
Working with Across Variables
Using Compute Blocks
Workshop Session

• FRW6 Further Proc Tabulate

The Consequences of Missing Values
Working with Page Dimensions
Calculating Percentages
Workshop Session

• FRW7 Further Output Delivery System

Working with Further ODS Statements
Multi-page and 3D Reports
Creating Multiple Output Files
Basic Style Control with Proc REPORT
Basic Style Control with Proc TABULATE
Traffic Lighting Techniques
Workshop Session

Benefit from familiarity with existing systems and data by holding a course or seminar at your offices. Courses can be given for 2 or more people and a sliding scale of course prices enable you to benefit by holding a course for larger groups. We would suggest keeping the class size to a maximum of 10 to make sure delegates gain maximum benefit. Seminars can be presented for any number of people depending on the facilities that you have available.

After this two day course attendees will be able to use Proc REPORT, Proc TABULATE and the Output Delivery System to create professionally presented reports. Delegates will understand how to create reports for Internet Browsers, Microsoft Excel, Microsoft Word and Portable Document Format files in addition to the traditional SAS listing files.

£620

Amadeus Software - SAS training courses

Amadeus Software is an independent Business Intelligence company specialising in SAS. We provide SAS Training Courses, Seminars, Worshops and e-Learning near Oxford and at our Customers offices throughout Europe.

Example of training courses:

• SAS Fundamentals
• SAS Enterprise Guide
• SAS Programming
• SAS Macro
• SAS SQL

Training courses are classroom based and are a mixture of demonstration sessions and workshop sessions. Amadeus have been providing SAS training courses since 1989 and have a wealth of experience to share. Courses can be customised to suit your requirements. All Amadeus Software public events are held at our training centre, Mulberry House, a recently renovated Victorian building which is located in a wonderful setting overlooking Church Green, in the centre of Witney. Our training room is equipped with the latest hardware, software and demonstration equipment.

Refreshments are provided throughout the day and can be enjoyed in our café area with a flat screen TV and magazines, or outside in our beautiful walled garden where there is also a pool table in the heated log cabin to use. Wireless and internet access are available during the course breaks.

There is plenty of quality local accommodation and a good variety of pubs and restaurants including The Fleece next door, which was a favorite watering-hole of Dylan Thomas when he lived in the nearby village of South Leigh.

Why Choose Amadeus for your SAS Training?

Trainers

'The best course instructor I have had for SAS training, clear, knowledgeable, calm and helpful'  Pfizer - Macro and GPLOT

• Full time SAS Consultants
• Experienced and have used SAS for many years
• Use SAS on a daily basis as well as teaching
• Are SAS certified
• Follow an internal training programme
• Bring real world experience to the classroom
• Understand the importance of a practical approach