SAS

Reading Time: 3 minutes

SAS

  • Introduction of SAS software.
  • Industries using SAS
  • Components of SAS System.
  • Architecture of SAS system.
  • Functionality of SAS System.
  • Introduction of SAS windows

Module 1 : 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.

Module 2 : 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.

Module 3 : Output delivery system

  • Concepts of output delivery system.
  • How ODS works and viewing output of ODS in different format.
  • HTML, RTF, PDF etc..

Module 4 : Combination the dataset

  • One-o-one reading
  • One to many
  • Many to many
  • Concatenation
  • Interleaving,
  • Match merge

Module 5 : Functions

  • Character function
  • Numerical function
  • Arithmetical function
  • Mathematical function
  • Date Function

Module 6 : Loops in SAS: Do Loops

  • Do Loop
  • Do While
  • Do Until

Module 7 : Array

  • Definition of array
  • Example of array

Module 8 : 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.

Module 9 : GRAPHS

  • Introduction to graphics.
  • Introduction to graphics.
  • Types of Graphics (with latest models)
  • Defining procedure Graphics

Advance SAS Topic

    Module 10 : 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.

    Module 11 : 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.

    Module 12 : 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?

    Module 13 : 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.

    Module 14 : 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.