SAS Online Training

SAS Online Training Course is meticulously designed to provide a comprehensive understanding of Basic SAS Programming. SAS Training begins with the emphasis on the features and capabilities of SAS. At Cheyat Technologies, We cover concepts required to perform day to day work in the professional world.

SAS Online Training Course content

BASE SAS

Introduction To SAS System & Architecture
History And Various Modules
Features, Variables & SAS Syntax Rules
SAS Data Sets, Options
Operators, Input Styles
Reading Raw Data
In file Statement With Options
Working With External Files & Options
Creating & Redefining Variables
Where Statement
Conditional statements
Stop And Error Statements
Output Statement, Put Statement
Modifying And Combining Data Sets
Updating Master Data Set
Display Manager Commands
SAS Functions

BASE SAS PROCEDURES

Proc Tabulate
Proc transpose
Proc Contents
Proc Print
Proc Means
Proc Format
Proc Freq
Proc rank
Proc sort
Proc Summary
Proc Import, Export
Proc Append
Proc Plot
Copy, Datasets, Delete

SAS/ACCESS

Working With Oracle
Working With Ms-Access
Working With Ms-Excel
DBLoad Procedure

SAS/GRAPH/charts

Gchart Procedure
Vertical, Horizontal, Pie
Group, Subgroups
Gplot Procedure
Multiple Plots & Overlay
Symbol Statement
Title And Footnote Statements

SAS/ODS

Creating Rtf File,Creating Html File,PDF File

SAS/REPORTS

Frequency Report
One-Way Frequency Report
Cross Tabular Frequency Report
Summary Statistics
Creating A List Report
Order Usage and Group
Printing Grand Totals
Rbreak Statement
Tabulate Procedure
One-Dimensional Tables
Two-Dimensional Tables
Obtaining A Total
Analysis Variables with options
Summary Statistics

SAS Database:SAS -SQL

ORACLE-SQL CONCEPTS

Introduction
History
Features
Sql Command Set
Operators In Sql
Order By Clause
Group By Clause
Having Clause
Distinct Clause
Create and Insert
Deleting, Populating And Updating
Joins, import & export

SAS/SQL

Introduction To SAS/Sql
Features, Uses
Data Types, Key Words, & Operators
Functions, Formatting Output
Group By Clause
Order By Clause
Having Clause
Case Expression And Conditional Logic.
Creating, Populating & Deleting Tables
Alter Table Statement
Changing Column's Length
Joins
Constraints
Renaming A Table & Columns
Views

SAS/MACROS

ADVANCE TOPICS IN SAS

PERFORMING ADVANCED QUERIES USING PROC SQL
INTRODUCING MACRO VARIABLES
CREATING AND USING MACRO PROGRAMS
STORING MACRO PROGRAMS
CREATING SAMPLES AND INDEXES
USING LOOKUP TABLES TO MATCH DATA
MODIFYING SAS DATA SETS AND TRACKING CHANGES

SAS Clinical

Introduction of SAS software.

Industries using SAS

Components of SAS System.

Architecture of SAS system.

Functionality of SAS System.

Introduction of SAS windows

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.

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.

Automatic variables

Use of automatic variables.
Types of automatics variables.
Use of _N_, _ERROR_, _NULL_.
Testing your programs.
Using put statement.
Automatic Variable.

Output delivery system

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

Combination the dataset

Oneoone reading
One to many
Many to many
Concatenation
Interleaving
Match merge

Functions

Character function
Numerical function
Arithmetical function
Mathematical function
Date Function

Sampling method

Random sampling

Loops in SAS: Do Loops Loops are used to iterate through every observation for specified numberof times to obtain a desired result

Types of Loops:

Do Loop
Do While
Do Until
Default increments by 1
Can use BY to increment by any value other than 1

Array

Definition of array
Example of array

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.

GRAPHS

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

Advance SAS Topic

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 subqueries and inline views within an SQL procedure step.
Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques.

Macro

Create and use userdefined 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.

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?

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.

Statistic and Report Clinical Trials Results

Use SAS procedures to obtain descriptive statistics for clinical trials data (FREQ, UNIVARIATE, MEANS, SUMMARY).
Use PROC FREQ to obtain pvalues for categorical data (2×2 and NxP test for association).
Use PROC TTEST to obtain pvalues for continuous data (one sample paired and two sample t-tests).
Create output data sets from statistical procedures.
Using ODS with PROC REPORT and PROC TABULATE to generate nice looking tables and listings
Producing Bar and Pie charts using PROC GPLOT and PROC GCHART

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.

SAS Online Training

SAS Online Training

Popular Online Courses

Door No: 40-17-3/3, 2nd Floor,

trainings@cheyat.com