SAS Training Course

SAS is abbreviated as “Statistical Analysis System” which was developed for advanced analytics, multivariate analyses, business intelligence, data management and predictive analytics.

SAS is consistently performing the best in its Quality, Services, Growth and delivering the breakthrough technology. SAS provides one integrated process for analyzing data from every source and gaining the predictive power to drive change at every level.

SAS is a tool used in more than 100 countries and is used in several domains like Market Research / Financial analyst / Business analyst / Clinical / Pharmacy / Banking / Insurance and Data Warehousing etc…

Pre-Requisites for SAS Training Course in Hyderabad

SAS training Course in Hyderabad offered by many institutes. As SAS is a basic foundation course for getting ready for the industrial competition in the Information technology, minimum degree qualification is needed to get eligible to learn the course. Graduate or post graduate having some basic strength in mathematics is preferable. And other academic courses like B.A, B.Com, M.Com, MBA, MCA and all the graduate and post-graduate degrees of pharma and life sciences.

SAS Training Course Syllabus

Introduction to SAS

  • Advantages of using SAS
  • Major components of SAS suite
  • SAS windows

Accessing Data in SAS

  • Use COLUMN, FORMATTED and LIST input to read raw data files.
  • Use INFILE statement options to control processing when reading raw data files.
  • Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing at controls.
  • SAS libraries: Creating temporary and permanant libraries
  • Options to read raw data: Missover, Truncover, Stopover, Flowover, DSD, DLM

Behind the scene

  • SAS DATA Step Processing – Compilation Phase and Execution Phase
  • Program Data Vector (PDV)
  • SAS dataset: data and descriptor portions
  • Understanding how SAS files are stored

SAS statements

  • Differences between system options, data set options and statement options
  • Informats, Formats, Attrib, Datalines, Delete, Drop, Keep, Label, Length, Retain, Sum, Dim

SAS Options

  • Data set options: KEEP, DROP, RENAME, FIRSTOBS, OBS, IN, LABEL, WHERE
  • SAS System Options – OBS, FIRSTOBS, BUFNO, BUFSIZE, LINESIZE, PAGESIZE, NODATE, YEARCUTOFF

SAS Functions

  • INPUT and PUT
  • Functions for Date and Time – MONTH, YEAR, DAY, MDY, DATE, TODAY, DATETIME
  • Other SAS functions – SCAN, SUBSTR, TRIM, LEFT, RIGHT, INDEX, UPCASE, LOWCASE, MEAN, COMPRESS, LENGTH

Arrays

  • Creating variables using Arrays
  • Assigning Initial Values to Arrays
  • Multidimensional Array

Conditional Processing

  • Subsetting IF
  • IF-THEN/ELSE statement
  • DO statement
  • Nesting of the DO Loop
  • DO UNTIL statement
  • DO WHILE statement

Connecting to outside world

  • FTP thru SAS
  • Connect to different servers (SQL server etc)
  • Export data to create standard and comma-delimited raw data files

Merging & Appending Data

  • SET and MERGE Statements
  • MODIFY and UPDATE Statements
  • WHERE Statement and differences with IF
  • RETAIN and RETURN Statements

Analysis and report generation: SAS Procedures

  • Proc Print, Proc Sort, Proc Means and Proc Contents
  • Enhance reports through the use of user-defined formats, titles, footnotes

SAS Macros

  • Storing SAS Macros
  • Defining and Calling Macros
  • Referencing Macro Variables
  • Macro Parameters
  • Macro Quoting Technique
  • Macro Debugging Technique

Error Handling

  • Identify and resolve programming logic errors
  • Recognize and correct syntax errors

SAS Training Course in Hyderabad