Tutors

DataTrained

PROGRAM OVERVIEW

What you'll learn

  1. Be equipped with the powerful SAS language to start an amazing data analysis career
  2. Be ready to work in Finance and Pharmaceutical industries that require SAS programming skills
  3. Learn how to generate statistics such as mean value, median value, and standard deviation
  4. Be able to perform linear regression to analyze data
  5. Be able to create charts and plots for data (visualization)

CURRICULUM

  Getting started with SAS

  • Installing SAS University Edition
  • Use Cases of SAS Implementation
  • Rules Datatypes Datasets
  • Accessing Data (SAS Libraries)
  • Basic Procedural Statements in SAS
  • Enhancing Outputs- Global Statements
  • Enhancing Outputs- Formats and standard SAS formats
  • Enhancing Outputs- User Defined Formats

  Reading data in SAS and Processing and Integrating with Data step

  • Import of data in SAS
  • Reading Raw External Data Files Column Input Part 1
  • Reading Raw External Data Files Formatted Input Part 2
  • Reading Raw External Data Files List Input Simple List Input Part 3
  • Reading Raw External Data Files List Input List Input with non default delimiters Part 4
  • Conditional Formatting IF THEN ELSE logic Part 1
  • Conditional Formatting Subsetting Data by Manipulating influx of datasets into SAS Part 2
  • Combining SAS Datasets One to one reading concatenating interleaving Part 1
  • Conditional Formatting Subsetting Data by Manipulating influx of datasets into SAS Part 2
  • Combining SAS Datasets One to one reading concatenating interleaving Part 1
  • Combining SAS Datasets Merging Part 2
  • Combining SAS Datasets Types of merging Part 3
  • Controlling how a record loads An Extension of List Input Method Part 1
  • Controlling how a record loads An Extension of List Input Method Part 2
  • Controlling how a record loads Loading Heirarchical Records Part 3
  • Writing to an External File ODS CSVALL Part 1
  • Writing to an External File Controlling Output Part 2
  • Writing to an External File Controlling Output Part 3

  SAS Summarization

  • Summarizing data with Accumulating Totals and Retaining Variables
  • Iterative Processing in SAS Do Loops Part 1
  • Iterative Processing in SAS Do Loops Part 2
  • SAS Arrays SAS Array Processing Part 1
  • SAS Arrays Use of SAS Arrays Part 2
  • SAS Functions Introduction and Character Functions Part 1
  • SAS Functions Character Functions Part 2
  • SAS Functions Character Functions Part 3
  • SAS Functions Numeric Functions and Data Type conversions Part 4
  • SAS Functions Data Type conversions contd Part 5

  SAS Output Delivery System

  • Export Procedure

  SAS Macros Facility

  • SAS Macros Overview
  • Automatic Macro Variables
  • User defined Macro Variables
  • Macro Functions
  • Macro Calls
  • Macro Parameters

  SAS SQL Procedure

  • Introduction to SAS SQL
  • Overview of PROC SQL Part 1
  • Overview of PROC SQL Part 2
  • Summarizing grouping and analyzing data groups within PROC SQL
  • Subqueries and types of subqueries
  • Combining Tables Overview and Joins
  • Combining Tables Complex Joins
  • Combining Tables Set Operators
  • Creating Tables and Views
  • Creating Indexes and Maintaining Tables and Views

  SAS Statistical Procedures

  • Univariate Procedure and basics of distribution
  • Descriptive statistics with Proc Means and Proc Freq
  • Correlation Procedure
  • Regression Procedure