SAS_Clinical-Regular Training

SAS Clinical Regular Course Syllabus

Chapter 1: INTRODUCTION TO SAS

1. INTRODUCTION
2. NEED FOR SAS
3. WHO USES SAS
4. WHAT IS SAS?
5. OVERVIEW OF BASE SAS SOFTWARE
6. DATA MANAGEMENT FACILITY
7. STRUCTURE OF SAS DATASET
8. SAS PROGRAM
9. PROGRAMMING LANGUAGE
10. ELEMENTS OF THE SAS LANGUAGE
11. RULES FOR SAS STATEMENTS
12. RULES FOR MOST SAS NAMES
13. SPECIAL RULES FOR VARIABLE NAMES
14. TYPES OF VARIABLES
15. DATA ANALYSIS AND REPORTING UTILITIES
16. TRADITIONAL OUTPUT
17. WAYS TO RUN SAS PROGRAMS
18. SAS WINDOWING ENVIRONMENT
19. NONINTERACTIVE MODE
20. BATCH MODE
21. INTERACTIVE LINE MODE
22. RUNNING PROGRAMS IN THE SAS WINDOWING ENVIRONMENT



Chapter 2: HOW SAS WORKS

1. Chapter 2: HOW SAS WORKS
2. A SIMPLE PROGRAM TO READ RAW DATA AND PRODUCE A REPORT
3. ENHANCING THE PROGRAM
4. MORE ON COMMENT STATEMENTS
5. INTERNAL PROCESSING IN SAS
6. HOW SAS WORKS
7. THE COMPILATION PHASE
8. THE EXECUTION PHASE
>
9. PROCESSING A DATA STEP: A WALKTHROUGH
10. CREATING THE INPUT BUFFER AND THE PROGRAM DATA VECTOR
11. WRITING AN OBSERVATION TO THE SAS DATA SET
12. FOUR TYPES OF SAS LIBRARIES
13. SAS LIBRARIES
14. WORK LIBRARY
15. SASHELP LIBRARY
16. SASUSER LIBRARY



Chapter 3: READING RAW DATA INTO SAS

1. WHAT IS RAW DATA
2. DEFINITIONS
3. DATA VALUES
4. NUMERIC VALUE
5. CHARACTER VALUE
6. STANDARD DATA
7. NONSTANDARD DATA
8. NUMERIC DATA
9. CHARACTER DATA
10. CHOOSING AN INPUT STYLE
11. LIST INPUT
12. MODIFIED LIST INPUT
13. COLUMN INPUT
14. FORMATTED INPUT
15. NAMED INPUT
16. INSTREAM DATA
17. CREATING MULTIPLE RECORDS FROM SINGLE INPUT ROW
18. READING DATA FROM EXTERNAL FILES
19. READING BLANK SEPARATED VALUES (LIST OR FREE FORM DATA):
20. READING RAW DATA SEPARATED BY COMMAS (.CSV FILES):
21. READING IN RAW DATA SEPARATED BY TABS (.TXT FILES):
22. SUPPLYING AN INFORMAT STATEMENT WITH LIST INPUT
23. USING LIST INPUT WITH EMBEDDED DELIMITERS
24. READING RAW DATA THAT ARE ALIGNED IN COLUMNS:
25. METHOD 1: COLUMN INPUT
26. METHOD 2: FORMATTED INPUT
27. USING MORE THAN ONE INPUT STATEMENT: THE SINGLE TRAILING @
28. READING COLUMN DATA THAT IS ON MORE THAN ONE LINE
29. MIXED-STYLE INPUT:
30. INFILE OPTIONS FOR SPECIAL SITUATIONS
31. FLOWOVER
32. MISSOVER
33. TRUNCOVER
34. PAD
35. USING LRECL TO READ VERY LONG LINES OF RAW DATA
36. CHECKING YOUR DATA AFTER IT HAS BEEN READ INTO SAS



Chapter 4: READING DATA FROM A DATASET

