Clinical Data Management

+91 9830247087

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).

Buy Now

Weekend/Weekday|Live Classes 25% OFF

Program Duration
and Fees

Buy Now

Duration

65 Hours

Price

24990

Description

Writing SAS programs

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

Manipulating and summarizing data using SAS procedures.

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 MACROS

• 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

Processing SAS data using Structured Query Language (SQL).

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

Testimonials

Bhushan Kumar

I have learn SAS,R, Python, Machine Learning from Hands-On System. It's been a long journey with excellent experience.

Vishal Jaiswal

Very good institute with trainer having pretty good technical knowledge. Live online course delivery process is nice, recommended for sure.

Priti Basu

I am happy with the data science training.The training given by faculties are really very much helpful.

Harmandeep Kaur

I have been trained here for Data Science with Python and R. Its very good training with industry expert.

Partha Roy

I have completed my Python Training the Trainer thought me very well. Thanks to Hands-On System.

Ajanta Konar

I joined Hands-On System to learn Digital Marketing,all what i can say at the end You will have enough knowledge.

Prakash

Glad to have Digital Marketing training here.Faculty here is very helpful and are well knowledgeable.Glad with my training experience here!

Vijoy Agarwal

I took Python and Machine Learning classes from Hands-On System. My teacher was really good.i found it really helpful.

Sumit Sen

Excellent live online teaching. Trainer is very friendly and kind to us.Best training institute for SAS Training.

Bidisha Paul

I had done Data science Course from Hands-On System , these classes was very helpful and enlightening.

Sayan Basu

I was worried about online training, but after attending the Hands-On live online Certificate course in R programming, my concept changed. It is fully practical and interactive. Really helpful instructor.

Priyanka Roy

Good Trainer. Have good teaching skill set. I personally recommend people to join Hands-On System.

Kopil Strivastava

Great to do if, you want to dive into data science or machine learning. It is a must do, if you have no idea of statistics and data science you can do this course

Paramita Banerjee

Hands-On Certificate in Digital Marketing course exceeded my expectations. Enjoyed the class.

Bhaskar Gupta

Trainers are very calm and knowledgeable, thank you very much to Hands-On System.Really enjoyed and look forward to learning more in the future. Well structured data science course with all the popular software Python,SAS and R and well organised.I found the course very good and learnt a lot that has benefitted my role in work.

Kallol Sengupta

I have attended the Live online Certificate in Digital Marketing course.My Instructor demonstrated the entire course thoroughly with practical case studies. I really enjoyed the course.

David Smith

Highly recommended if you want to learn or improve your Data Science skill. This course is fantastic -- the concepts & methods that are directly applicable to my field. The numerous examples and case studies are really useful for understanding all the concepts. The instructor is very good and shares her knowledge at a good pace.For the value, the course was worth every penny and more.

Manisha

Data Science course explained in detail and with examples.great case studies which helped me to understand more easily.

Sumitava Maji

The course structure is very good and useful for the student.

Soumen Lahiri

I have completed Data Science course from Hands-On System. It is really a great experience.