Advance Certificate course in SAS

Basic SAS / Advance SAS / Clinical SAS overview

Structure of course:

Base SAS:

• Basic Concepts
  SAS Windows, Step boundaries, Submitting programs
  Self-study: Help facility familiarization
• SAS Syntax
  Identifying keyword, Syntax Rules, SAS Comments, SAS errors types , SAS errors identifying and correcting
  Referencing Files and Setting Options
  Descriptor and data portion, Proc print, Proc contents
  SAS Variable names, types and its attributes, SAS Date, Missing data values
  SAS Libraries
• Creating SAS Data Sets from Raw Data
  TXT, CSV
  EXCEL
  Data step and delimited source files
• Editing and Debugging SAS Programs

Drop, Keep statements

Data step statements

Where statement operators

Adding permanent attributes

Creating new variables

Sas functions

Creating and enhancing Reports

Understanding DATA Step Processing
Input buffer and PDV
Conditional programming, do loop, arrays

• Creating and Applying User-Defined
• Combining datasets
• Global statements
• Graphs
• Different procedures
  Proc Sort, proc print, Proc Contents
  Proc freq, Proc Means, proc univariate, Proc Summary, Proc tabulate, Proc report

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

• Use macro variable name delimiter. (.)
• Use INTO clause of the SELECT statement in SQL to create a single variable or a list of variables.
• Use the SYMPUTX routine in a DATA Step to create a single variable or a list of variables.
  Control variable scope with: o %GLOBAL statement
• %LOCAL statement
• SYMPUTX scope parameter
• Automate programs by defining and calling macros using the SAS Macro Language.
• Define a macro using the %MACRO and %MEND statements.
• Calling a macro with and without parameters.
• Document macro functionality with comments
• Generate SAS Code conditionally by using the %IF-%THEN-%ELSE macro statements or iterative %DO statements.
• Use the SAS AUTOCALL facility to permanently store and call macros.
• Use macro functions.
• Debug macros.

SAS SQL

• Use PROC SQL to perform SQL queries.
• Select columns in a table with a SELECT statement and FROM clause.
• Create a table from a query result set.
• Create new calculated columns.
• Assign an alias with the AS keyword.
• Use case logic to select values for a column.
• Retrieve rows that satisfy a condition with a WHERE clause.
• Subset data by calculated columns.
  Join tables - inner joins, full joins (coalesce function), right joins, left joins.
• Combine tables using set operators - union, outer union, except, intersect.
• Sort data with an ORDER BY clause.
• Assign labels and formats to columns.

Clinical Domain

• Phases of clinical trials
• Type of clinical trials
• Important documents
• Overview of data flow
• Overview of SDTM / ADaM standards
• Important domains for interview
• Roles and responsibilities

 Best and focused training by experienced professionals
 Dummy software, Session data, Practice data will be provided
 Clinical SAS Job oriented and Interview focused preparation
 Interview preparation and assistance
 Soft copy of Books will be provided
 Base SAS preparation guide
 Advanced SAS preparation guide
 CDISC standards SDTM ADaM implementation guide

Applicant should have done B.Sc, M.Sc, B.Pharm, M.Pharm, Pharm D, Medical science.