1. INTRODUCTION
2. SET STATEMENT OVERVIEW
3. AUTOMATIC VARIABLES IN SAS
4. INTERLEAVE MULTIPLE SAS DATA SETS
5. COMBINE MULTIPLE SAS DATA SETS
6. CREATING & MODIFYING VARIABLES
7. CREATING MULTIPLE DATASETS IN A SINGLE DATA-STEP
8. SUBSETTING OBSERVATIONS
9. CONDITIONAL SAS STATEMENTS
10. LOGICAL AND SPECIAL OPERATORS
11. THE SAS SUPERVISOR AND THE SET STATEMENT
12. EFFICIENCY AND THE SET STATEMENT
13. KNOW YOUR DATA
14. SET STATEMENT DATA SET OPTIONS
15. DROP AND KEEP OPTIONS
16. RENAME OPTION
17. FIRSTOBS AND OBS OPTIONS
18. IN OPTION -
19. WHERE OPTION -
20. OTHER SET STATEMENT OPTIONS
21. END OPTION
22. NOBS OPTION
23. POINT OPTION
24. DO LOOPS AND THE SET STATEMENT
25. INTRODUCTION TO RETAIN STATEMENT
26. CARRY OVER VALUES FROM ONE OBSERVATION TO ANOTHER
27. COMPARE VALUES ACROSS OBSERVATIONS
28. ASSIGN INITIAL VALUES
29. DETERMINING COLUMN ORDER IN OUTPUT DATASET
30. SAS SYSTEM OPTIONS



Chapter 5: READING DATA FROM A DATASET

1. INPUT SAS DATA SET FOR EXAMPLE
2. SELECTING OBSERVATIONS FOR A NEW SAS DATA SET
3. DELETING OBSERVATIONS BASED ON A CONDITION
4. ACCEPTING OBSERVATIONS BASED ON A CONDITION
5. COMPARING THE DELETE AND SUBSETTING IF STATEMENTS
6. METHODS OF CREATING NEW DATA SETS WITH A SUBSET
7. SUBSETTING RECORDS FROM AN EXTERNAL FILE WITH A SUBSETTING IF STATEMENT
8. SUBSETTING OBSERVATIONS IN A DATA STEP WITH A WHERE STATEMENT
9. SUBSETTING OBSERVATIONS IN A PROC STEP WITH A WHERE STATEMENT
10. SUBSETTING OBSERVATIONS IN PROC SQL
11. DIFFERENCE BETWEEN IF AND WHERE



Chapter 6: SAS INFORMATS AND FORMATS

1. OVERVIEW
2. USING SAS INFORMATS
3. INPUT STATEMENT
4. INPUT FUNCTION
5. INPUTN AND INPUTC FUNCTIONS
6. ATTRIB AND INFORMAT STATEMENTS
7. USING SAS FORMATS
8. FORMAT STATEMENT IN PROCEDURES
9. PUT STATEMENT
10. PUT FUNCTION
11. PUTN AND PUTC FUNCTIONS
12. BESTw. Format
13. ADDITIONAL COMMENTS



Chapter 7: SAS FUNCTIONS

