SAS Training In Chennai

Build a strong SAS programming foundation to manipulate your data, perform complex queries and simple analyses, and generate reports.

Gain the knowledge needed to become certified as a Base SAS programmer or Advanced SAS programmer.

BASE SAS

No prior SAS experience is needed . Before attending this course, you should have experience using computer software. Specifically, you should be able to understand file structures and system commands on your operating systems access data files on your operating systems.

ESSENTIALS

PRE REQUISITES

This course is for users who want to learn how to write SAS programs. It is the entry point to learning SAS programming and is a prerequisite to many other SAS courses.

LEARN HOW TO

  • Navigate the SAS windowing environment
  • Combine SAS data sets
  • Create and enhance listing and summary reports
  • Navigate the SAS Enterprise Guide programming environment
  • Create SAS variables and subset data
  • Read various types of data into SAS data sets
  • Validate SAS data sets.

COURSE OUTLINE

INTRODUCTION

  • An overview of SAS foundation
  • Course data files
  • Course logistics

SAS COURSE DURATION AND TIMING

  • We also offer fast track classes to meet your busy schedule
  • At Automation Minds, we offer weekday and weekend classes for your convenience

SAS PROGRAMS

  • Introduction to SAS programs
  • Working with SAS program syntax
  • Submitting a SAS program

ACCESSING DATA

  • Accessing SAS libraries
  • Examining SAS data sets

PRODUCING DETAIL REPORTS

  • Enhancing reports
  • Submitting report data
  • Sorting and grouping report data

FORMATTING DATA VALUES

  • Creating user-defined formats
  • Using SAS formats

READING SAS DATA SETS

  • Customizing a SAS data set
  • Reading a SAS data set

READING SPREADSHEET AND DATABASE DATA

  • Introduction to SAS programs
  • Working with SAS program syntax
  • Submitting a SAS program

READING RAW DATA FILES

  • Introduction to reading raw data files
  • Reading nonstandard delimited data
  • Handling missing data
  • Reading standard delimited data

MANIPULATING DATA

  • Conditional processing
  • Using SAS functions

COMBINING SAS DATA SETS

  • Merging data sets one-to-many
  • Concatenating data sets
  • Merging data sets with nonmatches
  • Merging data sets one-to-one

CREATING SUMMARY REPORTS

  • Using the FREQ procedure
  • Using the Output Delivery System
  • Using the MEANS and UNIVARIATE procedures

DATA MANIPULATION TECHNIQUES

LEARN HOW TO

  • Control SAS data set input and output
  • Perform DO loop and SAS array processing
  • Summarize, read, and write different types of data
  • Combine SAS data sets
  • Transform character, numeric, and date variables.

COURSE OUTLINE :

INTRODUCTION

  • An overview of SAS Foundation
  • Course logistics
  • Combine SAS data sets
  • Course data files

CONTROLLING INPUT AND OUTPUT

  • Selecting variables and observations
  • Writing observations explicitly
  • Writing to multiple SAS data sets

SUMMARIZING DATA

  • Accumulating totals for a group of data
  • Creating an accumulating total variable

READING RAW DATA FILES

  • Controlling when a record loads
  • Reading raw data files with formatted input

DATA TRANSFORMATIONS

  • Manipulating character values
  • Converting variable type
  • Manipulating numeric values

DEBUGGING TECHNIQUES

  • Using the PUTLOG statement

PROCESSING DATA ITERATIVELY

  • DO loop processing
  • Conditional DO loop processing
  • Using SAS arrays
  • SAS array processing

RESTRUCTURING A DATA SET

  • Rotating with the DATA step

COMBINING SAS DATA SETS

  • Using data manipulation techniques with match-merging

CREATING AND MAINTAINING PERMANENT FORMATS

  • Creating permanent formats

OTHER SAS LANGUAGES

  • An overview of other languages
  • The SAS macro language
  • Using the SQL procedure

ADVANCE SAS CERTIFICATION

WHO SHOULD ATTEND

Experienced SAS programmers who have a sound understanding of DATA step processing and who want to write SAS programs that are reusable and dynamic

ESSENTIALS

This course focuses on the components of the SAS macro facility and how to design, write, and debug macro systems. Emphasis is placed on understanding how programs with macro code are processed.

LEARN HOW TO

  • Automate and customize the production of SAS code
  • Perform text substitution in SAS code
  • Use macro variables and macro functions.
  • Conditionally or iteratively construct SAS code

COURSE OUTLINE :

INTRODUCTION

  • Course logistics
  • Course data files
  • Overview of SAS Foundation
  • Purpose of the macro facility
  • program flow

MACRO VARIABLES

  • Macro variable references
  • User-defined macro variables
  • Introduction to macro variables
  • Macro functions
  • Automatic macro variables
  • Delimiting macro variable references

MACRO DEFINITIONS

  • Macro parameters
  • Defining and calling a macro

MACRO PROGRAMS

  • Conditional processing
  • Parameter validation
  • Global and local symbol tables
  • Iterative processing

ADVANCED TECHNIQUES AND EFFICIENCIES

This course is for SAS programmers who prepare data for analysis. The comparisons of manipulation techniques and resource cost benefits are designed to help programmers choose the most appropriate technique for their data situation.

LEARN HOW TO

compare various SAS programming techniques that enable you to

  • compress SAS data sets
  • Benchmark computer resource usage
  • Control memory, I/O, and CPU resources
  • Create and use indexes
  • Sample your SAS data sets
  • Combine data horizontally
  • Use hash and hiter DATA step component objects and arrays as lookup tables
  • Create user-defined functions and informats
  • Create and use SAS data views
  • Safely reduce the length of numeric variables

COURSE OUTLINE :

INTRODUCTION

  • Overview of SAS Foundation
  • Creating the course data
  • Course logistics

EFFICIENT SAS PROGRAMMING

  • Identifying computer resources related to efficiency

CONTROLLING I/O PROCESSING AND MEMORY

  • SAS DATA step processing
  • Compressing SAS data sets
  • Controlling I/O
  • Using SAS views
  • Reducing the length of numeric variables

ACCESSING OBSERVATIONS

  • Access methods
  • Creating an index
  • Accessing observations by number
  • Using an index

DATA STEP ARRAYS

  • Introduction to lookup techniques
  • One-dimensional arrays
  • Multidimensional arrays
  • Loading a multidimensional array from a SAS data set

DATA STEP HASH AND HITER OBJECTS

  • Introduction
  • hash object methods
  • DATA step hiter object
  • Loading a hash object from a SAS data set

COMBINING DATA HORIZONTALLY

  • Combining summary and detail data
  • DATA step merges and SQL procedure joins
  • Combining data conditionally
  • Using an index to combine data

USER-DEFINED FUNCTIONS AND FORMATS

  • User-defined formats
  • User-defined functions
© 2018 Automation Minds. All rights reserved..