SAS Training
INTRODUCTION TO SAS TRAINING 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
  • Cubes
  • 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 types of data repositories that SAS 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 & 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
SPRY Web Technologies