SAS Training: SAS SQL

To participate in this SAS Training: SAS SQL course, delegates should have taken the SAS Fundamentals course and have some experience of SAS programming.

Find out if this SAS Training: SAS SQL course is suitable for you by Requesting Information here

The course includes the following modules:

• Q1 Introduction to Proc SQL

Introduction to Proc SQL
Concepts
The SAS Data Model
Workshop Session

• Q2 Selecting Data

The Select Statement
Controls and Enhancements
Analysis on Groups
Syntax Summary
Workshop Session

• Q3 Combining Data

Inner Joins
Outer Joins
Other Joins
Subqueries
Set Operations
Workshop Session

• Q4 Creating Data

Creating Tables, Views and Indexes
Changing Data in Tables
Changing the Structure of Tables
Further Topics
Workshop Session

Public Courses

Our public SAS training schedule is ideal for customers who do not have training facilities or for small groups and individuals who wish to attend training away from their offices. All Amadeus public events are held at our training centre, Mulberry House, a recently renovated Victorian building which is located in a tranquil setting overlooking Church Green, Witney Oxfordshire. Our training room is equipped with the latest hardware, software and demonstration equipment.

On-Site Training

You can benefit from the familiarity of existing systems and data by holding a SAS training course at your offices. As the course is exclusive to your organisation, delegates can interact with peers and discuss and ask questions specific to your day to day activities. Our standard course curriculum can be delivered or you can create a customised course tailored to your organisations needs.

Amadeus have extensive experience in delivering standard and customised SAS training programs to customers who have offices throughout the UK and across the globe.

The cost of this SAS Training: SAS SQL is £325 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