Clinical Data Quality Checks for CDISC Compliance Using SAS

Clinical Data Quality Checks for CDISC Compliance using SAS is the first book focused on identifying and correcting data quality and CDISC compliance issues with real-world innovative SAS programming techniques such as Proc SQL, metadata and macro programming. Learn to master Proc SQL’s subqueries and summary functions for multi-tasking process. Drawing on his more than 25 years’ experience in the pharmaceutical industry, the author provides a unique approach that empowers SAS programmers to take control of data quality and CDISC compliance. This book helps you create a system of SDTM and ADaM checks that can be tracked for continuous improvement. How often have you encountered issues such as missing required variables, duplicate records, invalid derived variables and invalid sequence of two dates? With the SAS programming techniques introduced in this book, you can start to monitor these and more complex data and CDISC compliance issues. With increased standardization in SDTM and ADaM specifications and data values, codelist dictionaries can be created for better organization, planning and maintenance. This book includes a SAS program to create excel files containing unique values from all SDTM and ADaM variables as columns. In addition, another SAS program compares SDTM and ADaM codelist dictionaries with codelists from define.xml specifications. Having tools to automate this process greatly saves time from doing it manually. Features SDTMs and ADaMs Vitals SDTMs and ADaMs Data CDISC Specifications Compliance CDISC Data Compliance Protocol Compliance Codelist Dictionary Compliance

Overview of Data Quality and Compliance Checks SDTMs and ADaMs Vital Checks SDTMs and ADaMs Data Values Check CDISC Specification Compliance Checks CDISC Data Compliance Checks Protocol Compliance Checks Codelist Dictionary Compliance Checks Appendix

Sunil Gupta is an international speaker, best-selling SAS author, and a global corporate trainer. Sunil is a Principal SAS/CDISC Consultant. Most recently, he taught both of his CDISC online classes with the University of California at San Diego and SAS Institute India. New in 2019, Sunil is developing a new class on Data Science using SAS class. In 2011, Sunil launched his unique SAS resource blog, SASSavvy.com, for smarter SAS searches. Currently, SAS Savvys membership consists mostly of SAS programmers, university students and pharmaceutical corporate accounts