SAS Training in Chennai

SAS Training in Chennai – Content

Introduction to SAS

  • INTRODUCTION
  • NEED FOR SAS
  • WHO USES SAS
  • WHAT IS SAS?
  • OVERVIEW OF BASE SAS SOFTWARE
  • STRUCTURE OF SAS DATASET
  • SAS PROGRAM
  • PROGRAMMING LANGUAGE
  • SPECIAL RULES FOR VARIABLE NAMES
  • TYPES OF VARIABLES
  • TRADITIONAL OUTPUT
  • WAYS TO RUN SAS PROGRAMS
  • SAS WINDOWING ENVIRONMENT
  • RUNNING PROGRAMS IN THE SAS WINDOWING ENVIRONMENT

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
  • COLUMN INPUT
  • 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
  • INFILE OPTIONS FOR SPECIAL SITUATIONS
  • MISSOVER
  • TRUNCOVER
  • 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
  • THE SAS SUPERVISOR AND THE SET STATEMENT
  • EFFICIENCY AND THE SET STATEMENT
  • SET STATEMENT DATA SET OPTIONS
  • DROP AND KEEP OPTIONS
  • RENAME OPTION
  • FIRSTOBS AND OBS OPTIONS
  • IN OPTION
  • WHERE OPTION
  • OTHER SET STATEMENT OPTIONS
  • END OPTION
  • KEY OPTION
  • NOBS OPTION
  • POINT OPTION
  • DO LOOPS AND THE SET STATEMENT
  • INTRODUCTION TO RETAIN STATEMENT
  • ASSIGN INITIAL VALUES
  • DETERMINING COLUMN ORDER IN OUTPUT DATASET
  • SAS SYSTEM OPTIONS
  • 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
  • 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
  • FUNCTIONS THAT SEARCH STRINGS
  • FIND AND FINDC
  • INDEX, INDEXC, AND INDEXW
  • FUNCTIONS TO VERIFY DATA
  • FUNCTION VERIFY
  • FUNCTIONS THAT EXTRACT PARTS OF STRINGS
  • FUNCTION: SUBSTR (ON THE LEFT-HAND SIDE OF THE EQUAL SIGN)
  • FUNCTION: SUBSTRN
  • FUNCTIONS THAT JOIN TWO OR MORE STRINGS TOGETHER
  • FUNCTION: CAT
  • FUNCTION: CATS
  • FUNCTION: CATT
  • FUNCTION: CATX
  • FUNCTIONS THAT REMOVE BLANKS FROM STRINGS

SAS FUNCTIONS contd.,

  • FUNCTION: LEFT
  • FUNCTION: RIGHT
  • FUNCTION: TRIM
  • FUNCTION: TRIMN
  • FUNCTION: STRIP
  • FUNCTIONS THAT COMPARE STRINGS
  • FUNCTION: COMPARE
  • 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
  • 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
  • USING FORMATS FOR DATE AND TIME
  • SYSTEM OPTIONS FORDATE AND TIME

ARRAYS AND ARRAY PROCESSING

  • WHY DO WE NEED ARRAYS?
  • BASIC ARRAY CONCEPTS
  • ARRAY STATEMENT
  • ARRAY REFERENCES
  • VARIABLE NAME ARRAY REFERENCE
  • USING ARRAY INDEXES
  • ONE DIMENSION ARRAYS
  • MULTI-DIMENSION ARRAYS
  • Determining Array Bounds: LBOUND and HBOUND Functions
  • FUNCTION NAME AS AN ARRAY NAME

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 THE DATA STEP IDENTIFIES BY GROUPS
  • PROCESSING OBSERVATIONS IN A BY GROUP
  • 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

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
  • 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
  • ONE-TO-ONE READING
  • DATA STEP PROCESSING DURING A ONE-TO-ONE READING
  • ONE-TO-ONE MERGING
  • MATCH-MERGING
  • UPDATING WITH THE UPDATE AND THE MODIFY STATEMENTS :
  • DEFINITIONS
  • SYNTAX OF THE UPDATE STATEMENT
  • SYNTAX OF THE MODIFY STATEMENT 

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
  • USING PROC PRINT
  • USING PROC SQL
  • PROC REPORT
  • PROCS THAT SUMMARIZE
  • USING PROC CHART
  • USING PROC FREQ
  • USING PROC MEANS
  • USING PROC UNIVARIATE
  • INTRODUCTION TO PROC TABULATE
  • PROC SORT
  • PROC DATASETS
  • PROC FORMAT
  • PROC CONTENTS
  • OTHER IMPORTANT PROCS
  • PROC TRANSPOSE
  • DEFINITIONS
  • PROC PRINTTO
  • COMPARE PROCEDURE
  • PROC APPEND

Advanced SAS

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
  • CALCULATING PERCENTAGE
  • SORTING THE DATA IN PROC SQL
  • SORT ON NEW COLUMN
  • SUBSETTING USING THE WHERE
  • 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

SAS MACROS

  • INTRODUCTION
  • SAS MACRO OVERVIEW
  • THE SAS MACRO LANGUAGE
  • MACRO LANGUAGE COMPONENTS
  • MACRO VARIABLES
  • MACRO STATEMENTS
  • AUTOMATIC MACRO VARIABLES
  • MACRO DEBUGGING OPTIONS
  • DEFINING AND USING MACROS
  • POSITIONAL MACRO PARAMETERS
  • CONDITIONAL MACRO COMPILATION
  • THE %DO STATEMENT

OUTPUT DELIVERY SYSTEM (ODS)

  • INTRODUCTION
  • CREATING VARIOUS TYPES OF REPORTS LISTING OUTPUT
  • OTHER DESTINATIONS
  • HTML
  • PDF AND POSTSCRIPT
  • RTF FILES
  • MICROSOFT EXCEL
  • ADDING STYLE TO YOUR REPORTS

SAS Training in Chennai

Summary
SAS Training in Chennai
Service Type
SAS Training in Chennai
Provider Name
PSP Technologies Private Limited,
#45, South Usman Road,T Nagar,Chennai-600017,
Telephone No.+919841321679
Area
Chennai, India, Online
Description
Advanced Level SAS Training | Trained by industry expert | 100% Placement Assistance