BASE SAS CONTENTS

BASE SAS

• Introduction To SAS System & Architecture
• History And Various Modules
• Features, Variables & SAS Syntax Rules
• SAS Data Sets , Options
• Operators, Input Styles
• Reading Raw Data
• In file Statement With Options
• Working With External Files & Options
• Creating & Redefining Variables
• Where Statement
• Conditional statements
• Stop And Error Statements
• Output Statement, Put Statement
• Modifying And Combining Data Sets
• Updating Master Data Set
• Display Manager Commands
• SAS Functions

BASE SAS PROCEDURES

• Proc Tabulate
• Proc transpose
• Proc Contents
• Proc Print
• Proc Means
• Proc Format
• Proc Freq
• Proc rank
• Proc sort
• Proc Summary
• Proc Import, Export
• Proc Append
• Proc Plot
• Copy, Datasets, Delete

SAS/ACCESS

• Working With Oracle
• Working With Ms-Access
• Working With Ms-Excel
• DBLoad Procedure

SAS/GRAPH/charts

• Gchart Procedure
• Vertical, Horizontal, Pie
• Group, Subgroups
• Gplot Procedure
• Multiple Plots & Overlay
• Symbol Statement
• Title And Footnote Statements

SAS/ODS

• Creating Rtf File,Creating Html File,PDF File

SAS/REPORTS

• Frequency Report
• One-Way Frequency Report
• Cross Tabular Frequency Report
• Summary Statistics
• Creating A List Report
• Order Usage and Group
• Printing Grand Totals
• Rbreak Statement
• Tabulate Procedure
• One-Dimensional Tables
• Two-Dimensional Tables
• Obtaining A Total
• Analysis Variables with options
• Summary Statistics

SAS Database:SAS -SQL
ORACLE-SQL CONCEPTS

• Introduction
• History
• Features
• Sql Command Set
• Operators In Sql
• Order By Clause
• Group By Clause
• Having Clause
• Distinct Clause
• Create and Insert
• Deleting, Populating And Updating
• Joins ,import & export

SAS/SQL

• Introduction To SAS/Sql
• Features ,Uses
• Data Types, Key Words, & Operators
• Functions ,Formatting Output
• Group By Clause
• Order By Clause
• Having Clause
• Case Expression And Conditional Logic.
• Creating ,Populating & Deleting Tables
• Alter Table Statement
• Changing Column’s Length
• Joins
• Constraints
• Renaming A Table & Columns
• Views

SAS/MACROS
ADVANCE TOPICS IN SAS

• PERFORMING ADVANCED QUERIES USING PROC SQL
• INTRODUCING MACRO VARIABLES
• CREATING AND USING MACRO PROGRAMS
• STORING MACRO PROGRAMS
• CREATING SAMPLES AND INDEXES
• USING LOOKUP TABLES TO MATCH DATA
• MODIFYING SAS DATA SETS AND TRACKING CHANGES

SAS Clinical

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 raw data

• 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.

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 numberof 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

• 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
ProcSql

• 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.

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.

Introduction of SAS and Clinical research

• SAS role in Clinical Research.
• What is Clinical trial?
• What is Protocol and role of Protocol in Clinical Research?
• Which is playing main role in Clinical Research?

CLINICAL TRIALS DATA STRUCTURES

• Identify the classes of clinical trials data (demographic, lab, baseline,concomitant medication, etc.).
• Identify key CDISC principals and terms.
• Describe the structure and purpose of the CDISC SDTM data model.
• Describe the structure and purpose of the CDISC ADaM data model.
• Describe the contents and purpose of define.xml.

Statistic and Report Clinical Trials Results

• Use SAS procedures to obtain descriptive statistics for clinical trials data           (FREQ, UNIVARIATE, MEANS, SUMMARY).
• Use PROC FREQ to obtain p­values for categorical data (2×2 and NxP test for association).
• Use PROC TTEST to obtain p­values for continuous data (one ­sample paired and two­ sample t-­tests).
• Create output data sets from statistical procedures.
• Using ODS with PROC REPORT and PROC TABULATE to generate nice looking tables and listings
• Producing Bar and Pie charts using PROC GPLOT and PROC GCHART

Transform Clinical Trials Data

• Apply categorization and windowing techniques to clinical trials data.
• Transpose SAS data sets.
• Apply ‘observation carry forward’ techniques to clinical trials data (LOCF, BOCF,
  WOCF).
• Calculate ‘change from baseline’ results.