1. CATEGORIES OF FUNCTIONS
2. SAS CHARACTER FUNCTIONS
3. UPCASE
4. LOWCASE
5. PROPCASE
6. FUNCTIONS THAT REMOVE CHARACTERS FROM STRINGS
7. FUNCTION: COMPBL
8. FUNCTION: COMPRESS
9. FUNCTIONS THAT SEARCH FOR CHARACTERS
10. FUNCTION: ANYALNUM
11. FUNCTION: ANYALPHA
12. FUNCTION: ANYDIGIT
13. FUNCTION: ANYPUNCT
14. FUNCTION: ANYSPACE
15. FUNCTION: NOTALNUM
16. FUNCTION: NOTALPHA
17. FUNCTION: NOTDIGIT
18. FUNCTION: NOTUPPER
19. FUNCTIONS THAT SEARCH STRINGS
20. FIND AND FINDC
21. INDEX, INDEXC, AND INDEXW
22. FUNCTIONS TO VERIFY DATA
23. FUNCTION VERIFY
24. FUNCTIONS THAT EXTRACT PARTS OF STRINGS
25. FUNCTION: SUBSTR (ON THE LEFT-HAND SIDE OF THE EQUAL SIGN)
26. FUNCTION: SUBSTRN
27. FUNCTIONS THAT JOIN TWO OR MORE STRINGS TOGETHER
28. FUNCTION: CAT
29. FUNCTION: CATS
30. FUNCTION: CATT
31. FUNCTION: CATX
32. FUNCTIONS THAT REMOVE BLANKS FROM STRINGS
33. FUNCTION: LEFT
34. FUNCTION: RIGHT
35. FUNCTION: TRIM
36. FUNCTION: TRIMN
37. FUNCTION: STRIP
38. FUNCTIONS THAT COMPARE STRINGS
39. FUNCTION: COMPARE
40. FUNCTIONS THAT DIVIDE STRINGS INTO "WORDS"
41. FUNCTION: SCAN
42. FUNCTION: SCANQ
43. FUNCTIONS THAT SUBSTITUTE LETTERS OR WORDS IN STRINGS
44. FUNCTION: TRANSLATE
45. FUNCTION: TRANWRD
46. FUNCTIONS THAT COMPUTE THE LENGTH OF STRINGS
47. FUNCTION: LENGTH
48. FUNCTION: LENGTHC
49. FUNCTION: LENGTHM
50. FUNCTIONS THAT COUNT THE NUMBER OF LETTERS OR SUBSTRINGS IN A STRING
51. FUNCTION: COUNT
52. FUNCTION: COUNTC
53. MISCELLANEOUS STRING FUNCTIONS
54. FUNCTION: MISSING
55. FUNCTION: REPEAT
56. FUNCTION: REVERSE
57. SAS DATE AND TIME FUNCTIONS
58. INTRODUCTION
59. WHAT IS A SAS DATE AND TIME LITERAL?
60. DATE AND TIME FUNCTIONS
61. FUNCTINS TO CREATE DATE AND TIME VALUES
62. FUNCTIONS TO TAKIE DATETIME VALUES APART
63. FUNCTIONS TO GET QUARTER ,YEAR OR DAY OF THE DATE
64. FUNCTIONS THAT WORK WITH INTERVALS
65. USING FORMATS FOR DATE AND TIME
66. SYSTEM OPTIONS FORDATE AND TIME



Chapter 8: AN INTRODUCTION TO ARRAYS AND ARRAY PROCESSING

1. WHY DO WE NEED ARRAYS?
2. BASIC ARRAY CONCEPTS
3. ARRAY STATEMENT
4. ARRAY REFERENCES
5. VARIABLE NAME ARRAY REFERENCE
6. USING ARRAY INDEXES
7. ONE DIMENSION ARRAYS
8. MULTI-DIMENSION ARRAYS
9. TEMPORARY ARRAYS
10. SORTING ARRAYS
11. Determining Array Bounds: LBOUND and HBOUND Functions
12. WHEN TO USE ARRAYS
13. COMMON ERRORS AND MISUNDERSTANDINGS
14. INVALID INDEX RANGE
15. FUNCTION NAME AS AN ARRAY NAME
16. ARRAY REFERENCED IN MULTIPLE DATA STEPS, BUT DEFINED IN ONLY ONE



Chapter 9: BY - GROUP PROCESSING

1. DEFINITIONS FOR BY-GROUP PROCESSING
2. BY-GROUP PROCESSING
3. BY VALUE
4. BY GROUP
5. FIRST.VARIABLE AND LAST.VARIABLE
6. MODIFYING SAS DATA SETS: EXAMPLES
7. INVOKING BY-GROUP PROCESSING
8. REPROCESSING INPUT DATA FOR BY-GROUP PROCESSING
9. SORTING OBSERVATIONS FOR BY-GROUP PROCESSING
10. INDEXING FOR BY-GROUP PROCESSING
11. HOW THE DATA STEP IDENTIFIES BY GROUPS
12. PROCESSING OBSERVATIONS IN A BY GROUP
13. HOW SAS DETERMINES FIRST.VARIABLE AND LAST.VARIABLE
14. PROCESSING BY-GROUPS IN THE DATA STEP
15. OVERVIEW
16. PROCESSING BY-GROUPS CONDITIONALLY
17. DATA NOT IN ALPHABETIC OR NUMERIC ORDER
18. DATA GROUPED BY FORMATTED VALUES



Chapter 10: OVERVIEW OF METHODS FOR COMBINING SAS DATA SETS

