SAS Clinical

INTRODUCTION

Introduction of SAS software

Industries using SAS

Components of SAS System

Architecture of SAS system

Functionality of SAS System

Introduction of SAS windows

Working in the SAS Environment

Functionality of SAS Windows

Creating and managing SAS Libraries

Overview of SAS Data states

Types of Libraries

Storing files temporarily and permanently

Referencing SAS files

CREATION DATABASE FROM RAWDATA

Steps to create a SAS dataset

Creating SAS dataset using text file

Creating SAS dataset using text file with delimiters

Creating SAS dataset using structured text file

Creating SAS dataset using unstructured text file

Creating SAS dataset using Excel file

Creating SAS dataset using Access file

Creating SAS dataset using values inside the code

CREATING AND REDEFFING VARIABLES

Use with different conditional statements

DEBUGGING ERROR MESSAGES

DEBUGGING syntax ERROR MESSAGES

AUTOMATIC VARIABLES

Use of automatic variables

Types of automatics variables

Use of _N_, _ERROR_, _NULL_

Testing your programs

Using put statement

Automatic Variable

Output delivery system

Concepts of output delivery system

How ODS works and viewing output of ODS in different format

HTML, RTF, PDF etc.

COMBINATION the dataset

One-o-one reading

One to many

Many to many

Concatenation

Interleaving

Match merge

Functions

Character function

Numerical function

Arithmetical function

Mathematical function

Date Function

Sampling method

Random sampling

Loops in SAS : Do Loops

Loops are used to iterate through every observation for specified number of times to obtain a desired result

Types of Loops:

Do Loop

Do While

Do Until

Default increments by 1

Can use BY to increment by any value other than 1

Array

Definition of array

Example of array

PROCEDURES IN BASE SAS

Procedure Format

Procedure Contents

Procedure Options

Procedure Append

Procedure Compare

Procedure Transpose

Procedure Print

Procedure Import

Procedure Export

Procedure Datasets

Procedure Tabulate

Procedure Chart, Gchart, Gplot

Procedure Report

GRAPHS

Introduction to graphics

Introduction to graphics

Types of Graphics (with latest models)

Defining procedure Graphics

Advance SAS Topic

Proc Sql

Generate detail reports by working with a single table, joining tables, or using set operators in the SQL procedure

Generate summary reports by working with a single table, joining tables, or using set operators in the SQL procedure

Construct sub-queries and in-line views within an SQL procedure step

Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques

Access Dictionary Tables using the SQL procedure

Macro

Create and use user-defined and automatic macro variables within the SAS Macro Language

Automate programs by defining and calling macros using the SAS Macro Language

Understand the use of macro functions