SAS

SAS Overview

Online Guru Technologies’s SAS training running with industry experts  according to industry requirements and demands.

This training helps you crack the interview and clear the certification as well.

Here you will get all class videos lifetime access.

Even after completion of course 24/7 support is provided for clearing interviews and certification.

By the end of the course a separate class is scheduled for interview questions and answers.

Online Guru Technologies will provide a platform to work for real time projects.

INTRODUCTION TO SAS

  • INTRODUCTION
  • WHAT IS SAS?
  • OVERVIEW OF BASE SAS SOFTWARE
  • STRUCTURE OF SAS DATASET
  • PROGRAMMING LANGUAGE
  • RULES FOR SAS STATEMENTS
  • TYPES OF VARIABLES
  • DATA ANALYSIS AND REPORTING UTILITIES
  • WAYS TO RUN SAS PROGRAMS
  • SAS WINDOWING ENVIRONMENT
  • RUNNING PROGRAMS IN THE SAS WINDOWING ENVIRONMENT
  • SAS LIBRARIES

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

 READING RAW DATA INTO SAS

  • WHAT IS RAW DATA
  • DEFINITIONS
  • DATA VALUES
  • DATA TYPES
  • STANDARD DATA
  • NONSTANDARD DATA
  •  INPUT METHODS
  • 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
  • USING MORE THAN ONE INPUT STATEMENT: THE SINGLE TRAILING @
  • INFILE OPTIONS FOR SPECIAL SITUATIONS
  • FLOWOVER
  • MISSOVER
  • TRUNCOVER
  • DLM,DSD
  • FIRSTOBS.OBS    

          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
  • WHERE AND IF CONDITIONS
  • SAS STATEMENTS AND DATA SET OPTIONS
  • SAS SYSTEM OPTIONS
  • INTRODUCTION TO RETAIN STATEMENT
  • DIFFERENCE BETWEEN IF AND WHERE

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
  • TYPES OF ERRORS

SAS FUNCTIONS

  • CATEGORIES OF FUNCTIONS
  • SAS CHARACTER FUNCTIONS
  • FUNCTIONS THAT CHANGE THE CASE OF CHARACTERS
  • FUNCTIONS THAT REMOVE CHARACTERS FROM STRINGS
  • FUNCTIONS THAT SEARCH STRINGS
  • FUNCTIONS THAT REMOVE BLANKS FROM STRINGS
  • FUNCTIONS THAT COMPARE STRINGS
  • FUNCTIONS THAT DIVIDE STRINGS INTO “WORDS”
  • FUNCTIONS THAT SUBSTITUTE LETTERS OR WORDS IN STRINGS
  • FUNCTIONS THAT COMPUTE THE LENGTH OF STRINGS

SAS DATE AND TIME FUNCTIONS

  • 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 THAT WORK WITH INTERVALS
  • USING FORMATS FOR DATE AND TIME
  • SYSTEM OPTIONS FORDATE AND TIME

 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 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
  • DATA STEP PROCESSING DURING A ONE-TO-ONE READING
  • ONE-TO-ONE MERGING
  • MATCH-MERGING

INTRODUCTION TO PROC SQL

  • INTRODUCTION
  • WHY LEARN PROC SQL?
  • SELECT STATEMENT
  • THE SELECT STATEMENT SYNTAX
  • A SIMPLE PROC SQL
  • A COMPLEX PROC SQL
  • CREATING NEW VARIABLES
  • THE CALCULATED OPTION ON THE SELECT
  • USING LABELS AND FORMATS
  • THE CASE EXPRESSION ON THE SELECT
  • ADDITIONAL SELECT STATEMENT CLAUSES
  • CALCULATING TOTALS AND PERCENTAGE
  • SORTING THE DATA IN PROC SQL
  • SUBSETTING USING THE WHERE
  • 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 PROCEDURES

  • INTRODUCTION
  • 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
  • USING PROC SQL
  • PROC REPORT
  • PROCS THAT SUMMARIZE
  • USING PROC FREQ
  • USING PROC MEANS
  • INTRODUCTION TO PROC TABULATE
  • DATA MANIPULATION AND MANAGEMENT PROCEDURE
  • PROC SORT
  • PROC DATASETS
  • PROC FORMAT
  • PROC CONTENTS
  • OTHER IMPORTANT PROCS
  • PROC TRANSPOSE
  • COMPARE PROCEDURE
  • PROC APPEND
  • HOW TO IMPORT AN EXCEL FILE INTO SAS

THE OUTPUT DELIVERY SYSTEM (ODS)

      SAS MACROS

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

Online Guru Technologies conducting SAS demo Classes with Industry experts for clarifying doubts and knowing about course, for attending free demo session Click on the “Schedule Free Demo Session” and Fill the form. Our representative will call you back and they will fix demo session timings according to your convent timings

The Demo sessions are conducting every day 1 Hour Session, the demo session conducting by real-time working professionals.

Call us on +91 - 9886508358

Training class hours – 45


All classes recorded videos


Lifetime access videos


Project classes hours – 10


Everyday support

Related Courses

SAS DEMO SESSIONS

7:00 AM-10:00AM - MON TO FRI


7:00 AM-10:00AM - SAT & SUN


CONTACT US


×
WhatsApp chat