SAS Base Programmer

Enter the fascinating world of data management and business intelligence with this introduction to SAS Base programming. The SAS Base Programmer course is designed to help developers and IT professionals get to grips with the SAS programming language to perform in depth analysis of datasets and to build rich reports based on their findings.

Over the course of seven in-depth modules, participants will be shown everything they need to know to get to grips with SAS programming, developing knowledge and skills that can be applied immediately at their place of work.

The SAS Base Programmer course is best suited to:

• Data professionals who need to improve their understanding of SAS programming for management, warehousing and analysis.
• Developers who need to extend their skillset to work with SAS datasets.
• Employees who want to improve their employment options by learning new skills in business analytics.
• IT professionals looking to re-skill for a new career in data analysis and business intelligence.
• SAS programmers who need to clarify their skills in readiness for the SAS Base Programmer Certification exam.

Using a combination of instructor-led videos, hands-on practice exercises and interactive quizzes the SAS Base Programming course is delivered online using our learning platform. The self-study approach provides students with any time, any place access to materials, allowing them to work at their own pace, whenever and wherever is most convenient.

Learners can also enlist the help of their peers using the built-in social networking platform, allowing them to trade tips and advice that can help them complete the practical exercises they encounter throughout the course.

key learning points

Starting with a basic introduction to SAS programming students will be taken through the SAS GUI environment so that they have the basic knowledge required to begin data analysis within minutes. The course will then take them through:

• The various SAS program components and how they are used in data analysis operations.
• Creating SAS datasets and accessing external data sources for holistic data analysis.
• Exporting SAS datasets and using SAS variables for advances statistical analysis.
• Creating advanced statements to create conditional reports and output.
• Troubleshooting SAS programs to identify and correct syntax and logic errors.

The course covers all of these topics and more, ensuring that students are fully prepared to sit the SAS Certified Base Programmer for SAS 9 qualification exam.

advantages of this course

Over the course of just seven modules, students will have developed a set of valuable statistical analysis skills, allowing them to accurately manipulate and report on data sets using the SAS programming language.

Learners completing the course will benefit from:

• Valuable data and statistical analysis skills that will help them perform better in their role.
• The ability to reveal valuable, actionable insights from corporate data sets that can help boost efficiency and profits.
• Skills, experience and confidence that will help students perform better within the business intelligence team, or to help them secure a promotion.
• A fully transferable, valuable skill set that will open new career options.

The SAS Base Programmer course also helps students develop the skills and knowledge required to sit and pass the SAS Certified Base Programmer for SAS 9 exam. Armed with this certification, learners will be able to clearly demonstrate their abilities and have laid the foundation for further Business Intelligence focused training.

• Units of study

Module 1

• Introduction
• Objective Slide
• Introduction to SAS
• SAS Functions and Consumers of SAS
• SAS Base Programmer Certification Exam
• SAS Base Programmer Certification Exam Registration
• Benefits of SAS Base Certification for Professionals
• Benefits of SAS Base Certification for Employers
• Thank You

Module 2 Lesson 01

• Introduction
• Objective Slide
• Introducing SAS
• Components of SAS software
• SAS GUI Environment
• SAS Program
• SAS Library
• SAS Variable Attributes
• Summary
• Thank You
• Quiz

Lesson 02

• Introduction
• Objective Slide
• Creating SAS Data sets (Instream method)
• Importing Raw Data files in SAS Data set
• Column Pointer Control
• Reading non standard numeric data
• Combining multiple Data Sets
• Accessing an Excel Work Book using SAS
• Summary
• Quiz
• Thank You

Module 3

• Introduction
• Objective Slide
• Exporting Data from SAS
• Exporting SAS data set Using Proc Export
• Controlling Observations to be Processed
• General Form of SAS Functions
• SAS Date Value
• SAS Time Functions
• Statistical Analysis of SAS Variables
• Summary
• Thank You

Module 4 Lesson 01

• Introduction
• Objective Slide
• Assignment Statements in DATA Step
• Modifying Character Values with SAS Functions
• SAS Arrays Different ways of specifying elements
• Modifying Character Values with SAS Functions
• Modifying Numeric Values with SAS Functions
• Converting Datatypes Using SAS Functions
• Processing Data with Do Loops
• SAS Arrays
• SAS Arrays Different Ways of Specifying Dimensions
• Summary
• Quiz
• Thank You

Lesson 02

• Introduction
• Objective Slide
• Selecting Variables to be Processed
• Modify Variable Attributes in DATA Step
• SAS Expressions
• Modifying Variables using Operators
• Conditionally Execute SAS Statements
• Sorting Data
• Investigating SAS Libraries
• Accumulate Column Totals in DATA Statement
• Summary
• Quiz
• Thank You

Module 5

• Introduction
• Objectives Slide
• SAS Report
• Creating a Basic Report
• Specifying Titles and Footnotes in a Report
• Creating Enhanced List and Summary Reports
• Creating Frequency Reports
• SAS Output Delivery System
• Summary
• Quiz
• Thank You

Module 6

• Introduction
• Objectives Slide
• SAS LOG
• Syntax Errors
• Data Errors
• Testing Your Program to Avoid Data Errors
• Logical Programming Errors
• Summary
• Quiz
• Thank You