Banner Image

SAS

About this course

Everybody is talking about the highest and fanciest capabilities of Analytics, but where does it start – SAS Programming. Any fresher and mid-level career professional has to start with SAS Programming to grow in Analytics industry.
This course will take you through all SAS Programming procedures and then you would be introduced to use Macros and SQL on SAS Programming interface.

All programming procedures are presented in an easy to understand manner, using actual coding examples and demos to clarify the concepts and present the actual method of implementation.

Eligibility

  • Developers who have experience and proficiency in Java, C++, C# or Ruby
  • Scala programmers with minimal experience looking for a refresher course
  • Managers who want to gain into the insights of functional programming

What you’ll learn

  • Basic & Advanced Scala Programming
  • Design, implementation, documentation, and testing skills
  • Django – web applications, databases and debugging.
  • This Scala Training Course Comes with Certification of Completion

Syllabus

INTRODUCTION TO SAS

  • INTRODUCTION
  • NEED FOR SAS
  • WHO USES SAS
  • WHAT IS SAS?
  • OVERVIEW OF BASE SAS SOFTWARE
  • DATA MANAGEMENT FACILITY
  • STRUCTURE OF SAS DATASET
  • SAS PROGRAM
  • PROGRAMMING LANGUAGE
  • ELEMENTS OF THE SAS LANGUAGE
  • RULES FOR SAS STATEMENTS
  • RULES FOR MOST SAS NAMES
  • SPECIAL RULES FOR VARIABLE NAMES
  • TYPES OF VARIABLES
  • DATA ANALYSIS AND REPORTING UTILITIES
  • TRADITIONAL OUTPUT
  • WAYS TO RUN SAS PROGRAMS
  • SAS WINDOWING ENVIRONMENT

Basic Concepts

  • Introduction
  • Objectives
  • SAS Programs
  • Components of SAS Programs
  • Characteristics of SAS Programs
  • Layout for SAS Programs
  • Processing SAS Programs
  • Log Messages
  • Results of Processing
  • SAS Libraries
  • How SAS Files Are Stored
  • Storing Files Temporarily or Permanently
  • Referencing SAS Files
  • Two-Level Names
  • Referencing Temporary SAS Files
  • Referencing Permanent SAS Files
  • Rules for SAS Names
  • SAS Data Sets
  • Overview of Data Sets
  • Descriptor Portion
  • Data Portion
  • Observations (Rows)
  • Variable Attributes
  • Name
  • Type
  • Length
  • Format
  • Informat
  • Label
  • Variables (Columns)
  • Missing Values

HOW SAS WORKS

  • WRITING YOUR FIRST SAS PROGRAM
  • A SIMPLE PROGRAM TO READ RAW DATA AND PRODUCE A REPORT
  • ENHANCING THE PROGRAM
  • MORE ON COMMENT STATEMENTS
  • INTERNAL PROCESSING IN SAS
  • HOW SAS WORKS
  • THE COMPILATION PHASE
  • THE EXECUTION PHASE
  • PROCESSING A DATA STEP: A WALKTHROUGH
  • CREATING THE INPUT BUFFER AND THE PROGRAM DATA VECTOR
  • WRITING AN OBSERVATION TO THE SAS DATA SET
  • FOUR TYPES OF SAS LIBRARIES
  • SAS LIBRARIES
  • WORK LIBRARY
  • SASHELP LIBRARY
  • SASUSER LIBRARY

READING RAW DATA INTO SAS

  • WHAT IS RAW DATA
  • DEFINITIONS
  • DATA VALUES
  • NUMERIC VALUE
  • CHARACTER VALUE
  • STANDARD DATA
  • NONSTANDARD DATA
  • NUMERIC DATA
  • CHARACTER DATA
  • CHOOSING AN INPUT STYLE
  • LIST INPUT
  • MODIFIED LIST INPUT
  • COLUMN INPUT
  • FORMATTED INPUT
  • NAMED INPUT
  • CREATING MULTIPLE RECORDS FROM SINGLE INPUT ROW
  • READING DATA FROM EXTERNAL FILES
  • READING BLANK SEPARATED VALUES (LIST OR FREE FORM DATA):
  • READING RAW DATA SEPARATED BY COMMAS (.CSV FILES):
  • READING IN RAW DATA SEPARATED BY TABS (.TXT FILES):
  • USING INFORMATS WITH LIST INPUT
  • SUPPLYING AN INFORMAT STATEMENT WITH LIST INPUT
  • USING LIST INPUT WITH EMBEDDED DELIMITERS
  • READING RAW DATA THAT ARE ALIGNED IN COLUMNS:
  • METHOD 1: COLUMN INPUT
  • METHOD 2: FORMATTED INPUT
  • USING MORE THAN ONE INPUT STATEMENT: THE SINGLE TRAILING @
  • READING COLUMN DATA THAT IS ON MORE THAN ONE LINE
  • MIXED-STYLE INPUT:
  • FLOWOVER
  • MISSOVER
  • TRUNCOVER
  • PAD
  • USING LRECL TO READ VERY LONG LINES OF RAW DATA
  • CHECKING YOUR DATA AFTER IT HAS BEEN READ INTO SAS

