SAS Clinical Regular Course

Categories SAS

Embark on a transformative journey into the realm of SAS Clinical with Proximsoft’s SAS Clinical Regular Course. This comprehensive program is meticulously curated by seasoned industry professionals to provide you with an in-depth understanding of SAS tools and their applications in clinical research. Whether you’re a novice or have basic technical knowledge, our course is tailored to guide you through the intricacies of SAS in the clinical domain.

Why Learn SAS Clinical?

  • The demand for SAS skills in the clinical research field is soaring, offering lucrative career opportunities.
  • SAS is a powerful tool for data management, validation, and analysis, essential in ensuring the integrity of clinical trial data.
  • Proficiency in SAS Clinical enhances your ability to work on real-world projects and contributes to the success of clinical trials.
  • Our course emphasizes practical application, allowing you to develop hands-on skills that are directly applicable in the clinical domain.
Mode of TrainingOnline live Interactive sessions
Duration of the Training6 weeks
Training duration per day 60 – 90 min session
Software AccessSoftware will be installed/server access will be provided, whichever is possible
Training MaterialsSoft copy of the material will be provided during the training 
Training feeDepends on the Requirement
Resume Preparation Yes, at the end of the course based on the JD
Interview PreparationYes, by sharing some FAQ’s
Mock callsYes, 2 Technical Mock calls 
Internship Project Yes
CertificationYes, at the end of the training
JOB Assistance Yes
JOB SupportYes
  
Weekdays6AM -2 PM EST & 6-11:30 PM EST (student can pick any  1 hr)
Weekends8 AM – 12 PM EST (student can pick any 2 hrs)

What I will learn?

  • Introduction to SAS.
  • Data Management in SAS:
  • SAS Functions
  • Arrays and Array Processing
  • BY-Group Processing
  • SAS Procedures
  • SAS Macros
  • Output Delivery System (ODS)
  • Clinical Research Overview
  • Application of SAS in Clinical Domain

Course Content

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

 

Course level:All Levels
Course Duration: 30h

Requirements

  • Basic understanding of clinical research processes.
  • Familiarity with data management concepts.
  • Interest in leveraging technology for clinical data analysis.
  • Access to SAS software for practical exercises.

Talk to Our Career Advisor

    FAQ'S

    Mastering SAS is essential for effective data management, validation, and analysis in clinical trials, ensuring the reliability of trial results.
    You'll develop practical skills in data manipulation, SAS functions, arrays, and procedures, equipping you for real-world applications in clinical data analysis.
    Participants need to have access to SAS software for practical exercises. We provide guidance on obtaining access to the necessary tools.
    The course covers essential topics in clinical data management, including data validation, cleansing, and analysis, providing a solid foundation for a successful career in the field.

    Enter your Details to get a Call back