SAS FOUNDATION & ADVANCED Online Training

The SAS Analytics portfolio also includes innovative, in-memory analytics to support customers requiring high-performance operation to handle big data and other complex environments.

SAS Foundation & Advanced Online Training Course Content
  • Introduction to SAS
    • What is SAS?
    • Why SAS?
    • Industries Covered by SAS
    • Modules/Applications in SAS
    • Ways to get data into SAS
  • Getting started with SAS
    • Windowing Environment of SAS
    • A Sample SAS Program
    • Rules for SAS Names
    • SAS Data Sets and SAS Data Types
    • Introduction to SAS Enterprise Guide
    • A Simple Program with Report output
    • More on Comment Statements
    • Data Step compile and execution
  • Reading Raw Data from External Files
    • Reading Data Values Separated by Blanks and Commas
    • Reading Data Values Separated by other Delimiters
    • Placing Data Lines Directly in Your Program
    • Reading Raw Data from Fixed Columns - Column Input method
    • Reading Raw Data from Fixed Columns - Formatted Input method
    • Reading Raw Data Mixed Input method
    • FORMAT Statement in DATA versus PROC Steps
    • INFORMAT Statement with List Input
    • List Input with Embedded Delimiters
  • Using Advanced INPUT Techniques
    • Detecting the End of the File
    • Reading a Portion of a Raw Data File
    • Reading Data from Multiple Files
    • Reading Data from Multiple Files Using a FILENAME Statement
    • Reading External Filenames from a Data File
    • Reading Data Conditionally (the Single Trailing @ Sign)
    • More Examples of the Single Trailing @ Sign
    • Using Relative Column Pointers to Read a Complex Data Structure Efficiently
  • Creating Permanent SAS Data Sets
    • SAS Libraries the LIBNAME Statement
    • Examining the Descriptor Portion of a SAS Data Set
    • Listing All the SAS Data Sets in a SAS Library
    • SAS Data Set as Input to a DATA Step
    • DATA _NULL_: A Data Set That Isn't
  • Creating Formats and Labels
    • Labels to Your Variables
    • Formats to Enhance Your Output
    • Regrouping Values Using Formats
    • Permanent Data Set Attributes
  • Work with SAS/ACCESS & SAS /Connect:
    • To import data from different PC files use import procedure
    • To export data from different source use access procedure
    • To export data from datasets to different PC files use export Procedures
    • Uses of DB Load procedure and how to work
    • How to use Upload Procedure
    • How to use Download Procedure
  • Performing Conditional Processing
    • The IF and ELSE IF Statements
    • The Sub setting IF Statement
    • The IN Operator
    • SELECT Statement for Logical Tests
    • Boolean Logic (AND, OR, and NOT Operators)
    • The WHERE Statement
  • Performing Iterative Processing
    • DO Groups
    • The Sum Statement
    • The Iterative DO Loop
    • Other Forms of an Iterative DO Loop
    • DO WHILE and DO UNTIL Statements
  • Working with Dates
    • How SAS Stores Dates
    • Computing the Number of Years between Two Dates
    • Demonstrating a Date Constant
    • Extracting the Day of the Week, Day of the Month, Month, and Year
    • Creating a SAS Date from Month, Day, and Year Values
    • Interval Functions
  • Sub setting and Combining SAS Data Sets
    • Sub setting a SAS Data Set
    • Creating More Than One Subset Data Set in One DATA Step
    • Adding Observations to a SAS Data Set
    • Interleaving Data Sets
    • Combining Detail and Summary Data
    • Merging Two Data Sets
    • Controlling Observations in a Merged Data Set
    • More Uses for IN= Variables
    • Merging Two Data Sets with Different BY Variable Names
    • Merging Two Data Sets with Different BY Variable Data Types
    • One-to-One, One-to-Many, and Many-to-Many Merges
    • Updating a Master File from a Transaction File
  • Working with Numeric Functions
    • Functions That Round and Truncate Numeric Values
    • Functions That Work with Missing Values
    • Setting Character and Numeric Values to Missing
    • Descriptive Statistics Functions
    • Mathematical Functions
    • Generating Random Numbers
    • Functions That Return Values from Previous
  • Working with Character Functions
    • Determining the Length of a Character Value
    • Changing the Case of Characters
    • Removing Characters from Strings
    • Joining Two or More Strings Together
    • Removing Leading or Trailing Blanks
    • COMPRESS Function to Remove Characters from a String
    • Searching for Characters
    • Searching for Characters
    • Searching for Individual Characters
    • Searching for Words in a String
    • Searching for Character Classes
    • NOT Functions for Data Cleaning
    • Extracting Part of a String
    • Dividing Strings into Words
    • Comparing Strings
    • Performing a Fuzzy Match
    • Substituting Characters or Words
  • Working with Arrays
    • Setting Values of 999 to a SAS Missing Value for Several
    • Numeric Variables
    • Setting Values of NA and? To a Missing Character Value
    • Converting All Character Values to Lowercase
    • Array to Create New Variables
    • Changing the Array Bounds
    • Temporary Arrays
    • Loading the Initial Values of a Temporary Array from a Raw
    • Data File 253
    • Multidimensional Array for Table Lookup
  • Basic Utility Procedures
    • Displaying Your Data by PROC PRINT
    • Organize and sort SAS data sets and working with duplicates by PROC SORT
    • Comparing data sets with PROC COMPARE
    • Using PROC COPY to copy data sets
    • Using PROC DATASETS to modify data set structure, attributes
  • Statistical and Reporting Procedures
    • Producing Statistical with means Procedure
    • To summary statistical Analysis Summary Procedure
    • Testing Categorical Data with FREQ PROCEDURE
    • Creating Customized Reports by PROC REPORT
    • Creating Tabular Reports by PROC TABULATE
    • Examining Data by PROC UNIVARATE
    • And more Statistical Procedures to analyse your Data
  • Introducing the Output Delivery System
    • Sending SAS Output to an HTML File
    • Creating a Table of Contents
    • Selecting a Different HTML Style
    • Choosing Other ODS Destinations
    • Selecting or Excluding Portions of SAS Output
    • Sending Output to a SAS Data Set
  • Generating High-Quality Graphics
    • Producing Simple Bar Charts Using PROC GCHART
    • Creating Pie Charts
    • Creating Bar Charts for a Continuous Variable
    • Creating Charts with Values Representing Categories
    • Creating Bar Charts Representing Means
    • Adding another Variable to the Chart
    • Producing Scatter Plots
    • Connecting Points
  • Module 2: SAS Advanced
  • Using Advanced Features of User-Defined Formats and Informats
    • Using Formats to Recode Variables
    • Using Formats with a PUT Function to Create New Variables
    • Creating User-Defined Informats
    • Reading Character and Numeric Data in One Step
    • Using Formats (and Informats) to Perform Table Lookup
    • Using a SAS Data Set to Create a Format
    • Updating and Maintaining Your Formats
    • Using Multi-label Formats
  • Restructuring SAS Data Sets
    • Conversions of SAS Datasets with DATA step
    • Conversions of SAS Datasets with PROC step
  • Working with Multiple Observations per Subject
    • Identifying the First or Last Observation in a Group
    • Counting the Number of Visits Using PROC FREQ
    • Counting the Number of Visits Using PROC MEANS
    • Computing Differences between Observations
    • Computing Differences between the First and Last Observation with BY Statement
    • Computing Differences between the First and Last Using a RETAIN Statement
    • Using a Retained Variable to 'Remember' a Previous Value
  • SAS Macro Language
    • How the SAS macros Language Works
    • Applying automatic macro variables
    • Assigning Values to Macro Variables by various methods
    • Resolving Macro variables during DATA STEP EXECUTION
    • Designing and implementing simple macros and reduce customizing SAS application
    • Designing and using macros containing parameters within them
    • Techniques for Storing MACROS
  • Structured Query Language
    • Basics of PROC SQL
    • Cartesian Product and Joining concept
    • Joining Two Tables (Merge)
    • Left, Right, and Full Joins
    • Concatenating Data Sets
    • Set Operator us such as union and intersection joining multiple tables
    • Using functions to summarize and group data
    • Ordering data and formatting out
    • Performing group analysis, remerging and sub queries
    • Creating new tables, indexes , views and reports
    • Using Macros in PROC SQL
    • Using Pass Through Facility to communicate databases
  • Debugging SAS Programs:
    • SAS programs that work
    • Fixing Programs that don't work
    • Searching for the missing semicolon
    • Input statement reaching past the end of line
    • Lost card
    • Invalid Data
    • How to handle different kind of SAS errors
    • Missing VALUES were Generated
    • Numeric values have been converted to Character
    • WRONG results but no error message
    • The data step Debugger
    • SAS Truncated a character variable
    • SAS stops in the middle of the job
    • SAS runs out of memory or disk space
  • Practical Sessions with Real time projects
    • Clinical Trial Domain
    • Finance/Banking/Insurance Domain
    • Market Research Domain

Please Register with us