Our Courses  
 
SAS
Course Contents

INTRODUCTION TO SAS

  • Evolution / History of SAS
  • Concepts of Database and Dataware Housing
  • Comparative study SAS with other Reporting Tools
  • Getting started with SAS
  • Steps to enter in to the SAS Environment
  • SAS Window Environment
  • Differences between CPU Time and Real Time
  • Creating own libraries
  • Explaining about different windows in SAS

SAS PROGRAMMING

  • Simple syntax of SAS Program
  • Structure of SAS Program
  • Opening and submitting the SAS program in editor window
  • SAS naming conventions
  • How to see the output in different ways
  • Program Data Vector and Input Buffer etc

INPUT METHODS

  • List Input Method
  • Format Input Method
  • Named Input Method
  • Advanced input method

DELIMITERS

  • DLM
  • DSD
  • Slash
  • Hash

OPTIONS IN SAS

  • System Options
  • Data Set Options
  • Proc Print Options

INFORMATS & FORMATS

  • Date , Julian Date etc

FUNCTIONS

  • Arithmetic Functions
  • String Functions
  • Date and Time Functions
  • Where Statement

SAS REPORT GENERATION

  • Define , width, group,
  • Summarize, Break Statement,
  • compute, OL, UL, Dol, Dul,
  • R break Statement, group, Across
  • DOL & DUL, NOWD, Headline, Co lour.

MERGING STATEMENTS

  • Set
  • Append
  • Update
  • Modify
  • Merge

MERGE DATA SETS

  • Concatenation, Interleaving
  • One to one
  • One to Many
  • Many to Many
  • In Option

SAS / ACCESS Module IMPORT & EXPORT DATA FROM EXTERNAL FILES

  • From Text file,
  • CSV, TAB files
  • Microsoft Excel,
  • Microsoft Access,
  • SQL Pass through

SAS / SQL

  • INTRODUCTION TO DATABASE
  • Understanding sql through SAS
  • DDL Commands in SQL
  • DML Commands in SQL
  • Working with Joins
  • Working with unions
  • Working with Functions
  • Constraints
  • Creating Views
  • Proc Sql Statement
  • Connect, Disconnect statements

SAS/ ODS

  • OUTPUT DELIVERY SYSTEM
  • ODS HTML
  • ODS PDF
  • ODS PS
  • ODS RTF
  • ODSXML
  • Templates

SAS/Graph

  • Introduction about Graphs
  • Producing Charts
  • Bar Charts
  • Block charts
  • Pie charts
  • Plots

SAS/STAT

  • Introduction about Statistics
  • Proc tabulate
  • Proc summery
  • Proc Mean
  • Proc Median
  • Proc Frequency
  • Proc tabulate
  • Proc Rank
  • Regression Analysis

SAS/MACROS

  • Introduction to Macros
  • Type of Macros
  • Automatic macro variables
  • Global Macro variables creation
  • Local macro variables creation
  • Passing Arguments to macros
  • Positional parameters
  • Keyword parameters.
  • Macro Processing
  • Macro Functions
  • Macro expressions.
  • To develop macro application for Print and procedures
  • To develop macro application for Import and export procedures
  • Macro options
  • Macro interface functions
  • SYMPUT
  • SYMGET
 
 
 
    Copyright © 2012-14 www.ifocusitolutions.com All rights reserved. Facebook Twitter LinkedIn Blog