1. DEFINITIONS
2. CONCATENATING
3. INTERLEAVING
4. ONE-TO- ONE READING OR ONE-TO-ONE MERGING
5. MATCH-MERGING
6. UPDATING
7. MODIFYING
8. DEFINITIONS FOR READING, COMBINING, AND MODIFYING SAS DATA SETS
9. READING A SAS DATA SET
10. COMBINING SAS DATA SETS
11. MODIFYING SAS DATA SETS
12. OVERVIEW OF TOOLS
13. READING SAS DATA SETS
14. READING A SINGLE SAS DATA SET
15. READING FROM MULTIPLE SAS DATA SETS
16. COMBINING SAS DATA SETS: BASIC CONCEPTS
17. ONE-TO-ONE
18. ONE-TO-MANY AND MANY-TO-ONE
19. MANY-TO-MANY
20. ACCESS METHODS: SEQUENTIAL VERSUS DIRECT
21. SEQUENTIAL ACCESS
22. DIRECT ACCESS
23. ONE-TO-ONE READING
24. DATA STEP PROCESSING DURING A ONE-TO-ONE READING
25. ONE-TO-ONE MERGING
26. MATCH-MERGING
27. UPDATING WITH THE UPDATE AND THE MODIFY STATEMENTS :
28. DEFINITIONS
29. SYNTAX OF THE UPDATE STATEMENT
30. SYNTAX OF THE MODIFY STATEMENT -
31. UPDATING WITH NONMATCHED OBSERVATIONS, MISSING VALUES, AND NEW VARIABLES -
32. USING AN INDEX WITH THE MODIFY STATEMENT

Chapter 11: SAS PROCEDURES

1. INTRODUCTION
2. THE ANATOMY OF A PROC
3. THE PROC STATEMENT
4. TITLE AND FOOTNOTE STATEMENTS
5. BY STATEMENT
6. LABEL STATEMENT
7. FORMAT STATEMENT
8. RUN OR QUIT STATEMENT
9. DESCRIPTION OF DATA USED IN REPORTS
10. SAS REPORTING PROCEDURES
11. PROCS FOR ALL THAT DETAIL
12. USING PROC PRINT
13. USING PROC SQL
14. PROC REPORT
15. PROCS THAT SUMMARIZE
16. USING PROC CHART
17. USING PROC FREQ
18. USING PROC MEANS
19. USING PROC UNIVARIATE
20. INTRODUCTION TO PROC TABULATE
21. DATA MANIPULATION AND MANAGEMENT PROCEDURE
22. PROC SORT
23. PROC DATASETS
24. PROC FORMAT
25. PROC CONTENTS
26. OTHER IMPORTANT PROCS
27. PROC TRANSPOSE
28. DEFINITIONS
29. PROC PRINTTO
30. COMPARE PROCEDURE
31. PROC APPEND
32. HOW TO IMPORT AN EXCEL FILE INTO SAS

Chapter 12: INTRODUCTION TO PROC SQL

1. INTRODUCTION
2. WHY LEARN PROC SQL?
3. SELECT STATEMENT
4. THE SELECT STATEMENT SYNTAX
5. A SIMPLE PROC SQL
6. A COMPLEX PROC SQL
7. LIMITING INFORMATION ON THE SELECT
8. CREATING NEW VARIABLES
9. USING LABELS AND FORMATS
10. THE CASE EXPRESSION ON THE SELECT
11. ADDITIONAL SELECT STATEMENT CLAUSES
12. REMERGING
13. REMERGING FOR TOTALS
14. CALCULATING PERCENTAGE
15. SORTING THE DATA IN PROC SQL
16. SORT ON NEW COLUMN
17. SUBSETTING USING THE WHERE
18. INCORRECT WHERE CLAUSE
19. WHERE ON COMPUTED COLUMN
20. SELECTION ON GROUP COLUMN
21. USE HAVING CLAUSE
22. CREATING NEW TABLES
23. JOINING DATASETS USING PROC SQL
24. INNER JOIN
25. JOINING THREE OR MORE TABLES
26. OUTER JOINS
27. INCLUDING NONMATCHING ROWS WITH THE RIGHT OUTER JOIN
28. SELECTING ALL ROWS WITH THE FULL OUTER JOIN
29. CONCATENATING QUERY RESULTS
30. COMPARE PROCEDURE
31. PROC APPEND
32. HOW TO IMPORT AN EXCEL FILE INTO SAS

