Clinical Data Quality Checks for CDISC Compliance Using SAS

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 Savvy’s membership consists mostly of SAS programmers, university students and pharmaceutical corporate accounts

"This book is is indespensible for anyone implementing CDISC compliance and data quality checking. The practical examples will save a great deal of time and effort. Furthermore, the methods of the code are explained in detail to help the user understand how to create new checks as needed. Reader will improve understanding of CDISC principles and SQL . There are many highly developed diagrams to help organize and visualize."—Chris Weiner, Sr. Statistical Programmer, GCE Solutions "A must-read and reference for all clinical programmers. Data quality is fundamental for good clinical practice and this book is laser-focused on specific and critical programming techniques assuring compliant SDTM and ADAM data and reporting. It is a comprehensive desk reference which will become a standard for the industry. The included and well documented SAS code provides programmers with state of the art algorithms for validating and verifying STAM and ADAM datasets." - Roger DeAngelis, CEO CompuCraft Ltd"As I was reading this book, I instantly realized that the author has expert level knowledge in the clinical SAS programming arena. With the acceptance of CDISC as the standard for FDA submissions, it is imperative that companies submit air-tight data with complete compliance of clinical data standards. This is no easy task, but Sunil Gupta has done an outstanding job of providing a framework for creating standardized data. The SAS code is easy to use and generates compliant data without a hint of hardcoding. The book has a nice flow and diagrams are strategically interspersed to assist the reader in understanding the entire process. Another nice feature is that the book has sufficient detail without being tedious. This publication is very well organized allowing one to quickly find the requisite code by scanning the table of contents. I highly recommend this book for anyone in the clinical SAS environment, especially those involved in programming, validation, or project management."-Paul Gill, Clinical SAS Expert, BioClinicalData"This book is a must-read for programmers working with clinical trials data. It is a hands-on book with a wealth of examples that can be applied directly or with slight modification to your existing processes. What makes Mr. Gupta’s innovative SQL coding especially attractive is the way it yields concise, easy to interpret summary reports at each step from data capture through SDTM and AdAM data sets. His techniques for CDISC, protocol and codelist dictionary compliance are especially valuable for revealing errors at the coding stage, rather than later when rework would be costly and time-consuming. The programs in this book would make a valuable addition to any coder’s toolbox."-Vincent Rabatin, Founder, Rabatin Pharma Services"Nowadays, data quality and data checks are very important for agency submissions. If you don't have much knowledge of these issues and solution then this book is for you! Without this book, you may find it difficult and time consuming to create compliant SDTMs and ADaMs. This book covers lots of information that can be utilized to mitigate the issues at an early stage and also helps to increase data fitness scores. This book is very helpful for the Clinical and Statistical SAS programmers."- Ratheesh Gunda, Principal Statistical Programmer, Cytel

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