SAS Foundation

sas logoIntroduction to SAS Programming

Working in the SAS Environment

  •      Introduction

Working with the windows

  • Program editor window
  • Log window
  • Output window
  • Result window
  • Explorer window

Overview of libraries

  • Datasets
  • Data view
  • Catalog
  • Referencing Files in SAS Libraries

Basic concepts

  • Creating a SAS Programs
  • Components of SAS Programs
  • Characteristics of SAS Programs
  • Layout of SAS Programs

Understanding Data step Processing

  • Program data vector(PDV)
  • Compilation Phase
  • Execution Phase
  • Creating a File shortcut with the File Shortcut Assignment Window
  • Making a file shortcut to a program
  • Deleting a file shortcut
  • Browsing and submitting a file shortcut for a SAS program
  • Viewing file shortcut properties

Importing

  • Methods for getting data into SAS can be put into four general categories:
  • Entering data directly into SAS data sets
  • Creating SAS data sets from raw data files
  • Converting other software’s data files into SAS data sets
  • Reading other software’s data file directly

Input Styles

  • List input
  • Column input
  • Formatted input
  • Modified/Mixing input
  • Reading Messy Raw Data
  • Reading Multiple lines of Raw Data per observation
  • Reading Multiple observations per line of raw data
  • Reading delimited file with DATA step
  • Permanent Attributes
  • Temporary Variable Attributes
  • Pointers
  • Column pointers
  • Line Pointers

 Informats

  • Character informats
  • Numeric informats
  • Date and time informats

Formats

  • Character formats
  • Numeric formats
  • Date and time formats

Functions

  • Arithmetic Functions
  • String Functions
  • Date and Time Functions

 Conditional Statements

  • Reading Raw Data from External File
  • Infile statement
  • Import
  • Export

Options

  • Global options
  • Local Options

Statements

  • Global Statements
  • Local Statements

 Control Statements

  • If statement and if else statement
  • If then else statement
  • Where statement
  • Loops (do, dountil, dowhile)

Joins

  • Retrieving Data from Multiple tables
  • Natural Join
  • Inner Join
  • Outer Join (Right, Left, Full)

SAS/SQL

  •    Introduction to Proc SQL
  •    Creating tables
  •    Inserting data into tables
  •    Alter the tables & etc…
  •     Modifying the tables

Procedures

  • Proc Print
  • Proc Transpose
  • Proc Sort
  • Proc Contents
  • Proc Formats
  • Proc Append
  • Proc Tabulate
  • Proc Import
  • Proc Report
  • Proc Export
  • Proc Datasets
  • Proc Freq
  • Proc Means
  • Proc Reg
  • Proc Annova

SAS/MACROS

  • Introduction to Macro Language Elements
  • Introduction to Macro Variables
  • Automatic Macro Variables
  • User defined Macro Variables
  • Introduction to Macro Processing
  • Macro Statements
  • Macro Functions

Combining SAS Datasets

  •    Concatenating
  •    Merging
  •    One-to-one merging
  •    One-to-many merging
  •    Many-to-one merging
  •    Many-to-many merging
  •    Matching merging
  •     Updating

Debugging of Errors

  • Writing SAS programs that work
  • Fixing programs that Don’t work
  • Searching for the Missing Semicolon

Retrieving Data from Single Table

  • Integration of Database
  • Connecting to a DBMS Using the SQL Procedure Pass-Through Facility
  • Connecting to a excel Using the SQL Procedure Pass-Through Facility
  • Connecting to a access Using the SQL Procedure Pass-Through Facility
  • Connecting to a DBMS Using the Libname Statement

SAS/ACCESS

  • Define SAS/Access Software
  • Identify the types of data repositories that SAS/Access can access
  • The interface engine
  • The SAS/Access Libname Statement
  • The SQL Procedure Pass-Through Facility
  • The Access Procedure
  • Requirements to Connect to a Database
  • SAS/Access Libname engines
  • Data sources