Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
course

SAS Base & Advanced

SAS is a software suite that can mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis on it. SAS provides a graphical point-and-click user interface for non-technical users and more advanced options through the SAS language.
Course: 6 Weeks

Certificate

Course Syllabus

Module 1:  BASIC THEORY & RULES ETC

  • SAS WINDOWING ENVIRONMENT
  • CREATION OF LIBRARIES
  • SAS PROGRAMMING (BRIEFLY) – DATASTEP – PROC STEP
  • WAYS TO READ DATA INTO SAS
  • BACK END PROCESS OF DATASTEP
  • INSTALLATION PROCESS

Module 2: DATASTEP

  • DATA STATEMENT & DATASET OPTIONS
  • INFILE STATEMENT & OPTIONS
  • INPUT STATEMENT &STYLES & OPTIONS
  • DATALINES STATEMENT

Module 3: ATTRIBUTES OF THE VARIABLES

  • LENGTH, LABEL STATEMENTS
  • INFORMATS & FORMATS
  • HOW DATES WORKS IN SAS
  • OTHER STATEMENTS

Module 4: CONDITIONAL STATEMENTS & LOOPS

  • IF, IF/THEN, IF/THEN/ELSE,IF/THEN OUTPUT, IF/THEN DELETE STATEMENTS
  • WHERE STATEMENT& OPERATORS
  • DO, DO ITERATIVE, DO UNTIL & DO WHILE STATEMENTS

Module 5: ARRAYS

  • Creation of Array Element
  • Usage of Array

Module 6: COMBINING DATASETS

  • CONCATENATION
  • INTEREAVING
  • One to One Reading
  • One to One Merging
  • Match Merging

Module 7: FUNCTIONS

  • CHARACTER FUNCTIONS
  • NUMERIC FUNCTIONS
  • DATA TYPE CONVERSATION FUNCTIONS

Module 8: PROCEDURES

  • PROC CONTENTS
  • PROC COPY
  • PROC DELETE
  • PROC APPEND
  • PROC SORT
  • PROC DATASETS
  • PROC COMPARE
  • PROC TRANSPOSE
  • PROC FORMAT
  • PROC IMPORT
  • PROC EXPORT
  • PROC TEMPLATE

Module 8: SAS/ACCESS

  • SQL PASS THRU QUERY (PROC SQL)
  • LIBNAME STATEMENT
  • REVIEW OF ACCESS PROCEDURES

Module 9: REPORTING PROCEDURES

  • PROC PRINT
  • PROC TABULATE
  • PROC REPORT
  • _NULL_ REPORT (Data step Reporting)
  • REVIEW OF REPORTING PROCEDURES

Module 10: SAS/STAT

  • BASIC FUNCTIONAL CLASSES OF STATISTICS
  • STATISTICAL PROCEDURES
  • PROC MEANS
  • PROC SUMMARY
  • PROC UNIVARIATE
  • PROC FREQ
  • REVIEW OF STATS PROCEDURES

Module 11: SAS/MACROS

  • INTRODUCTION TO THE MACRO FACILITY
  • PURPOSE OF THE MACRO FACILITY
  • PROGRAM FLOW
  • MACRO VARIABLES
  • INTRODUCTION TO MACRO VARIABLES
  • MACRO FUNCTIONS
  • DEFINING AND CALLING A MACRO
  • MACRO PARAMETERS
  • CREATING MACRO VARIABLES IN THE DATA STEP
  • CREATING MACRO VARIABLES IN SQL
  • MACRO PROGRAMS
  • CONDITIONAL PROCESSING
  • PARAMETER VALIDATION
  • ITERATIVE PROCESSING
  • DEBUGGING AND TROUBLESHOOTING
  • CREATING EFFICIENT MACROS
  • REVIEW OF MACROS
  • PERFORMANANCE TUNING CONCEPTS
  • TESTING/DEBUGGING TECHNIQUES
  • ERROR HANDLING

Module 12: SAS SQL

  • INTRODUCTION TO THE SQL PROCEDURE
  • WHAT IS SQL?
  • WHAT IS THE SQL PROCEDURE?
  • TERMINOLOGY
  • COMPARING PROC SQL WITH THE SAS DATA STEP
  • WHEN TO USE JOINS AND SUBQUERIES
  • COMBINING QUERIES WITH SET OPERATORS
  • CREATING AND UPDATING TABLES AND VIEWS
  • PROGRAMMING WITH THE SQL PROCEDURE
  • PRACTICAL PROBLEM-SOLVING WITH PROC SQL

There are no reviews yet. Be the first one to write one.

Book a Demo