READING DATA FROM A DATASET

  • INTRODUCTION
  • SET STATEMENT OVERVIEW
  • AUTOMATIC VARIABLES IN SAS
  • INTERLEAVE MULTIPLE SAS DATA SETS
  • COMBINE MULTIPLE SAS DATA SETS
  • CREATING & MODIFYING VARIABLES
  • CREATING MULTIPLE DATASETS IN A SINGLE DATA-STEP
  • SUBSETTING OBSERVATIONS
  • CONDITIONAL SAS STATEMENTS
  • LOGICAL AND SPECIAL OPERATORS
  • SET STATEMENT DATA SET OPTIONS
  • DROP AND KEEP OPTIONS
  • RENAME OPTION
  • FIRSTOBS AND OBS OPTIONS
  • IN OPTION –
  • WHERE OPTION –
  • OTHER SET STATEMENT OPTIONS
  • NOBS OPTION
  • POINT OPTION
  • INTRODUCTION TO RETAIN STATEMENT
  • DETERMINING COLUMN ORDER IN OUTPUT DATASET
  • SAS SYSTEM OPTIONS

READING DATA FROM A DATASET

  • INPUT SAS DATA SET FOR EXAMPLE
  • SELECTING OBSERVATIONS FOR A NEW SAS DATA SET
  • DELETING OBSERVATIONS BASED ON A CONDITION
  • ACCEPTING OBSERVATIONS BASED ON A CONDITION
  • COMPARING THE DELETE AND SUBSETTING IF STATEMENTS
  • METHODS OF CREATING NEW DATA SETS WITH A SUBSET
  • SUBSETTING RECORDS FROM AN EXTERNAL FILE WITH A SUBSETTING IF STATEMENT
  • SUBSETTING OBSERVATIONS IN A DATA STEP WITH A WHERE STATEMENT
  • SUBSETTING OBSERVATIONS IN A PROC STEP WITH A WHERE STATEMENT
  • SUBSETTING OBSERVATIONS IN PROC SQL
  • DIFFERENCE BETWEEN IF AND WHERE

SAS INFORMATS AND FORMATS

  • OVERVIEW
  • USING SAS INFORMATS
  • INPUT STATEMENT
  • INPUT FUNCTION
  • INPUTN AND INPUTC FUNCTIONS
  • ATTRIB AND INFORMAT STATEMENTS
  • USING SAS FORMATS
  • FORMAT STATEMENT IN PROCEDURES
  • PUT STATEMENT
  • PUT FUNCTION
  • PUTN AND PUTC FUNCTIONS
  • BESTw. Format
  • ADDITIONAL COMMENTS

