Clinical SAS Online for Intermediate trainees by Lara Tech

Lara Clinical Research

SAS COURSE CONTENT

Programming I: SAS Essentials

1.1 SAS System Basics

Accessing the SAS System.
Navigating through the SAS windows including the editor, log, and output windows.
Creating and executing SAS programs in batch and interactive mode.
Understanding errors in the SAS log.
Exploring program output.
Understanding SAS data set and library structure.
Creating DATA and PROC steps.
Understanding SAS syntax and SAS naming conventions.
Working with temporary and permanent SAS data sets.

1.2 Creating Reports

Using the REPORT Procedure.
Creating reports in WYSIWYG interactive environment without code
Creating reports in batch environment with code and NOWD
Using COLUMN, DEFINE, and COMPUTE statements for structure
Using ODS to generate HTML, RTF and XML reports
Using Report Options such as WIDTH, FORMAT, DISPLAY, GROUP, HEADLINE and HEARSKIP
Summarizing and sorting reports
Adding titles, footnotes and labels to reports
Using the PRINT procedure
Selecting report columns with the VAR statement
Grouping reports with the BY statement
Summing report columns with the SUM statement
Producing frequency tables using the FREQ procedure

1.3 Creating Graphs

Producing vertical and horizontal bar charts with the GCHART procedure, VBAR and HBAR
Understanding chart variables
Using RUN--group processing for multiple graphs in the same session
Understanding options to tailor graphs, such as DISCRETE, SUMVAR, and TYPE

1.4 Reading SAS Data Sets

Reading data sets with the SET statement
Restricting data set size by selecting variables with DROP= and KEEP= options
Using IF--THEN/ELSE logic processing
Difference between subsetting IF and WHERE clause processing to restrict Observations

1.5 Creating SAS Data Sets
Reading raw data Using list, column and pointer input
Naming variables
Understanding how to read any type of data Using SAS informats
Using INFILE and INPUT statements to read raw data
Examining the structure of SAS data set and its variables attributes using the CONTENTS procedure
Creating new variables using SAS functions and assignment Statements
1.6 Recoding and Reorganizing Data
Using SAS formats to recode data Values for better presentation in reports and analyses
Using the FORMAT procedure to create user defined value labels
Reordering rows of data with the SORT procedure

1.7 Summarizing
Your Data Calculating descriptive statistics with the MEANS and SUMMARY procedures
Grouping data using the CLASS statement
Analyzing data values using the VAR statement and appropriate functions such as SUM, MEAN, MEDIAN and more
Generating one--way and multi--way frequency tables using the FREQ procedure
Using the TABLES statement In the FREQ procedure to specify analysis structure

1.8 Combining SAS Data Sets

Concatenating SAS data sets using the SET statement
Merging multiple SAS data sets on common key variables
Using the SQL procedure
Comparing methods of merging (joining) data sets

Programming II: Data Manipulation Using the Data Step

2.1 Understanding the Data Step

Understanding the difference between compile and execute phases of the Data Step
Learning about Data Step storage areas
Reading and creating multiple SAS data sets.

2.2 Hot Debug Your Program

Learning to Dump the Input Buffer and Program Data Vector with the PUT statement
Using the interactive debugger to understand program logic problems

2.3 Reading External Data Types and Creating Flat File Basics

Reading flat files using delimiters Reading data from relational database
Creating user defined informats for special data and flat files in SAS

2.4 Creating New Variables and Adding Value to Your Data

Cleaning existing data
Assigning new character, numeric and date variables
Using Picture Statements to create user defined formats

2.5 Combining Data Files Using a Match Merging and Interleaving

Match merging multiple SAS data sets together
Interleaving SAS data sets with the SET statement
ChangingvariabletypesusingthePUTandINPUTfunctionsSummarizingData Files
Summarizing data in the data step using Sum and Retain statements
Creating group totals with First and Last processing
Creating summary data sets with Proc Summary
Selecting specification summarization hierarchies using the _TYPE_ Variable

2.6 Perform Iterative processing on Data

Using DO loops for repetitive calculations and processing
Using Arrays to process across an observation
Using DO WHILE and DO UNTIL statements for conditional looping
Creating simple random sample

2.7 Producing Exception Reports

Using WHERE statement to subset data
Using contribution option to perform table lookups when merging files
Identifying duplicate rows of data infile

3 Advance Macros

Introduction to Marcos
Macro Compilations
Defining Global & Local Macro variables
Macro options, Expressions
%Put, %Let, %IF, %Else, %Do, %End
Creating Macros Programs