+91 989 971 4317

SAS Training

Online Sas Training

Learn Through Case Studies and Get a Project Completion Certificate.

Best SAS Training Institute
Base SAS Training

Base SAS Training

SAS is driven by SAS programs, which define a sequence of operations to be performed on data stored as tables. Although non-programmer graphical user interfaces to SAS exist (such as the SAS Enterprise Guide), these GUIs are most often merely a front-end that automates or facilitates the generation of SAS programs. The functionalities of SAS components are intended to be accessed via application programming interfaces, in the form of statements and procedures

More

SAS has many business solutions that enable large-scale software solutions for areas such as IT management, human resource management, financial management, business intelligence, customer relationship
management and more.

Introduction to SAS Programming
Working in the SAS Environment
Introduction Working with the windows
  • • Program editor window
  • • Log window
  • • Output window
  • • Result window
  • • Explorer window
Overview of libraries
  • • Datasets
  • • Data view
  • • Catalog
  • • Referencing Files in SAS Libraries
Basic concepts
  • • Creating a SAS Programs
  • • Components of SAS Programs
  • • Characteristics of SAS Programs
  • • Layout of SAS Programs
Methods for getting data into SAS
  • • Methods for getting data into SAS can be put into four general categories:
  • • Entering data directly into SAS data sets
  • • Creating SAS data sets from raw data files
  • • Converting other software’s data files into SAS data sets
  • • Reading other software’s data file directly
Input Styles
  • •List input
  • • Column input
  • • Formatted input
  • • Modified/Mixing input
  • • Reading Messy Raw Data
  • • Reading Multiple lines of Raw Data per observation
  • • Reading Multiple observations per line of raw data
  • • Reading delimited file with DATA step
Assigning Variable Attributes
  • • Permanent Attributes
  • • Temporary Variable Attributes
Pointers
  • • Column pointers
  • • Line Pointers
Informats and Formats
  • • Informats
  • • Character informats
  • • Numeric informats
  • • Date and time informats
Formats
  • • Character formats
  • • Numeric formats
  • • Date and time formats
Functions
  • • Arithmetic Functions
  • • String Functions
  • • Date and Time Functions
Reading Raw Data from External File
  • • Infile statement
  • • Import
  • • Export
Options
  • • Global options
  • • Local Options
Statements
  • • Global Statements
  • • Local Statements
Control Statements
  • • If statement and if else statement
  • • If then else statement
  • • Where statement
  • • Loops (do, dountil, dowhile)
Procedures
  • • Proc Print
  • • Proc Transpose
  • • Proc Sort
  • • Proc Contents
  • • Proc Formats
  • • Proc Append
  • • Proc Tabulate
  • • Proc Import
  • • Proc Report
  • • Proc Export
  • • Proc Datasets
  • • Proc Freq
  • • Proc Means
  • • Proc Reg

Less...
Learn SAS Online
Advance SAS Training

Advance SAS Training

Advance SAS Training programme has been designed for the candidates who are already well versed and proficient with BASE SAS Programming . It requires lots of logical and analytical approach to write a programme. Candidate requires to go through some of the SQL and database knowledge also as it requires to connect and fetch the database from different sources and database.

More
SAS/SQL

  • • Introduction to Proc SQL
  • • Creating tables
  • • Inserting data into tables
  • • Alter the tables & etc…
  • • Modifying the tables
Retrieving Data from Multiple tables

  • • Natural Join
  • • Inner Join
  • • Outer Join (Right, Left, Full)
SAS/GRAPH

  • • Introduction to Graphs
  • • Types of Graphs
  • • Chart
  • • Plot
  • • illustration of axis options
  • • Illustration of symbol options
  • • Illustration of footnote, note, title
SAS/STAT

  • • Introduction to Statistics
  • • Producing Descriptive Statistics
  • • Computing Statistics for Numeric Variables
Procedures

  • • Proc Correlation
  • • Proc Regression
  • • Proc Means
  • • Proc Summary
  • • Proc Univariate
  • • Proc Freq
  • • Proc Annova
Combining SAS Datasets

  • • Concatenating
  • • Merging
  • • One-to-one merging
  • • One-to-many merging
  • • Many-to-one merging
  • • Many-to-many merging
  • • Matching merging
  • • Updating
Debugging of Errors

  • • Writing SAS programs that work
  • • Fixing programs that Don’t work
  • • Searching for the Missing Semicolon
Understanding Data step Processing

  • • Program data vector(PDV)
  • • Compilation Phase
  • • Execution Phase
  • • Creating a File shortcut with the File Shortcut Assignment Window
  • • Making a file shortcut to a program
  • • Deleting a file shortcut
  • • Browsing and submitting a file shortcut for a SAS program
  • • Viewing file shortcut properties
Output Delivery System (ODS)

  • • Fundamentals of the ODS
  • • ODS and the Data step
  • • Syntax for ODS Enhanced features in a Data step
  • • Introduction to ODS language Statements
SAS/MACROS

  • • Introduction to Macro Language Elements
  • • Introduction to Macro Variables
  • • Automatic Macro Variables
  • • User defined Macro Variables
  • • Introduction to Macro Processing
  • • Macro Statements
  • • Macro Functions
Retrieving Data from Single Table

  • • Integration of Database
  • • Connecting to a DBMS Using the SQL Procedure Pass-Through Facility
  • • Connecting to a excel Using the SQL Procedure Pass-Through Facility
  • • Connecting to a access Using the SQL Procedure Pass-Through Facility
  • • Connecting to a DBMS Using the Libname Statement
SAS/ACCESS

  • • Define SAS/Access Software
  • • Identify the types of data repositories that SAS/Access can access
  • • The interface engine
  • • The SAS/Access Libname Statement
  • • The SQL Procedure Pass-Through Facility
  • • The Access Procedure
  • • Requirements to Connect to a Database
  • • SAS/Access Libname engines
  • • Data sources

Less...

Apply now

Back to Top