SAS FUNCTIONS

  • CATEGORIES OF FUNCTIONS
  • SAS CHARACTER FUNCTIONS
  • FUNCTIONS THAT CHANGE THE CASE OF CHARACTERS
  • UPCASE
  • LOWCASE
  • PROPCASE
  • FUNCTIONS THAT REMOVE CHARACTERS FROM STRINGS
  • FUNCTION: COMPBL
  • FUNCTION: COMPRESS
  • FUNCTIONS THAT SEARCH FOR CHARACTERS
  • FUNCTION: ANYALNUM
  • FUNCTION: ANYALPHA
  • FUNCTION: ANYDIGIT
  • FUNCTION: ANYPUNCT
  • FUNCTION: ANYSPACE
  • FUNCTION: NOTALNUM
  • FUNCTION: NOTALPHA
  • FUNCTION: NOTDIGIT
  • FUNCTION: NOTUPPER
  • FUNCTIONS THAT SEARCH STRINGS
  • FIND AND FINDC
  • INDEX, INDEXC, AND INDEXW
  • FUNCTIONS TO VERIFY DATA
  • FUNCTION VERIFY
  • FUNCTIONS THAT EXTRACT PARTS OF STRINGS
  • FUNCTION: SUBSTRN
  • FUNCTIONS THAT JOIN TWO OR MORE STRINGS TOGETHER
  • FUNCTION: CAT
  • FUNCTION: CATS
  • FUNCTION: CATT
  • FUNCTION: CATX
  • FUNCTIONS THAT REMOVE BLANKS FROM STRINGS
  • FUNCTION: LEFT
  • FUNCTION: RIGHT
  • FUNCTION: TRIM
  • FUNCTION: TRIMN
  • FUNCTION: STRIP
  • FUNCTIONS THAT COMPARE STRINGS
  • FUNCTIONS THAT DIVIDE STRINGS INTO “WORDS”
  • FUNCTION: SCAN
  • FUNCTION: SCANQ
  • FUNCTIONS THAT SUBSTITUTE LETTERS OR WORDS IN STRINGS
  • FUNCTION: TRANSLATE
  • FUNCTION: TRANWRD
  • FUNCTION: LENGTH
  • FUNCTION: LENGTHC
  • FUNCTION: LENGTHM
  • FUNCTION: LENGTHN
  • FUNCTIONS THAT COUNT THE NUMBER OF LETTERS OR SUBSTRINGS IN A STRING
  • FUNCTION: COUNT
  • FUNCTION: COUNTC
  • MISCELLANEOUS STRING FUNCTIONS
  • FUNCTION: MISSING
  • FUNCTION: REPEAT
  • FUNCTION: REVERSE
  • SAS DATE AND TIME FUNCTIONS
  • INTRODUCTION
  • WHAT IS A SAS DATE AND TIME LITERAL?
  • DATE AND TIME FUNCTIONS
  • FUNCTINS TO CREATE DATE AND TIME VALUES
  • FUNCTIONS TO TAKIE DATETIME VALUES APART
  • FUNCTIONS TO GET QUARTER ,YEAR OR DAY OF THE DATE
  • FUNCTIONS THAT WORK WITH INTERVALS
  • USING FORMATS FOR DATE AND TIME
  • SYSTEM OPTIONS FORDATE AND TIME

BY – GROUP PROCESSING

  • DEFINITIONS FOR BY-GROUP PROCESSING
  • BY-GROUP PROCESSING
  • BY VALUE
  • BY GROUP
  • FIRST.VARIABLE AND LAST.VARIABLE
  • MODIFYING SAS DATA SETS: EXAMPLES.
  • PREPROCESSING INPUT DATA FOR BY-GROUP PROCESSING
  • SORTING OBSERVATIONS FOR BY-GROUP PROCESSING
  • HOW SAS DETERMINES FIRST.VARIABLE AND LAST.VARIABLE
  • PROCESSING BY-GROUPS IN THE DATA STEP
  • OVERVIEW
  • PROCESSING BY-GROUPS CONDITIONALLY
  • DATA NOT IN ALPHABETIC OR NUMERIC ORDER

OVERVIEW OF METHODS FOR COMBINING SAS DATA SETS

  • DEFINITIONS
  • CONCATENATING
  • INTERLEAVING
  • ONE-TO- ONE READING OR ONE-TO-ONE MERGING
  • MATCH-MERGING
  • UPDATING
  • MODIFYING
  • DEFINITIONS FOR READING, COMBINING, AND MODIFYING SAS DATA SETS
  • READING A SAS DATA SET
  • COMBINING SAS DATA SETS
  • MODIFYING SAS DATA SETS
  • OVERVIEW OF TOOLS
  • READING SAS DATA SETS
  • READING A SINGLE SAS DATA SET
  • READING FROM MULTIPLE SAS DATA SETS
  • COMBINING SAS DATA SETS: BASIC CONCEPTS
  • ONE-TO-ONE
  • ONE-TO-MANY AND MANY-TO-ONE
  • MANY-TO-MANY

