SAS Administration course for Working professional by STAR IT TECHNOLOGIES

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 Data Structures
Create temporary and permanent SAS data sets
Create and manipulate SAS date values
Use DATA Step statements to export data to standard and comma delimited raw data files
Control which observations and variables in a SAS data set are processed and output
Managing Data
Investigate SAS data libraries using base SAS utility procedures
Sort 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
Accumulate sub-totals and totals using DATA step statements
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
Process data using DO LOOPS
Process data using SAS arrays
Generating Reports
Generate list reports using the PRINT and REPORT procedures
Generate summary reports and frequency tables using base SAS procedures
Enhance reports through the use of labels, SAS formats, user-defined formats, titles, footnotes and SAS System reporting options
Generate HTML reports using ODS statements
Handling Errors
Identify and resolve programming logic errors
Recognize and correct syntax errors
Examine and resolve data errors

Basic Concepts

Introduction
Objectives
SAS Programs
Components of SAS Programs
Characteristics of SAS Programs
Layout for SAS Programs
Processing SAS Programs
Log Messages
Results of Processing
SAS Libraries
How SAS Files Are Stored
Storing Files Temporarily or Permanently
Referencing SAS Files
Two-Level Names
Referencing Temporary SAS Files
Referencing Permanent SAS Files
Rules for SAS Names
SAS Data Sets
Overview of Data Sets
Descriptor Portion
Data Portion
Observations (Rows)
Variable Attributes
Name
Type
Length
Format
Informat
Label
Variables (Columns)
Missing Values