Clinical Data Management

Currency:

Why this course ?

  • This Hands-On course on Clinical Data Management and SAS Program is developed to provide candidates with a skillful knowledge of the management of clinical data
  • The course cover everything from manipulating data to writing SAS programs
  • This Course will help to prepare you for the Base SAS Programming certification exam.
  • This course cover Processing SAS data using Structured Query Language (SQL).

Classroom Or Online

Program Duration
and Fees

Buy Now

Duration

65 Hours

Price

24990

Description

Introduction to the SQL Procedure
o What is SQL?
o What is the SQL Procedure?
o Terminology
o Comparing PROC SQL with the SAS DATA step
o Note about the Example Table


Retrieving Data From a Single Table
o Overview of the select Statement
o Selecting Columns in a Table
o Creating New Columns
o Sorting Data
o Retrieving rows that satisfy a Condition
o Summarizing Data
o Grouping Data
o Filtering Grouped Data

Retrieving Data from Multiple Tables
o Introduction
o Selecting Data from More Than One Table by Using joins
o Using Subqueries to Select Data
o When to Use Joins and Subqueries
o Combining Queries with Set Operators

Creating and Updating Tables and Views
o Introduction
o Creating Tables
o Inserting Rows into Tables
o Updating Data Values in a Table
o Deleting Rows
o Altering Columns
o Creating an Index
o Deleting a Table
o Using SQL Procedure Tables in SAS Software
o Creating and Using Integrity Constraints in a Table
Programming with the SQL Procedure
o Introduction
o Using Proc SQL Options to Create and Debug Quires
o Improving Query Performance
o Accessing SAS System Information Using DICTIONRY Tables
o Using Proc SQL with the SAS Macro Facility
o Formatting PROC SQL output Using the Report Procedure
o Accessing a DBMS with SAS/ACCESS Software

Practical Problem-Solving with PROC SQL
o Overview
o Computing a Weighted Average
o Comparing Tables
o Overlaying Missing Data Values
o Computing Percentages within Subtotals
o Counting Duplicate Rows in a Table
o Expanding Hierarchical Data in a Table
o Summarizing Data in Multiple Columns
o Creating a Summary Report
o Creating a Customized Sort Order
o Conditionally Updating a Table
o Updating a Table with Values from Another Table
o Creating and Using Macro Variables
SAS Programing II

Chapter-1
Introduction

1.1 Overview
1.2 Review of SAS basics
1.3 Review of DATA Step Processing
1.4 Review of Displaying SAS Data Sets
1.5 Working with Existing SAS Data Sets

Chapter-2
Controlling Input and Output
2.1 Outputting Multiple Observations
2.2 Writing to Multiple SAS Data Sets
2.3 Selecting Variables and Observations
2.4 Writing to an External File

Chapter-3
Summarizing Data
3.1 Creating an Accumulating Total variable
3.2 Accumulating Totals for a Group of Data

Chapter-4
Reading & Writing Different Types of Data
4.1 Reading Delimited Raw Data Files
4.2 Controlling When a Record Loads
4.3 Reading Hierarchical Raw data Files
Chapter-5
Data Transformations
5.1 Introduction
5.2 Manipulating Character values
5.3 Manipulating Numeric values
5.4 Manipulating Numeric values based on Dates
5.5 Converting variable Type

Chapter-6
Debugging Techniques
6.1 Using the PUT Statement
6.2 Using the DEBUG Option

Chapter-7
Processing Data Iteratively
7.1 Do Loop Processing
7.2 SAS Array Processing
7.3 Using SAS Arrays

Chapter-8
Combining SAS® Data Sets
8.1 Match-merging Two or more SAS Data Sets
8.2 Simple Joins Using the SQL Procedure
SAS ESSENTIALS : Programing-I
Chapter-1
Introduction
1.1 An Overview of the SAS System
Chapter-2
Getting Started With the SAS® System
2.1 Introduction to SAS Programs
2.2 Running SAS Programs
2.3 Mastering Fundamental Concepts
2.4 Diagnosing and Correcting Syntax Errors
2.5 Exploring Your SAS Environment
Chapter-3
Getting familiar with SAS Data Sets
3.1 SAS Data Libraries
Chapter-4
Producing List Report
4.1 Getting Started With the PRINT Procedure
4.2 Sequencing and Grouping Observations
4.3 Identifying Observations
4.4 Special WHERE Statement Operators

Chapter-5
Enhancing Output
5.1 Customizing Report Appearance
5.2 formatting Data Values
5.3 Creating HTML Reports
Chapter-6
Creating SAS® Data Sets
6.1 Reading Raw Data Files: Column Input
6.2 Reading Raw Data Files: Formatted Input
6.3 Examining Data Errors

6.4 Assigning Variable Attributes
6.5 Changing Variable Attributes
6.6 Reading Excel Spreadsheets
Chapter-7
DATA Step Programming
7.1 Reading SAS Data Sets and Creating Variables
7.2 Conditional Processing
7.3 Dropping and Keeping Variables
7.4 Reading Excel Spreadsheets Containing Date Fields

Chapter-8
Combining SAS Data Sets
8.1 Concatenating SAS Data Sets
8.2 Merging SAS Data Sets
8.3 Combining SAS Data Sets : Additional Features
Chapter-9
Producing Summary Reports
9.1 Introduction of Summary Reports.
9.2 Basic Summary Reports
9.3 The Report Procedure
9.4 The Tabulate Procedure
Chapter-10
Introduction to Graphics
10.1 Producing Bar and pie Chart
10.2 Enhancing output
10.3 Producing Plots
• SAS Macro Overview
• SAS Macro Variables
• Scope of Macro variables
• Defining SAS Macros
• Inserting Comments in Macros
• Macros with Arguments
• Conditional Macros
• Macros Repeating PROC Execution
• Macro Language
• SAS Macro Processor

Base SAS

Learners

Testimonials

×

Checkout

Course Name: Clinical Data Management

24990