+91 89399 82288
Free enquiry

Plot No.19, Balamurugan Garden, OMR Road, Okkiam, Thoraipakkam, ICICI Bank Upstairs, Opposite to Sangeetha hotel

SAS Training in OMR Chennai

  1. Home
  2. SAS Training in OMR Chennai

Learn SAS Training In Chennai At GREENS TECHNOLOGY – No SAS Training Institute In Chennai. Call @ 89399 25577 For More Details. Register today for learning basic SAS Training to go for advanced 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.

About The Trainer

– As a Trainer, Yuvraj has over 8+ Years Working experience on SQL Server 2005, 2008 R2 and SQL Server 2012 Database Management and Business Intelligence competencies specifically into Marketing, Sales and Infrastructure domains. Holds MCP, MCDBA, MCITP and MCSA Certifications from Microsoft.

Currently working for a Leading MNC in Chennai as BI Consultant and Datawarehouse Archtect. Also involved in Database Consulting services on SQL Server 2014 with Azure for an Infrastructure Client based at Chennai, India.

Being proficient on SQL Server and related technologies in Health, Medicare and Sales-Retail Sector, I love sharing knowledge via Instructor Led LIVE Online / Classroom Trainings and offering training videos. Personally I enjoy answering doubts from the attendees and get involved in brain-storming sessions.

All Trainings are completely practical and real-time, paired with 24 X 7 LIVE Server Access and Real-time databases.

Flexible Timings / Weekend classes Available.

Talk to the Trainer @ +91-8939915577 

SAS Training Course Content

REQUEST A DEMO
COURSE SYLLABUS

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 Greens Technology, 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

Student Testimonials

Top Courses

    Etiam magna arcu, ullamcorper ut pulvinar et, ornare sit amet ligula. Aliquam vitae bibendum lorem. Cras id dui lectus. Pellentesque nec felis tristique urna lacinia sollicitudin ac ac ex. Maecenas mattis faucibus condimentum. Curabitur imperdiet felis at est posuere bibendum. Sed quis nulla tellus.

    ADDRESS

    63739 street lorem ipsum City, Country

    PHONE

    +12 (0) 345 678 9

    EMAIL

    info@company.com

    PURCHASE