Base Certification Review
Simply fill in the form below to sign up for our Newsletter:
Sign Up for our Newsletter

Base Certification Review Training


Course Length:

This is a three-day course.

Course Summary:

The Base Certification Review course is useful to refresh the minds of those who have undergone either Newtyne's Foundations and Data Step Techniques or the Fast-Track Base Programming training (or their equivalents) but do not use all of the certification topics on a day-to-day basis.  Also, when new software versions bring additional functions and features we ensure 'seasoned' programmers become fully aware of them.  Newtyne's experienced trainers will close gaps in knowledge and provide the best chance of attaining certification.

What you will be taught: 

  • Introduction
    • Course Data
    • Review of Data Step Techniques - The Language of SAS
  • Selecting Variables and Observations
    • KEEPing and DROPing Variables
    • The IF Statement
    • The WHERE Statement
  • The OUTPUT Statement
    • Review the implicit output process
    • Use explicit output statements
    • Output to numerous datasets
  • Combining Data 
    • Joining Datasets Vertically
    • Data Set Options - RENAME= FIRSTOBS= OBS= IN=
    • Joining Data Sets Horizontally - Match-Merging
  • Manipulating Data using Functions
    • Transforming Character Data
    • Transforming Numeric Data
    • Transforming Dates
    • Changing Variable Type
  • Formats
    • Supplied Formats
    • User-Defined Format 
  • Frequency Counts with PROC FREQ
    • One-way Frequency Tables
    • Two-way Frequency Tables
    • Creating Output Databases
  • Summary Statistics with PROC MEANS
    • The VAR Statement
    • The Class Statement
    • PROC MEANS Options
  • Analysing  Values with PROC UNIVARIATE
    • The VAR Statement
    • The Class Statement
    • The ID Statement
  • The Output Delivery System
    • ODS Destinations
    • Creating HTML files with ODS
    • Creating Excel files with ODS
    • Creating a Dataset with ODS

 What you should already know:

  • In order to gain a suitable understanding from this course it is expected the you should have attended the Foundations - The Language of SAS and the Data Steps Technique - The Language of SAS Course or a comparable course of study. Alternatively have completed at least 6 months developing code in the Language of SAS.
    • Building DATA steps
    • KEEP and DROP to select variables
    • IF and WHERE statements to select observations
    • Conditional Processing with IF-THEN-ELSE
    • Summarising observations using RETAIN or SUM statement
    • System Formats


The Newtyne Base Certification Review course includes:

  • Instructor-led Training.
  • Practice Exam.
  • Free-format Q & A Session.
  • Formal SAS Certification Exam


On the afternoon of the third day the Newtyne Instructor will accompany the delegates to an independent testing centre where they will sit the SAS Certified Base Programmer for SAS 9 exam.  Newtyne course fees include the cost of the certification exam.



If the dates below do not suit please contact us on +44 (0)131 225 6952 as alternative dates can be arranged.



Don't Delay - Book Today!

Select a date and click on the button below to register.