Chapter 13: AN INTRODUCTION TO SAS MACROS

1. INTRODUCTION
2. SAS MACRO OVERVIEW
3. TRADITIONAL SAS PROGRAMMING
4. THE SAS MACRO LANGUAGE
5. MACRO LANGUAGE COMPONENTS
6. MACRO VARIABLES
7. MACRO STATEMENTS
8. MACRO PROCESSOR FLOW
9. AUTOMATIC MACRO VARIABLES
10. MACRO DEBUGGING OPTIONS
11. WHAT IS A MACRO?
12. DEFINING AND USING MACROS
13. POSITIONAL MACRO PARAMETERS
14. KEYWORD MACRO PARAMETERS
15. CONDITIONAL MACRO COMPILATION
16. THE %DO STATEMENT
17. SAS DATA STEP INTERFACES

Chapter 14: THE OUTPUT DELIVERY SYSTEM (ODS)

1. INTRODUCTION
2. CREATING VARIOUS TYPES OF REPORTS LISTING OUTPUT
3. OTHER DESTINATIONS
4. HTML
5. PDF AND POSTSCRIPT
6. RTF FILES
7. MICROSOFT EXCEL
8. ADDING STYLE TO YOUR REPORTS
9. LOCATE EXISTING STYLES
10. ODS STYLE= OPTION
11. OTHER CUSTOMIZATIONS
12. ODS PROCLABEL= ;
13. ODS PROCTITLE; AND ODS NOPROCTITLE;
14. ADVANCED TECHNIQUES
15. ODS DOCUMENT
16. PROC TEMPLATE

Chapter 15: INTRODUCTION TO DIAGNOSING AND AVOIDING ERRORS

1. INTRODUCTION
2. UNDERSTANDING HOW THE SAS SUPERVISOR CHECKS A JOB
3. UNDERSTANDING HOW SAS PROCESSES ERRORS
4. DISTINGUISHING TYPES OF ERRORS .SAS RECOGNIZES FOUR KINDS OF ERRORS:
5. SYNTAX ERRORS
6. EXECUTION-TIME ERRORS
7. DATA ERRORS
8. SEMANTIC ERRORS
9. DIAGNOSING ERRORS
10. DIAGNOSING DATA ERRORS
11. USING A QUALITY CONTROL CHECKLIST

Chapter 16: INTRODUCTION TO CLINICAL RESEARCH

1. SAS ROLE IN CLINICAL RESEARCH
2. PROJECT MANAGEMENT IN CLINICAL RESEARCH
3. WHAT IS CLINICAL RESEARCH
4. WHAT IS PROTOCOL AND ROLE OF PROTOCOL IN CLINICAL RESEARCH?
5. WHAT IS RANDOMIZATION AND NON RANDOMIZATION?
6. WHICH IS PLAYING MAIN ROLE IN CLINICAL RESEARCH?
7. WHAT IS SOP (STANDARD OPERATING PROCEDURE)
8. IMPORTANCE OF CDM SYSTEMS FOR DATA LOADING
9. WHAT IS SAP (STATISTICAL ANALYSIS PLAN)?
10. ROLE OF SAP IN CLINICAL RESEARCH
11. SAS WORK FLOW IN CLINICAL RESEARCH
12. RELATION BETWEEN SAS AND DBMS
13. INTERACTION BETWEEN SAS WITH CDMS FOR DATA ACCESS
14. VARIOUS REPORT GENERATION IN CLINICAL RESEARCH

Chapter 17: APPLICATION OF SAS IN CLINICAL DOMAIN

1. INTRODUCTION TO CLINICAL DOMAIN
2. DATA ACCESSING
3. DATA VALIDATION
4. DATA CLEANSING
5. PREPARING ANALYSIS DATASETS
6. DATA ANALYSIS
7. DATA PRESENTATION
8. REPORT VALIDATION
9. PRACTICAL APPLICATION WITH PROJECT

Certification

Certification assistance provided with proper guidance and certification notes.