# Course Name : Data Warehousing
# Sub Course : SAS
# Duration : 40
# Course Content :

SAS

INTRODUCTION TO SAS PROGRAMMING WORKING IN THE SAS ENVIRONMENT

Introduction

* working with the windows
* Enhance editor window
* Result Window
* Log Window
* Output Window
* Program editor window

Overview of libraries

* Data sets
* Cube
* Data view
* Referncing files in SAS Libraries

BASIC CONCEPTS

* Creating a SAS Programs
* Components of SAS
* Programs
* Characteristics of SAS

WRITING DATA TO EXTERNAL FILES

* File statement
* Put statement

OUTPUT DELIVERY SYSTEM

* Fundamentals of the output Delivery System
* Output Delivery System and the DATA Step
* Introduction to ODS Language Statements

DEBUGGING OF ERRORS

* Writing SAS Programs that work
* Fixing Programs that donot work
* Searching for missing semicolon
* INPUT Statement reached past the end of the line
* Lost Cars
* Invalid Data
* Missing Values were generated
* Numeric values have been converted to character(or vice versa)
* Data step produces wrong results but not Error Message
* The Data step debugger
* Error:The option is not valid
* Note: variable is unutilized or Error: Variable Not Found
* SAS Truncates a character variable

SAS/ACCESS

* Define SAS/ACCESS Software
* Identify the types of data repositories that SAS/ACCESS can access
* The SAS/ACCESS LIBNAME Statement
* The SQL Procedure Pass-Through Facility
* The ACCESS procedure
* The DBLOAD Procedure
* Requirements to connect to a Data base
* SAS/ACCESS LIBNAME Engines
* ODBC
* Understand how to use ODBC with SAS Software
* Setup a data source for a data base driver
* Defining the Data Source Manager
* ODBC Driver
* Data Sources

SAS CONNECT

* Defination of SAS Connect
* Sign On
* Single -User Server
* Sign Off
* Muliti-User Server
* Services
* Communication Access Method

UNDER STANDING DATA STEP PROCESSING

* Program data vector
* Execution phase
* Compltion Phase
* Creating a file shotcut with the File Shortcut
* Assignment Window
* Making a file shotcut to a program
* Deleting a file shotcut
* Browsing and submitting a file shortcut for a sas program
* Viewing file shortcut properties
* Getting started with the Output Delivery System

OPTIONS

* Global options
* Local Options

STATEMENTS

* Global Statements
* Local Statements

INPUT STYLES

* List input
* Modified input
* Column input
* Named input
* Formatted input