£90.00 (incl. VAT):
This learning pathway will give you an introduction into the use of PROC SQL in the language of SAS.
There are mini quizzes and comprehensive exercises throughout to help assess and reinforce your learning.
By the end of this course, you will be able to:
To get the most out of this course, it is expected that you should have attended the Fundamentals - the Language of SAS course (or comparable course of study).
If not, we would advise that you have at least six months experience of developing code in the language of SAS, including:
A prior understanding of SQL is not required.
For the hands-on practice activities you will need access to an environment that runs the programming Language of SAS. On our courses, we signpost you to some of the free tools available.
Check out the link below to review system requirements:
Introduction to SQL Language Elements
Learning Objective: Explain how to implement SQL within the language of SAS;
Selecting COLUMNS & ROWS
Learning Objective: Describe how to subset data to select columns and rows.
Learning Objective: Explain how to summarise and classify data
The following reference modules are included to support your learning:
Introduction to SAS Programming
Learning Objective: Explain what the Language of SAS is used for and by whom.
Learning Objective: Explain how the Language of SAS is used to access, manage, analyse and present data.
Investigating SAS datasets
Learning Objective: Define how to investigate datasets in the Language of SAS using two types of Procedure.
Learning Objective: Explain how Programs can be run in the Language of SAS.
Learning Objective: Describe the key programming concepts within the Language of SAS.
Data Step Processing
Learning Objective: Explain how the two phases of Data Step Processing work to create new datasets and variables.
Selecting Variables and Observations
Learning Objective: Define Variables and Observations to be read from and written to datasets.