Base Sas

Base Sas

Courses Info

SAS BASE TRAINING SYLLABUS

 

  • INTRODUCTION TO SAS PROGRAMMING
  • Working in the SAS Environment
  • Working with the Windows
  • Enhance Editor
  • Result Window
  • Log Window
  • Explorer Window
  • Output Window
  • Program Editor Window

 

  • BASICS OF SAS LANGUAGE
  • SAS Libraries
  • Data Sets
  • Cube
  • Data View
  • Referencing Files in Catalog
  • Creating a SAS Program
  • Components of SAS Program
  • Characteristics of SAS Program
  • Layout of SAS Program

 

  • ACCESSING DATA
  • Use FORMATTED, LIST and COLUMN input to read raw data files
  • Use INFILE statement options to control processing when reading raw data files
  • Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls
  • Combine SAS data sets using the DATA step

 

  • CREATING SAS DATA SETS
  • Create temporary and permanent SAS data sets
  • Create and manipulate SAS date values
  • Control which observations and variables in a SAS data set are processed and output

 

  • DATA STEP PROCESSING
  • Program Data Vector (PDV)
  • Execution Phase and Compilation Phase
  • Get Started with Output Delivery System ( ODS )

 

  • STATEMENT OPTIONS
  • Global Statements
  • Local Statements
  • List Input
  • Modified Input
  • Column Input
  • Named Input

 

  • MANAGING DATA
  • Exploring SAS data libraries using base SAS utility procedures
  • Sorting observations in a SAS data set
  • Conditionally execute SAS statements
  • Use assignment statements in the DATA step
  • Modify variable attributes using options and statements in the DATA step
  • Use SAS functions to manipulate character data, numeric data, and SAS date values
  • Use SAS functions to convert character data to numeric and vice versa

 

  • COMBINING SAS DATA SETS
  • Concatenation
  • One-One Merging
  • Match Merging
  • One-One Reading
  • Updating or Setting

 

  • CONDITIONAL STATEMENTS
  • IF & IF THEN statement
  • IF ELSE statement
  • Where condition
  • Like , Into Statements
  • Loops ( Do, While )

 

  • WRITING DATA TO EXTERNAL FILES
  • File Statement
  • Put Statement

 

  • GENERATING REPORTS
  • Generate list reports using the PRINT and REPORT procedures
  • Enhance reports through the use of labels, SAS formats, user-defined formats
  • Generate summary reports and frequency tables using base SAS procedures

 

  • DEBUGGING AND HANDLING ERRORS
  • Identify and resolve programming logic errors
  • Checking for Errors, Warnings, Un-Initialization , missing values
  • Recognize and correct syntax errors
  • Examine and resolve data errors

 

 

  • PROCEDURES
  • Proc Sort
  • Proc Transpose
  • Proc Print
  • Proc Contents
  • Proc Formats, Proc Compare
  • Proc Append, Proc Tabulate
  • Proc Report
  • Proc Import, Proc Export
  • Proc Freq
  • Proc Means