Shanghai, China
Jul 7-8, 2017
Applications Development & Technical Techniques
AD01. FREQUENTLY USED SAS OPTIONS IN CLINICAL TRIAL PROGRAMMINGWanqing Li, Amgen
AD02. Streamline Table Lookup by Using HASH in FCMP
Qing Liu, Eli Lilly and Company
AD03. Networked Table-shell Exploration
Jianfeng Ye, SANOFI
You Li, SANOFI
AD04. Merge multiple RTF files, convert to PDF and add bookmark
Xiang Wang, FMD
AD05. Journey to the center of the earth ?€? Deep understanding of SAS language processing mechanism
Di Chen, SAS Beijing R&D
AD06. A convenient tool to check the pagination issue in TLF
Yong Cao, PPD Inc.
Xuan Sun, PPD Inc.
AD07. Writing Efficient Queries in SAS@ Using PROC SQL with Teradata
Mina Chen, Roche
AD08. Project Automation? Scripting helps you out
Sean Yan, WuXi Clinical Development Services Co.,Ltd
Shaozun Zhang, WuXi Clinical Development Services Co.,Ltd
Jason Wang, WuXi Clinical Development Services Co.,Ltd
AD09. SAS Application to Automate a Comprehensive Review of DEFINE and All of its Components
*** BEST PAPER ***
Walter Hufford, Novartis Pharmaceuticals
Vincent Guo, Novartis Pharmaceuticals
Mijun Hu, Novartis Pharmaceuticals
Coder's Corner
CC01. SYMply PUT: GET the most out of SYMPUTX and SYMGETNRob Howard, Veridical Solutions
CC02. Automatic Retention with MERGE statement
Yuni Chen, Roche(China) Holding Ltd.,
CC03. Extract Information from aCRF by using EXCEL VBA
Kai Zhou, PAREXEL
Annie Xu, PAREXEL
CC04. One Step to Produce Shift Table by Using PROC REPORT
*** BEST PAPER ***
Haiqiang Luo, PPD Inc.
CC05. Could you make join datasets more efficient, especially many to many join?
Wei Duan, Programmer Analyst II PPD
CC06. Creating a list of files within a folder and inserting EXCEL hyperlinks to open each file
Vincent Fan, Sanofi
Qingan Chang, Sanofi
CC07. How to read RTF files into SAS dataset?
Zhao Chunpeng, Boehringer-Ingelheim
CC08. The encapsulation of hash module macro
Mijun Hu, Novartis Pharmaceuticals
Data Management & Validation
DM01. How Did This Get Made?Matt Becker, SAS
DM02. What's your data flow in LSAF (How to code in LSAF)
Shuang Fu, SAS
DM03. Outlier Analysis in SAS
*** BEST PAPER ***
Chao Jiang, MSD
Yan Liu, MSD
DM04. How process flow standardized our process
Yeqian Gu, SAS Research and Development (Beijing) Co., Ltd
DM05. Strip Special & Non-Printable Characters in Your Data Set
Ying Liu, MSD
DM06. Covering Proc Compare Limits
Mary Zeychelle Hundana, PPD Pharmaceutical Development Philippines Corp.
Data Standards/CDISC and Regulatory Submission
CD01. How to define Treatment Emergent Adverse Event (TEAE) in crossover clinical trials*** BEST PAPER ***
Mengya Yin, Ultragenyx Pharmaceutical
Wen Tan, Ultragenyx Pharmaceutical
CD02. Introduction to Therapeutic Area Data Standards User Guide for QT Studies (TAUG-QT)
David Ju, ERT Inc.
CD03. Constructive Practice of Generating ADaM Datasets
Amos Shu, AstraZeneca
CD04. Effective Statistical Programming Preparation and Support for CFDA Self-Inspections and Onsite Inspections
Peng Wan, MSD
CD05. Assigning VISITNUM and EPOCH
Na Duan, WuXi Clinical Development Services Co.,Ltd
Ru He, WuXi Clinical Development Services Co.,Ltd
CD06. Create Zero Observation dataset to achieve maximum metadata resolution in CDISC Submission
M K Sinha (Ajay), M.Phil Biotechnology
CD07. Overview of OSI Deliverables from Programming Perspective
Wang Zhang, MSD R&D (China) Co. Ltd.
CD08. Project Standard Implementation
Yun Ma, Boehringer Ingelheim
Data Visualization and Graphics
DV01. Consistent Group Attributes Independent of Data Order*** BEST PAPER ***
Yu Li, Novartis
DV02. Data Explore Matrix ?€? Quality Control by Exploring and Mining Data in Clinical Study
Yongxu Tang, Merck
Yu Meng, Merck
Yongjian Zhou, Merck
Yang Chong, Merck
Yangfei Ma, Merck
DV03. Text handling in Graph by using Graph template language
Li Jianduo, PAREXEL
DV04. Clinical Data Visualization using TIBCO Spotfire and SAS
Ajay Gupta, PPD Inc
DV05. What could ODS graphics do about Box Plot?
Tongda Che, MSD
Hands-On Workshop
HOW01. Hands-on Graph Template Language (GTL)Kriss Harris, SAS Specialists Ltd
HOW02. SAS(R) Studio - The Next Evolution of SAS Programming Environments
Matt Becker, SAS
Management and Career Development
MA01. Managemen and Career Development: Trend of talent and talent needed for multinational enterprisesSamantha Xie, Boehringer Ingelheim
Statistics & Pharmacokinetics
SP01. Time-Dependent Covariates 'Survival' More in PROC PHREGFengying Xue, Sanofi
Michael Lai, Sanofi
SP02. Receiver Operating Characteristic (ROC) Curve Analysis using SAS
Zheng Yao, Merck Serono
SP03. Clinical PK-PD Model: Problems and Countermeasures
Chen Wang, Amgen
SP04. Visualization & interactive application in design and analysis by using Rshiny
*** BEST PAPER ***
Baoyue Li, Eli Lilly China
Boyao Shan, Eli Lilly China
SP05. A Path to Gain Confidenct with your Confidence Interval in Clinical Trial Analysis
Yi Gu, Roche (China) Holding Ltd
SP06. %ScoreQoL: SAS Macro-Program that Automates the Scoring of Quality of Life Questionnaires
Mitchikou Pearl Tseng, PPD