SAS PROCEDURES

  • INTRODUCTION
  • THE ANATOMY OF A PROC
  • THE PROC STATEMENT
  • TITLE AND FOOTNOTE STATEMENTS
  • BY STATEMENT
  • LABEL STATEMENT
  • FORMAT STATEMENT
  • RUN OR QUIT STATEMENT
  • DESCRIPTION OF DATA USED IN REPORTS
  • SAS REPORTING PROCEDURES
  • PROCS FOR ALL THAT DETAIL
  • USING PROC PRINT
  • PROC REPORT
  • PROCS THAT SUMMARIZE
  • USING PROC FREQ
  • USING PROC MEANS
  • USING PROC UNIVARIATE
  • INTRODUCTION TO PROC TABULATE
  • DATA MANIPULATION AND MANAGEMENT PROCEDURE
  • PROC SORT
  • PROC DATASETS
  • PROC FORMAT
  • PROC CONTENTS
  • OTHER IMPORTANT PROCS
  • PROC TRANSPOSE
  • DEFINITIONS
  • COMPARE PROCEDURE
  • PROC APPEND
  • HOW TO IMPORT AN EXCEL FILE INTO SAS

INTRODUCTION TO PROC SQL

  • INTRODUCTION
  • WHY LEARN PROC SQL?
  • SELECT STATEMENT
  • THE SELECT STATEMENT SYNTAX
  • A SIMPLE PROC SQL
  • A COMPLEX PROC SQL
  • LIMITING INFORMATION ON THE SELECT
  • CREATING NEW VARIABLES
  • THE CALCULATED OPTION ON THE SELECT
  • USING LABELS AND FORMATS
  • THE CASE EXPRESSION ON THE SELECT
  • ADDITIONAL SELECT STATEMENT CLAUSES
  • REMERGING
  • REMERGING FOR TOTALS
  • CALCULATING PERCENTAGE
  • SORTING THE DATA IN PROC SQL
  • SORT ON NEW COLUMN
  • SUBSETTING USING THE WHERE
  • INCORRECT WHERE CLAUSE
  • WHERE ON COMPUTED COLUMN
  • SELECTION ON GROUP COLUMN
  • USE HAVING CLAUSE
  • CREATING NEW TABLES
  • JOINING DATASETS USING PROC SQL
  • INNER JOIN
  • JOINING THREE OR MORE TABLES
  • OUTER JOINS
  • INCLUDING NONMATCHING ROWS WITH THE RIGHT OUTER JOIN
  • SELECTING ALL ROWS WITH THE FULL OUTER JOIN
  • CONCATENATING QUERY RESULTS

AN INTRODUCTION TO SAS MACROS

  • INTRODUCTION
  • SAS MACRO OVERVIEW
  • TRADITIONAL SAS PROGRAMMING
  • THE SAS MACRO LANGUAGE
  • MACRO LANGUAGE COMPONENTS
  • MACRO VARIABLES
  • MACRO STATEMENTS
  • MACRO PROCESSOR FLOW
  • AUTOMATIC MACRO VARIABLES
  • MACRO DEBUGGING OPTIONS
  • WHAT IS A MACRO?
  • DEFINING AND USING MACROS
  • POSITIONAL MACRO PARAMETERS
  • KEYWORD MACRO PARAMETERS
  • CONDITIONAL MACRO COMPILATION
  • THE %DO STATEMENT
  • SAS DATA STEP INTERFACES

INTRODUCTION TO DIAGNOSING AND AVOIDING ERRORS

  • INTRODUCTION
  • UNDERSTANDING HOW THE SAS SUPERVISOR CHECKS A JOB
  • UNDERSTANDING HOW SAS PROCESSES ERRORS
  • DISTINGUISHING TYPES OF ERRORS .SAS RECOGNIZES FOUR KINDS OF ERRORS:
  • SYNTAX ERRORS
  • EXECUTION-TIME ERRORS

ADVANCE TOPICS IN SAS

  • PERFORMING ADVANCED QUERIES USING PROC SQL
  • INTRODUCING MACRO VARIABLES
  • CREATING AND USING MACRO PROGRAMS
  • INTRODUCTION TO SAS GRAPH

Get Ready For Interview:

  • Where to go from here
  • SAS certification
  • Prepare your Resume
  • Demo Interview call

Syllabus

Benefits

  • Freshers acquire most sought software development skills required in the market
  • Developers gain knowledge and skills to confidently program in Python
  • Certified Trainers share coding insights that lead to high-quality coding

After completing this course, you’ll be able to

  • Outline what SAS Programming is and how can you help implement it
  • Explain the different methods used to combine and modify datasets
  • Explain what PROC SQL is and how it is used to retrieve data from single and multiple tables.
  • Describe how to use macro function to manipulate the character strings and text.
  • Understand how SAS handles missing values in your datasets using various procedures.
  • Illustrate the problems involved in optimization.

Meet the instructor

Manoj Kumar

Professor, Computer Science and Engineering


Course Reviews

Contact Us