CLINITEQ

Cliniteq aims to provide quality training on SAS® software modules, CDISC-SDTM and CDM and also consulting, staffing and service activities

SAS is world’s leading statistical analytical and reporting tool.

Biggest giants of Clinical / Pharmacy, Finance, Banking, Business Analytics, Market Research, etc are looking for SAS professionals, there are in a great demand in our country in other country as well

CLINITEQ is providing internship program in clinical SAS with SDTM

Duration-3 months

ELIGIBILITY :BSc /MSc(LIFE SCIENCE), BPHARMACY/MPHARMACY, BTECH(BIOTECHNOLOGY), MBBS, BDS, PhD



MODULE – 1: SAS

What is SAS;

SAS is a statistical software package that allows the user to manipulate and analyze data in many different ways. It is mostly used reporting tool. Because of its capabilities, this software package is used in many pharma, finance, retail, telecom and many more.

This course will also be conducted over the weekend to assist busy professionals and students to attend it.

Course Highlights:

• Get hands-on knowledge on SAS

• Learn SAS programming concepts as applied in the industry

• Practice on Real-life Industry oriented case studies from Retail, Clinical, and Finance field for practical understanding

• State-of-the-art lab with required software for practicing

• Training by highly experienced industry experts

• Access to the highly qualified instructors to clarify queries after the course

• Excellent course materials, course related publications (soft copies) will be provided

• Completion Certificate upon successful completion of the course

• Resume preparation and mock interviews

• We guide you to clear your SAS certification

SAS software

The latest official version of SAS 9.3 software with all its features is used for training.

MODULE – SAS

INTRODUCTION TO SAS

History of SAS

Terminology of SAS

Introduction to Clinical trails

Topic on real-time SAS programmer work in pharma industry

Guide lines of SAS programming

Protocol, DBMS, SOP, SAP

SAS window environment



SAS program

Components of SAS Programs

Characteristics of SAS Programs

Layout for SAS Programs

Processing SAS Programs

Backend process of SAS (How SAS thinks and works according to commands)

Log messages

Results of processing

Global statements

SAS libraries

How SAS files are stored

Storing files temporarily and permanently

Formats:

Creation of user defined formats and storing them permanently

Using system defined formats

using formats for non-standard data like dates, currency.

Creating Data files or Datasets or Tables

Create temporary and permanent SAS data sets

Create and manipulate SAS date values

Use DATA Step statements to export data to standard and comma delimited raw data files

Control which observations and variables in a SAS data set are processed and output

SAS function:

Round (x, 1); Mean ( ); Put ( ); Input ( ); Lag ( ); Dif ( ); N ( );

NMISS ( ); Log ( ); Int ( ); Weekday ( ); MDY ( , , ); length() compress();

Compbl(); scan(x,1); substr(var,x,y); UPCASE LOWCASE PROPCASE TRIM

Cat

SAS options, global options

SAS data management techniques:

Combining or joining datatsets-

Interleaving

Concatenating

Merging

Updating

Appending

SAS procedure

Proc Sort

Proc Print

Proc Means

Proc Freq

Proc Plot

Proc Chart

Proc Compare

Proc Copy

Proc Summary

Proc Tabulate

Proc Append

Proc Datasets

Proc Delete

Proc Format

Proc Printto

Proc report



SAS/ODS:

Creating Rtf File

Creating Html File

Creating Pdf File

Creating Xml File



Advance SAS :

SAS ORACLE SQL:

Introduction

SQL concepts

Features & Uses

Terminology

Data Types, Key Words, & Operators

Functions, Predicates & Functions

Formatting Output

Group By Clause,

Order By Clause & Having Clause

Case Expression and Conditional Logic.

Creating ,Populating & Deleting Tables

Alter Table Statement

Renaming A Table & Columns

Changing Column’s Length



What is join?

Left join

Right join

Outer join

Inner join

Full join

Comparison between SQL joins and data step combining techniques

What are Integrity Constraints?

What are index? How they are created? How to use them?

Generation of summarized report, customized reports.

Using conditional ‘when’ clause

PTF(Pass through facility)



Advance SAS II :

MACROS

Introduction to macros

Macro variables

User defined macro variables

System defined macro variables

Macro variable references

Macro function

Defining and calling macros

Macro parameters

Batches will start regularly. Weekend and evening batches are going to start.

Additional concepts also added to above If requested.