SAS Training

Objective: This module has been designed to teach the process to use the SAS programs and SAS environment with specifications of data and proc steps. You will also master the process to install SAS university edition on your computer.

Topics:

• • Areas where SAS is used
  • SAS university edition installation
  • Rules to define the SAS name
  • Overview of SAS window, SAS GUI, and its associated topics.
  • Data types in SAS
  • SAS Datasets
  • Procedural step and Data step
  • Creation of instream SAS dataset
  • Analysing Program Data Vector (PDV) and Input Buffer.

Learning Outcome: By the completion of this module you will gain hands-on experience in data conversion, nuts and bolts of SAS programming, and creation of datasets using CARDS.

Objective: This module has been designed to teach you the process to import and control datasets into SAS and procedure to concatenate them.

Topics:

• • Data importing into SAS
  • Datasets modification
  • Working with permanent as well as temporary datasets
  • Creation of a variable
  • Merging statements

Learning objective: Upon finishing this module you will learn how to import external data using INFILE, a process to use PROC IMPORT, performing various tasks such as KEEP, DROP RENAME, new variable construction, etc.

Objective: This module will teach you the concept of looping and its role in the SAS programming language. You will also learn how arrays are used in SAS.

Topics:

• • Conditional Iterative Processing
  • Useful SAS Functions
  • SAS Arrays
  • Date/Time Functions
  • PUT/INPUT Functions
  • Character Functions
  • Numeric Functions

Learning Outcome: After finishing this module you will gain hands-on experience in using arrays, statements, INPUT/PUT functions, writing programs with date/time functions, and using character functions.

Objective: This module has been designed to teach concepts such as Statistical Procedures, define statistical data, the correlation between two or more variables.

Topics:

• • Proc Dataset
  • Proc Sort
  • Proc Format
  • Proc Means
  • Proc Surveyselect
  • Proc Freq
  • Proc Summary
  • Proc Transpose
  • Proc Corr
  • Proc Rank
  • Proc Univariate

Learning outcome: You will gain hands-on experience in the process to obtain statistical means of variable, degree of dependency, generating ranks for statistical data, data restructuring, and data sampling.

Objective: This course has been designed to teach how to classify even based on dependent variables and you will also be taught to perform various types of clustering methodologies in SAS.

Topics:

• • Introduction to Clustering
  • Multiple regression analysis
  • Sample regression
  • Hierarchical Clustering
  • Non-Hierarchical clustering
  • Logistic Regression

Learning Outcome: You will gain hands-on experience in using the PROC CLUSTER, PROC FASTCLUS, using PROC LOGISTIC, etc.

Objective: This module has been designed to teach you the process to minimize the degree of complexity of a problem by using optimization models in SAS, and producing detailed output from SAS in desired formats.

Topics:

• Introduction to data optimization
• Various data optimization models available
• The process to use Proc Optmodel
• Introduction to ODS
• Resolving Rosenbrock Problem
• Benefits of using ODS
• Generating pdf file
• Generating rtf file
• Generating doc file
• Generating HTML file

Learning Outcome: You will gain hands-on experience in using PROC OPTMODEL, Extracting optimized outputs, Solving optimization models, routing presentation files, Create HTML files, Create rtf file and creation of Doc and PDF files.

Learning Objective: This module has been designed to teach you the process to invoke SQL in SAS.

 Topics:

• • Creating new tables
  • Sorting Data
  • The CASE expression
  • The SELECT statement
  • JOINS and UNIONS
  • SELECT statement clauses

Learning Outcome: In this chapter, you will gain hands-on exposure in the areas such as Writing the SELECT clause, Merging Datasets,  WHERE clause application, process to use order by clause and merging datasets.

Learning objective: This module has been designed to teach you the process to automate repeated as well as complex processes in SAS by using Macros.

Topics:

• • Introduction to Macros
  • Task automation
  • Advantages of using  SAS Macros
  • Macro Variables
  • Macro Code Constituents
  • Macro Step
  • Positional Parameters to Macros

Learning Outcome: You will gain hands-on experience in using Macros, simplifying a program, performing macro coding, etc.