SAS_Clinical-Regular Training

  • (25 REVIEWS )

SAS Clinical /Clinical SAS is the application of SAS technology to the clinical domain for clinical trial data analysis in pharmaceutical/biotech and clinical research companies.

Description

SAS Clinical /Clinical SAS is the application of SAS technology to the clinical domain for clinical trial data analysis in pharmaceutical/biotech and clinical research companies.

Did you Know

Clinical SAS helps clinical researchers to achieve great speed and efficiency while conducting clinical trials. It helps Clinical SAS professionals to analyze large amounts of big data (structured & unstructured data), which helps them to uncover many hidden insights, patient concerns, and many other issues.

Why learn and get certified in SAS Clienic

SAS is widely used in clinical trial data analysis in pharmaceutical, biotech and clinical research companies. SAS programmers play an important role in clinical trial data analysis. SAS programmers work closely with statisticians and data managers. They provide the link between raw data and the analysis.

Pre-requisites

1. Candidates do not require any specific requirements to take up this course except a basic background in information technology.
2. We provide FREE Finance Domain Materialsif you want to Learn Basics of Finance and Accounting.

Course Objective

Clinical SAS helps clinical researchers to achieve great speed and efficiency while conducting clinical trials. It helps Clinical SAS professionals to analyze large amounts of big data (structured & unstructured data), which helps them to uncover many hidden insights, patient concerns, and many other issues. These insights help them to predict and improve outcomes.

Who should attend this Training?

The SAS programmer aspirant in India should have a SAS certification to be eligible to be a Clinical SAS programmer. Without this certification, you neither have the erudition nor the skills for the position. This is the most basic eligibility required to become a Clinical SAS programmer.

How will I perform the practical sessions in Online training?

For online training, US GlobalSoft provides a virtual environment that helps in accessing each other’s system. The complete course material in pdf format, reference materials, course code is provided to trainees. US GlobalSoft conductes online sessions through any of the available requirements like Skype, WebEx, GOTOMeeting, Webinar, etc.

 

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. >
    10. PROCESSING A DATA STEP: A WALKTHROUGH
    11. CREATING THE INPUT BUFFER AND THE PROGRAM DATA VECTOR
    12. WRITING AN OBSERVATION TO THE SAS DATA SET
    13. FOUR TYPES OF SAS LIBRARIES
    14. SAS LIBRARIES
    15. WORK LIBRARY
    16. SASHELP LIBRARY
    17. SASUSER LIBRARY

    18. 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.