SAS e-Learning: Using SAS to Create Microsoft Excel Reports

This SAS e-Learning: Using SAS to Create Microsoft Excel Reports course is taught assuming that attendees are familiar with the fundamental concepts of SAS programming and in particular the Output Delivery System (ODS).

Find out if this SAS e-Learning: Using SAS to Create Microsoft Excel Reports course is suitable for you by Requesting Information here

1. Principles and Technology

• Introduction
• Technology Options
• Advantages and Disadvantages

2. Syntax and Examples of the Main Techniques

• Sorting
• Concatenating
• Merging

3. Controlling the Structure of Excel Workbooks using ODS TAGSETS.EXCELXP

• Outputting Two Dimensional Reports
• Creating Three Dimensional and Multi-Page Reports
• Controlling the Width of Columns
• Freezing Header Rows
• Specifying Autofilters
• Printing Options

4. Manipulating the Content and Presentation of Data

• Embedding Excel Formulae and Formats
• Conditional Formatting
• Using Styles to Control Presentation
• Referencing Other Spreadsheets

Our live web events are conducted Go to Webinars(Citrix) and the requirements needed to attend a session are a PC with soundcard and speakers or a headset. The events provide an excellent opportunity for delegates to develop their SAS skills in just two hours, each delegate receives a copy of the webinar handouts

We can also customise our standard material or create e-Learning modules to suit your business requirements.

The cost of this SAS e-Learning: Using SAS to Create Microsoft Excel Reports course is £80 per delegate - find out more here.

Amadeus Software has over 20 years of expertise in providing SAS training, with an international reputation for exceptional trainers, high quality course materials and continuous professional development. 

We offer essential SAS Fundamentals courses, through to more Advanced Programming Techniques, Graphics, Reporting and Statistics. All our courses are highly interactive and we actively encourage delegate participation. They are delivered by our own expert SAS certified training team in small groups to ensure individual attention.

We are dedicated to providing excellent quality and effective SAS training courses focused on improving SAS business performance.

Blended Learning Approach

Amadeus Software has a Blended Learning Approach in which both classroom and online training programmes are available to ensure maximum effectiveness for delegates, while ensuring maximum cost-effectiveness for your organisation. Delivery Options available are:

• Public Training
• On-site Training
• e-Learning

Training courses are classroom based and are a mixture of demonstration sessions and workshop sessions. Courses can be customised to suit your requirements.

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

Course Materials

'Good course notes and exercises. Instructor knew the course content very well.'
HBOS - SAS Programming

• Structured in modules enabling us to incorporate any degree of customisation
• Organised into sessions, lectures and workshops
• Colour training materials
• Courses are written from many years of experience
• Fully indexed
• Packed full of examples and SAS techniques
• Good reference material to use back in the workplace
• Update On a regular basis controlled by our ISO9001:2000 Quality Procedures