SAS Contents

NTRODUCTION TO SAS PROGRAMMING WORKING IN THE SAS ENVIRONMENT

Introduction

* working with the windows
* Enhance editor window
* Result Window
* Log Window
* Output Window
* Program editor window

Overview of libraries

* Data sets
* Cube
* Data view
* Referncing files in SAS Libraries

BASIC CONCEPTS

* Creating a SAS Programs
* Components of SAS
* Programs
* Characteristics of SAS

WRITING DATA TO EXTERNAL FILES

* File statement
* Put statement

OUTPUT DELIVERY SYSTEM

* Fundamentals of the output Delivery System
* Output Delivery System and the DATA�Step
* Introduction to ODS Language Statements

DEBUGGING OF ERRORS

* Writing SAS Programs that work
* Fixing Programs that donot work
* Searching for missing semicolon
* INPUT Statement reached past the end of the line
* Lost Cars
* Invalid Data
* Missing Values were generated
* Numeric values have been converted to character(or vice versa)
* Data step produces wrong results but not Error Message
* The Data step debugger
* Error:The option is not valid
* Note: variable is unutilized or Error: Variable Not Found
* SAS Truncates a character variable

SAS/ACCESS

* Define SAS/ACCESS Software
* Identify the types of data repositories that SAS/ACCESS can access
* The SAS/ACCESS LIBNAME Statement
* The SQL Procedure Pass-Through Facility
* The ACCESS procedure
* The DBLOAD Procedure
* Requirements to connect to a Data base
* SAS/ACCESS LIBNAME Engines
* ODBC
* Understand how to use ODBC with SAS Software
* Setup a data source for a data base driver
* Defining the Data Source Manager
* ODBC Driver
* Data Sources

SAS CONNECT

* Defination of SAS Connect
* Sign On
* Single -User Server
* Sign Off
* Muliti-User Server
* Services
* Communication Access Method

UNDER STANDING DATA STEP PROCESSING

* Program data vector
* Execution phase
* Compltion Phase
* Creating a file shotcut with the File Shortcut
* Assignment Window
* Making a file shotcut to a program
* Deleting a file shotcut
* Browsing and submitting a file shortcut for a sas program
* Viewing file shortcut properties
* Getting started with the Output Delivery System

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
* SAS Stops in the Middle of a job
* SAS Runs Out of Memory or Disk Space

PROCEDURES

* PROC TRANSPOSE
* PROC PRINT
* PROC CATALOG
* PROC CONTENTS
* PROC FORMS
* PROC FORMAT
* PROC APPEND
* PROC TABULATE
* PROC OPTIONS
* PROC REPORT
* PROC IMPORT
* PROC PRINTTO
* PROC EXPORT
* PROC MEANS
* PROC COPY
* PROC FREQ
* PROC TEMPLATE
* PROC CHART & PLOT
* PROC DATASETS
* PROC ACCESS

SAS/MACROS

* Introduction to Macro Language Elements
* Introduction to Macro Variables
* Automatic Macro Variables.
* User Defined Macro

SAS/GRAPH

Types of Graphs

* Chart
* Map
* Plot
* lllustration of global options
* lllistration of axis option
* lllistration of axis legend options
* lllustration pattern options
* lllstration symbol options
* lllustration of footnote, note, title.
* Graph n go

TECHNO-FUNCTIONAL

ETL (EXTRACTION TRANSFORMATION & LOADING)

* Exploring sas warehouse administrator
* Exploring sas warehouse administrator
* Setting up a data ware house environment.
* Creating a data warehouse environment.
* Working with source data.
* Importing raw data.
* Creating sas data view
* Create ODD ’s
* Work with DBMS data.
* Defining a global metadata
* Creating a data warehouse
* Adding a data warehouse and a subject.

INFORMATS AND FORMATS

* in formats
* Character in formats
* Data and time in formats

Numeric in formats

* charter Informats
* Data and Time informats
* Numeric informats

COMBINING SAS DATASETS

* Concatenating
* One to One merging
* Interleaving
* Match Merging
* One to One reading
* Updating

CONTROL STATEMENTS

* IF STATEMENT AND IF ELSE STATEMENT
* IF THE ELSE STATEMENT
* WHERE STATEMENT
* Loops (do.dountil.dowhile)
* Arrays Statement.

READING RAW DATA FROM EXTERNAL FILE

* INFILE Statement
* Filename Statement
* DDE Triplet
* Macro Statement
* Macro Functions
* Auto call Macros

SAS/SQL

Introduction to PROC SQL

* Creating tables
* Inserting data Info Tables
* Alter the Tables & etc……
* Update

Modifying the tables Retrieving Data from Single Table

* Integration to Database
* Connecting to a DBMS
* Using the SQL Procedure Pass-through Facility
* Connecting to a excel using the SQL Procedure Pass-Through Facility
* Connecting to a access using the SQL Procedure Pass-Through Facility
* Connecting to a DBMS Using the Libname Statement.

Retrieving Data from Multiple Tables

* Natural Join
* Inner Join
* Outer Join(Right, Left, Full)
* Reflective join.
* Create a detail data source.
* Define a process editor job.
* Customize sas.warehouse administrator.

OLAP

* Introduction to olap
* Building a cube
* Olap concepts
* Mddb wizard interface

FUNCTIONAL

* STAT

PROCEDURES

* PROC CORRELATION
* PROC UNIVARIATE
* PROC REGRESSION
* PROC FREQ
* PROCMEANS
* PROC ANOVA
* PROCTTEST
* PROC SUMMARY etc...

CDM (CLINICAL DATA MANAGEMENT)

* General abbreviated terms
* Drug discovery and development
* Introduction to Clinical trials
* Phase trials: Preclinical 1,2,3 and 4
* ICHGCP
* ICH history
* GCP Guidelines
* 21 CFR 11
* CRF review and sample CRF ’s
* CRF receiving
* Responsibilities of CRA
* Activities of CRA in house
* CRA Monitoring
* Responsibilities of PI
* IRB
* Informed consent form
* Pharmacovigilance
* Pharmacokinetics
* Clinical data management process
* Clinical research study documents
* Cdisc introduction
* CTM Systems
* Data Management Plan
* FDA history
* FDA guidelines
* IND,NDA reviews
* Computer System Validation

CDM CAREER OPPORTUNITIES

CRO

* Auditors
* Training Manager
* Clinical Research Manager
* Medical Monitors
* Clinical Research Associate
* Documentation Manager
* Quality Assurance Manager
* Regulatory

HOSPITALS

* Business Development
* Co-Investigator
* Study Co-Ordinator
* Site Manager
* Research Officer
* Study Nurse

IT

* Medical Writer
* Bio-Statistatian
* Data Validation Offer
* Data Co-ordinator
* Data Manager
* It Support
* CRF Designers

SAS Career Opportunities

* Sas Progammer
* Sas Analyst
* Sas Warehouse administrator etc…

SAS Domains

* Pharmaceuticals
* Banking
* Insurance
* Finance
* Automobiles
* Retails
* Manufacturing
* Weather forecast
* Crime Prevention
* Agriculture
* Telecom Department
* Hotels
* Hospitals
* Universities