SAS Clinical Data Management

▪ the SAS programming process

▪ using SAS programming tools

▪ discussing the course environment and scenario

▪ understanding SAS data

▪ accessing data through libraries

▪ importing data into SAS

▪ exploring data

▪ filtering rows

▪ formatting columns

▪ sorting data and removing duplicates

▪ reading and filtering data

▪ computing new columns

▪ conditional processing

▪ enhancing reports with titles, footnotes, and labels

▪ creating frequency reports

▪ creating summary statistics reports

▪ exporting data

▪ exporting reports

▪ using Structured Query Language in SAS

▪ joining tables using SQL in SAS

▪ setting up for this course

▪ understanding DATA step processing

▪ directing DATA step output

▪ creating an accumulating column

▪ processing data in groups

▪ understanding SAS functions and CALL routines

▪ using numeric and date functions

▪ using character functions

▪ using special functions to convert column type

▪ creating and using custom formats

▪ creating custom formats from tables

▪ concatenating tables

▪ merging tables

▪ identifying matching and nonmatching rows

▪ using iterative DO loops

▪ using conditional DO loops

▪ restructuring data with the DATA step

▪ restructuring data with the TRANSPOSE procedure

▪ overview of SAS Foundation

▪ course logistics

▪ course data files

▪ purpose of the macro facility

▪ program flow

▪ introduction to macro variables

▪ automatic macro variables

▪ macro variable references

▪ user-defined macro variables

▪ delimiting macro variable references

▪ macro functions

▪ defining and calling a macro

▪ macro parameters

▪ creating macro variables in the DATA step

▪ indirect references to macro variables

▪ creating macro variables in SQL

▪ conditional processing

▪ parameter validation

▪ iterative processing

▪ global and local symbol tables

▪ SAS resources

▪ beyond this course

▪ program flow

▪ overview of SAS Foundation

▪ course logistics

▪ course data files

▪ introducing the Structured Query Language

▪ overview of the SQL procedure

▪ specifying columns

▪ specifying rows

▪ presenting data

▪ summarizing data

▪ introduction to SQL joins

▪ inner joins

▪ outer joins

▪ complex SQL joins

▪ noncorrelated subqueries

▪ in-line views

▪ introduction to set operators

▪ the UNION operator

▪ the OUTER UNION operator

▪ the EXCEPT operator

▪ the INTERSECT operator

▪ creating tables with the SQL procedure

▪ creating views with the SQL procedure

▪ dictionary tables and views

▪ using SQL procedure options

▪ interfacing PROC SQL with the macro language

▪ SAS resources

▪ beyond this course

▪ overview of SAS Foundation

▪ course logistics

▪ creating the course data

▪ identifying computer resources related to efficiency

▪ SAS DATA step processing

▪ controlling I/O

▪ reducing the length of numeric variables

▪ compressing SAS data sets

▪ using SAS views

▪ access methods

▪ accessing observations by number

▪ creating an index

▪ using an index

▪ introduction to lookup techniques

▪ one-dimensional arrays

▪ multidimensional arrays

▪ loading a multidimensional array from a SAS data set

▪ introduction

▪ hash object methods

▪ loading a hash object from a SAS data set

▪ DATA step hiter object

▪ DATA step merges and SQL procedure joins

▪ using an index to combine data

▪ combining summary and detail data

▪ combining data conditionally

▪ user-defined functions

▪ user-defined formats

▪ areas of support from SAS

▪ other courses to consider

▪ combining raw data files vertically