CERTIFIED BASE SAS PROGRAMMER

CERTIFIED BASE
SAS PROGRAMMER

COURSE ID – DBAL-103 DURATION – 32 Hours

 
Program Objective
The SAS Base Programmer course in a beginner level course for a SAS professional. This training has been designed to enable you to start your analytics career with SAS and prepare for the SAS Base Programmer certification.
This SAS course explores the SAS tool and different techniques to help you access and manage data, create data structures, generate reports, and handle errors. These techniques are mandatory for a professional to start working on the next SAS assignment and forms a strong base for advanced techniques and certifications.
This SAS Base Programmer training presents all these concepts in an easy to understand manner, using actual coding examples and demos to clarify the concepts and present the actual method of implementation. This course will encompass all to help you emerge as an Industry ready professional in the analytics field.
Who Should do this course?
This analytics certification course is for all those aspirants who want to switch into the field of data science/ business analytics and are keen to enhance their technical skills with exposure to cutting-edge practices. The Students/professionals/Candidates from various quantitative backgrounds, like Engineering, Finance, Maths, Statistics, Business Management who want to head start their career in analytics.
Pre-requisites
There are no prerequisites for this course. Knowledge of any programming and data analytics exposure would be an advantage. For beginners, its highly recommend to complete the “Data Analytics using Excel – Tableau” course prior to this course.
Modules & Topics

Introduction to the Analytics world and SAS role

  • Analytics World
  • Introduction to Analytics
  • ETL concept and role of SAS in ETL
  • SAS in advanced analytics
  • SAS Certification: Induction and walk through

Creating Data Structures

  • Create temporary and permanent SAS data sets.
  • Create and manipulate SAS date values.
  • Export data to create standard and commadelimited raw data files.
  • Control which observations and variables in a SAS data set are processed and output.

Generating Reports

  • Generate list reports using the print procedure.
  • Generate summary reports and frequency tables using base SAS procedures.
  • Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting.
  • Generate reports using ODS statements.

Accessing Data

  • Use formatted and list input to read raw data files.
  • Use infile statement options to control processing when reading raw data files
  • Use various components of an input statement to process raw data files including column and line pointer controls, and trailing @ controls.
  • Combine SAS data sets.
  • Access an Excel workbook.

Managing Data

  • Investigate SAS data libraries using base SAS utility procedures.
  • Sort observations in a SAS data set.
  • Conditionally execute SAS statements.
  • Use assignment statements in the data step.
  • Modify variable attributes using options and statements in the data step.
  • Accumulate sub-totals and totals using data step statements.
  • Use SAS functions to manipulate character data, numeric data, and SAS date values.
  • Use SAS functions to convert character data to numeric and vice versa.
  • Process data using do loops.
  • Process data using one-dimensional SAS arrays.
  • Validate and clean data.

Handling Errors

  • Identify and resolve programming logic errors.
  • Recognize and correct syntax errors.
  • Examine and resolve data errors.

Need help choosing what course you should enroll to?

Talk to us today to help us understand your requirements in detail and help you achieve your analytics training goals!