SAS e-Learning: Using SAS to Create Microsoft Excel Reports
|
Summary
|
|
|||||||||||||||
SAS e-Learning: Using SAS to Create Microsoft Excel Reports
SAS e-Learning: Using SAS to Create Microsoft Excel Reports
This SAS e-Learning: Using SAS to Create Microsoft Excel Reports webinar is appropriate for SAS programmers who wish to create professional looking Microsoft Excel reports from SAS.
After attending this webinar, attendees will be able to output reports from SAS to Excel by making use of techniques such as the Excel Libname, Proc Export and the ODS TAGSETS.EXCELXP destination. Attendees will also learn how to control many structural aspects of Excel workbooks, as well as being able to manipulate the content and presentation of data within Excel.
Interested in this SAS e-Learning: Using SAS to Create Microsoft Excel Reports? Contact SAS Training here to find out more
If you want to find out more about SAS e-Learning: Using SAS to Create Microsoft Excel Reports, you can make an information request below and the school will contact you with further information.
Suitability and application
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).
e-Learning
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.
Topics of this SAS e-Learning: Using SAS to Create Microsoft Excel ...
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
Expenses
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 Limited
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
Show all courses with
Amadeus Software Limited
Request information - obligation free
Contact information for Amadeus Software Limited
Amadeus Software Limited
OX28 4AZ Witney, Oxfordshire
Phone no: +44 (0) 1993 848010 
www.amadeus.co.uk
Contact Amadeus Software Limited
To request information from SAS e-Learning: Using SAS to Create Microsoft Excel Reports, please fill out the following details:
