Clinical Data Management & SAS Clinical programming From Hyderabad Live Scenarios

like eCRF designing from the Protocol,

SDTM implementation,

TLG creation,

Validation programming

Pharmacovigilance

EDC PLAN

DATA BASE DESIGN

DATA VALIDATION

DATA BASE SETUP

QC AND QA

SAS training service especially to

INTRODUCTION TO SAS IN CDM

COMPONENTS OF SAS

BASE/SAS

SAS/STAT

SAS/GRAPH

SAS/ACCESS

SAS/MACRO

create TLG,

SDTM data-sets

Lara Clinical Research

SAS COURSE CONTENT

Programming I: SAS Essentials

1.1 SAS System Basics

· Accessing the SAS System.

· Navigating through the SAS windows including the editor, log, and output windows.

· Creating and executing SAS programs in batch and interactive mode.

· Understanding errors in the SAS log.

· Exploring program output.

· Understanding SAS data set and library structure.

· Creating DATA and PROC steps.

· Understanding SAS syntax and SAS naming conventions.

· Working with temporary and permanent SAS data sets.

1.2 Creating Reports

· Using the REPORT Procedure.

· Creating reports in WYSIWYG interactive environment without code

· Creating reports in batch environment with code and NOWD

· Using COLUMN, DEFINE, and COMPUTE statements for structure

· Using ODS to generate HTML, RTF and XML reports

· Using Report Options such as WIDTH, FORMAT, DISPLAY, GROUP, HEADLINE and HEARSKIP

· Summarizing and sorting reports

· Adding titles, footnotes and labels to reports

· Using the PRINT procedure

· Selecting report columns with the VAR statement

· Grouping reports with the BY statement

· Summing report columns with the SUM statement

· Producing frequency tables using the FREQ procedure

1.3 Creating Graphs

· Producing vertical and horizontal bar charts with the GCHART procedure, VBAR and HBAR

· Understanding chart variables

· Using RUN-­-group processing for multiple graphs in the same session

· Understanding options to tailor graphs, such as DISCRETE, SUMVAR, and TYPE

1.4 Reading SAS Data Sets

· Reading data sets with the SET statement

· Restricting data set size by selecting variables with DROP= and KEEP= options

· Using IF-­-THEN/ELSE logic processing

· Difference between subsetting IF and WHERE clause processing to restrict Observations

1.5 Creating SAS Data Sets

· Reading raw data Using list, column and pointer input

· Naming variables

· Understanding how to read any type of data Using SAS informats

· Using INFILE and INPUT statements to read raw data

· Examining the structure of SAS data set and its variables' attributes using the CONTENTS procedure

· Creating new variables using SAS functions and assignment Statements

1.6 Recoding and Reorganizing Data

· Using SAS formats to recode data Values for better presentation in reports and analyses

· Using the FORMAT procedure to create user defined value labels

· Reordering rows of data with the SORT procedure

1.7 Summarizing

· Your Data Calculating descriptive statistics with the MEANS and SUMMARY procedures

· Grouping data using the CLASS statement

· Analyzing data values using the VAR statement and appropriate functions such as SUM, MEAN, MEDIAN and more

· Generating one-­-way and multi-­-way frequency tables using the FREQ procedure

· Using the TABLES statement In the FREQ procedure to specify analysis structure

1.8 Combining SAS Data Sets

· Concatenating SAS data sets using the SET statement

· Merging multiple SAS data sets on common key variables

· Using the SQL procedure

· Comparing methods of merging (joining) data sets

Programming II: Data Manipulation Using the Data Step

2.1 Understanding the Data Step

· Understanding the difference between compile and execute phases of the Data Step

· Learning about Data Step storage areas

· Reading and creating multiple SAS data sets.

2.2 Hot Debug Your Program

· Learning to Dump the Input Buffer and Program Data Vector with the PUT statement

· Using the interactive debugger to understand program logic problems

2.3 Reading External Data Types and Creating Flat File Basics

· Reading flat files using delimiters Reading data from relational database

· Creating user defined informats for special data and flat files in SAS

2.4 Creating New Variables and Adding Value to Your Data

· Cleaning existing data

· Assigning new character, numeric and date variables

· Using Picture Statements to create user defined formats

2.5 Combining Data Files Using a Match Merging and Interleaving

· Match merging multiple SAS data sets together

· Interleaving SAS data sets with the SET statement

· ChangingvariabletypesusingthePUTandINPUTfunctionsSummarizingData Files

· Summarizing data in the data step using Sum and Retain statements

· Creating group totals with First and Last processing

· Creating summary data sets with Proc Summary

· Selecting specification summarization hierarchies using the _TYPE_ Variable

2.6 Perform Iterative processing on Data

· Using DO loops for repetitive calculations and processing

· Using Arrays to process across an observation

· Using DO WHILE and DO UNTIL statements for conditional looping

· Creating simple random sample

2.7 Producing Exception Reports

· Using WHERE statement to subset data

· Using contribution option to perform table lookups when merging files

· Identifying duplicate rows of data infile

3 Advance Macros

· Introduction to Marcos

· Macro Compilations

· Defining Global & Local Macro variables

· Macro options, Expressions

· %Put, %Let, %IF, %Else, %Do, %End

· Creating Macros Programs

ALONG WITH PROJECT ON CLINICAL SAS

Contact: Lara Clinical Research

#211,2nd floor, Nilgiri Block, Aditya Enclave

Ameerpet, Hyderabad

040-66493666, 9550381845,