SAS Training

 

Popular 100% Job Guaranteed

SAS Training details

Prerequisites : Anyone can learn Web Designing and Development.

Level : Beginner  (By the end of your course become a Professional)

Book Career Guidance at Meultech




    SAS Training Developer Curriculum

    Duration :  __ Months

    Batches : Weekend and Weekday Batches Available

    Mode : Online and Offline

    Certificate : Available after completing the course and projects.

    Placement : Available

     

    SAS Programming 1: Essentials

    • Module 1 Essentials

      The SAS programming process, using SAS programming tools, Understanding SAS Syntax

    • Module 2Accessing Data

      Understanding SAS data, Accessing data through libraries, Importing data into SAS

    • Module 3Exploring and Validating Data

      Exploring data, Filtering rows, Formatting columns, sorting data and removing duplicates.

    • Module 4Preparing Data

      Reading and filtering data, Computing new columns, conditional processing

    • Module 5Analyzing and Reporting on Data

      Enhancing reports with titles, footnotes, and labels, creating frequency reports, creating summary statistics reports.

    • Module 6Exporting Results

      Exporting data and exporting reports

    • Module 7Using SQL in SAS

      Using Structured Query Language in SAS, Joining tables using SQL in SAS.

    SAS Programming 2: Data Manipulation Techniques

    • Module 1 Controlling DATA Step Processing

      Setting up for this course, understanding DATA step processing, directing DATA step output

    • Module 2Summarizing Data

      creating an accumulating column, processing data in groups

    • Module 3Manipulating data with functions

      Understanding SAS functions and CALL routines, using numeric and date functions, using character functions, using special functions to convert column type

    • Module 4Creating Custom Formats

      Creating and using custom formats, creating custom formats from tables

    • Module 5Combining Tables

      Concatenating tables, merging tables, identifying matching and non matching rows

    • Module 6Processing Repetitive Code

      Using iterative DO loops, using conditional DO loops

    • Module 7Restructuring Tables

      Restructuring data with the DATA step, restructuring data with the TRANSPOSE procedure.

    SAS Programming 3: Advanced Techniques 

    • Module 1 Getting Started

      Setting up for this course, DATA step review.

    • Module 2Using Advanced Functions

      Using a variety of advanced functions, Performing pattern matching with Perl regular expressions.

    • Module 3Defining and Processing Arrays

      Defining and referencing one-dimensional arrays, Doing more with one-dimensional arrays, defining and referencing two-dimensional arrays.

    • Module 4Defining and Processing Hash Objects

      Declaring hash objects, defining hash objects, Finding key values in a hash object, writing a hash object to a table, Using hash iterator objects.

    • Module 5Using Utility Procedures

      Creating picture formats with the FORMAT procedure, Creating functions with the FCMP procedure

    SAS SQL: Essentials

    • Module 1 Essentials

      Setting up for this course, overview of SAS foundation, course logistics, course data files, introducing the Structures Query Language, Overview of the SQL procedure, exploring tables, specifying columns.

    • Module 2PROC SQL Fundamentals

      Subsetting data, Presenting data, Summarizing data, creating and managing tables, Using DICTIONARY tables.

    • Module 3SQL Joins

      Introduction to SQL joins, Inner joins, Outer joins, Complex SQL joins.

    • Module 4Subqueries

      Non correlated subqueries, Correlated subqueries, In-line view, creating views with the SQL procedure, subqueries in the SELECT clause, remerging summary statistics

    • Module 5Using and Creating Macro Variables in SQL

      Interfacing PROC SQL with the macro language, creating data-driven macro variables with a query, using macro variable in SQL.

    • Module 5Accessing DBMS Data with SAS/ACCESS

      Overview of SAS/ACCESS technology, SQL pass-through facility, SAS/ACCESS LIBNAME statement, PROC FedSQL
     

    Facts

    Facts on SAS Training Course
    199+

    Students

    Number of students enrolled in this Course
    165+

    Completed

    Students who have completed the course
    95%

    Placed

    Number of students who received a Job opportunity on completion of Course