TITLEPRESENTER ABSTRACT SECTION
Advanced Visualization using TIBCO Spotfire and SASAjay Gupta, PPD, Principal Programmer AnalystThis paper will demonstrate some advanced visualization from Preclarus Patient Data Dashboard (Preclarus PDD) within PPD created using TIBCO Spotfire and SAS for SDTM database and share our experiences and challenges while creating this visualization.DV - Data Visulization & Graphics
Practical Uses of the DOW Loop in Pharmaceutical ProgrammingRichard Allen, Peak Stat, Statistician/ProgrammerThe DOW-Loop involves taking control of the implicit DO loop in a DATA step by identifying and storing a value that is retained until all records for a by group are processed. It has many applications, including streamlining LOCF and change from baseline calculations as well as transposing.AD - Application Development & TechnicalTechniques
Considerations in ADaM Occurrence Data: Handling Crossover Records for Non-Typical AnalysisRichann Watson, DataRich Consulting, Statistical Programmer and CDISC ConsultantCD - Data Standards/CDISC & Regulatory Submission
Automate Clinical Trial Data Issue Checking and TrackingQin Li, Regeneron Pharmaceuticals, Inc., Sr. Director, Statistical ProgrammingWell organized and properly cleaned data are fundamental for clinical trial data analysis. Programmatic data issue checks play an important role in data cleaning. Our tool is a set of SAS macro programs which automate data checking and issue tracking outside of data capture systems.AD - Application Development & TechnicalTechniques
How to do data validation plan autogeneration in clinical trial David Guo, Proswell, Director of Data Management and statisticsDM - Data Validation & Management
A tool to compare different data transfersJun Wang, FMD K&L Inc., Senior Statistical Programmer/Analyst IFor an ongoing study, especially middle-large size , regular or irregular data reviewing is an import method to monitor the progress and quality. We develop a tool to compare the different data transfers, including added or deleted records, values updated for the existing records and no changes.AD - Application Development & TechnicalTechniques
Simplifying Your %DO Loop with CALL EXECUTEArthur Li, City of Hope National Medical Center, BiostatisticianOne often uses a %DO loop to execute a section of a macro repetitively. An alternative method is to utilize the loop in the DATA step with CALL EXECUTE to generate a series of macro calls. One of the advantages in the latter approach is eliminating the needs of using indirect referencing.AD - Application Development & TechnicalTechniques
Standardize Study Data for Electronic SubmissionQin Li, Regeneron Pharmaceuticals, Inc., Sr. Director, Statistical ProgrammingFDA requires that clinical study data must be submitted in a format as specified in the Data Standard Catalog. In the past ten years, our statistical programming team has worked on numerous submissions. We will share our experience on electronic submissions in this paper. CD - Data Standards/CDISC & Regulatory Submission
What is RE domain?David Ju, ERT, Sr. DirectorRespiratory System Findings (RE domain) has been introduced in SDTMIG 3.3 as one of the new domains since 2015. Since the SDTMIG will be finalized sooner or later, now is a good time to review what RE domain is for and understand its nuances.CD - Data Standards/CDISC & Regulatory Submission
Utilize Dummy Variables/Datasets in Graph Generationamos shuThe input SAS dataset does not always perfectly contain all necessary data that can be used for graph generation in the real world. Creating dummy variables or datasets is an effective way, sometimes the only way, to generate the desired graph. This paper discusses three different ways to utilize duDV - Data Visulization & Graphics
Create Cupid Arrow into Two Love Hearts Image Using SAS PROC TEMPLATE --- For the Valentines DayKaiqing FanKey words: SAS Enterprise Guide, PROC TEMPLATE, SERIESPLOT STATEMENT, Cupid Arrow with love hearts, Valentine s DayDV - Data Visulization & Graphics
Considerations in ADaM Occurrence Data: Handling Crossover Records for Non-Typical AnalysisRichann WatsonCD - Data Standards/CDISC & Regulatory Submission
Automate Clinical Trial Data Issue Checking and TrackingQin LiWell organized and properly cleaned data are fundamental for clinical trial data analysis. Programmatic data issue checks play an important role in data cleaning. Our tool is a set of SAS macro programs which automate data checking and issue tracking outside of data capture systems.AD - Application Development & TechnicalTechniques
A tool to compare different data transfersJun WangFor an ongoing study, especially middle-large size , regular or irregular data reviewing is an import method to monitor the progress and quality. We develop a tool to compare the different data transfers, including added or deleted records, values updated for the existing records and no changes.AD - Application Development & TechnicalTechniques
Combining quality of productivity and efficiency under highly pressure of lacking time  discussion by view of first-time qualityWinkle LuExplore the first-time quality in programming process, and help programmers accomplish tasks smoothly under compact and frequent deliveries in pharmaceutical companies and Contract Research Organization.AD - Application Development & TechnicalTechniques
Common Pinnacle 21 Report Issues: Shall we Document or Fix?Ajay GuptaIn this paper, I will discuss some common issues with the Pinnacle 21 report messages created from running against SDTM datasets and propose some solutions based on my experience. Also, I will discuss some scenarios when it is better to document the issue in reviewers guide than doing workaround.CD - Data Standards/CDISC & Regulatory Submission
My understandings to SDTM and ADaM Chunpeng ZhaoI will share my understandings to SDTM and ADaM. For example, why is some clinical information mapped into Supplemental Qualifier Domain instead of Finding About domain, or vice versa? When we are planning to create a new ADaM dataset, what factors should be considered? CD - Data Standards/CDISC & Regulatory Submission
Efficient Graphing of Basic Data Structure - Let Data Decide Scale of Y-Axis for ThemselvesKuenHung LinIn this paper, author would like to introduce an idea that using fixed number of major ticks first to let data decide optimized minimum, maximum and increment of y-axis for graphic based on Basic Data Structure (BDS).DV - Data Visulization & Graphics
Write Your Dynamic Programming Function with SAS FCMPEmily GaoThe dynamic programming algorithm is a powerful algorithm, which is used to solve complex computational problems, such as maximizing the advertisement revenue of a TV station, spell check, etc. This paper will show you how to write your dynamic programming function with SAS FCMP through an example.CC - Coder's Corner
Decomposition and reconstruction of a TLF - a simplified, fast and accurate table shell designerChengeng TianWe begin by considering a universal model that all kinds of table shells can be generated and managed in a single design. Then we illustrate how a new platform can replace our old generation tools like MS Word. Finally, we introduce some techniques we are using to expedite the process further.AD - Application Development & TechnicalTechniques
Avoiding Sinkholes: Common Mistakes During ADaM Data Set ImplementationRichann WatsonCD - Data Standards/CDISC & Regulatory Submission
Standardize Study Data for Electronic SubmissionQin LiFDA requires that clinical study data must be submitted in a format as specified in the Data Standard Catalog. In the past ten years, our statistical programming team has worked on numerous submissions. We will share our experience on electronic submissions in this paper. CD - Data Standards/CDISC & Regulatory Submission
What is RE domain?David JuRespiratory System Findings (RE domain) has been introduced in SDTMIG 3.3 as one of the new domains since 2015. Since the SDTMIG will be finalized sooner or later, now is a good time to review what RE domain is for and understand its nuances.CD - Data Standards/CDISC & Regulatory Submission