BASE SAS

Introduction to SAS Programming & Working in the SAS environment
Introduction
WORKING WITH THE WINDOWS

Enhance Editor
Result Window
Log Window
Explorer Window
Output window
Program Editor Window

OVER VIEW OF LIBRARIES

Datasets
Cube
Data view
Referencing Files in
Catalog
SAS Libraries

BASIC CONCEPTS
Creating a SAS program
Components of SAS Program
Characteristics of SAS Program
Layout of SAS program

UNDERSTANDING DATA STEP PROCESSING

Program data vector
Execution Phase
Compilation Phase
Creating a File Shortcuts with the file shortcuts
Browsing and submitting a file shortcut for SAS program
Getting Started with Output Delivery System(ODS).


OPTIONS

Global options
Local options

STATEMENTS

Global Statements
Local Statements

INPUT STYLES

List Input
Modified Input
Column Input
Named Input
Formatted Input

POINTERS

Column Pointers
Line Pointers

INFORMATS AND FORMATS

Numeric
Character
Date & Time

COMBINING SAS DATASETS

Concatenating
One to One merging
Interleaving
Match Merging
One to one Reading
Updating or Setting

CONTROL STATEMENTS

If statements and If then Statement
If else statements
Where Condition
Like
Into
Loops( Do, While)
Arrays



READING RAW DATA FROM EXTERNAL FILES

Infile Statement
File Name Statement
DDE Triplet

WRITING DATA TO EXTERNAL FILES

File Statement
Put Statement

OUTPUT DELIVERY SYSTEM

Fundamentals of the ODS
ODS in Data step
Syntax for the ODS and Enhanced features in Data step

DEBUGGING OF ERRORS

Checking for Errors, Warnings, Un-insalization, Missing values, Repeats of by variable..etc

PROCEDURES

Proc Sort
Proc Transpose
Proc Print
Proc Printto
Proc Catalog
Proc Contents
Proc Formats
Proc Compare
Proc Append
Proc Tabulate
Proc Options
Proc Report
Proc Import
Proc Export
Proc Cport
Proc Cimport
Proc Copy
Proc Freq
Proc Means
Proc Chart & Pots
Proc Datasets
Proc Access
Proc Summary

SAS/MACROS

Introduction to SAS Macro Language Elements
Introduction to Macro Variables
Automatic Macro Variables
User define Macro Variables
How Macro processing will undergo inside the SAS system
Macro Statements
Macro Functions
Autocall Macros

SAS / SQL

Introduction to Proc SQL
Creating Tables
Inserting data into Tables
Alter & update the tables
SQL pass through Facility
Connecting to DBMS
Natural Joins
Inner Joins
Outer Joins

SAS/ACCESS and SAS / CONNECT

SAS/GRAPH

Type of Graphs ( Chart Map Plot)
Differ options using in Graphs

SAS/STAT

Proc Correlation
Proc Univariate
Proc Regression
Proc Anova

Clinical Trial Terminology & Process of Clinical Trials :

Introduction to drug discovery and development process.

Overview of highly regulated drug development process, from discovery to bringing a biopharmaceutical product to market


• Understanding major phases (Phase I - IV) of clinical trials and clinical data management