SAS Foundation & Advanced Course

It is the largest market-share holder for advanced analytics.

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.

What you will learn

SAS advanced analytics, combined with industry- or task-specific expertise, is the foundation for many horizontal or vertical analytics applications. These include solutions for risk management, anti-fraud, customer intelligence, retail and other domain-specific offerings.

  • Introduction to SAS
  • Reading Raw Data from External Files

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
  • To transport datasets one environment to another environment and one version to another version to another version (windows to UNIX) use with cprot and cimport procedures
  • 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 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
Back to top