Contents v
Chapter 4 Transforming Data and Creating Analysis
Data Sets 83
Key Concepts for Creating Analysis Data Sets 84
Defining Variables Once 84
Defining Study Populations 85
Defining Baseline Observations 85
Last Observation Carried Forward (LOCF) 86
Defining Study Day 89
Windowing Data 91
Transposing Data 94
Categorical Data and Why Zero and Missing Results
Differ Greatly 102
Performing Many-to-Many Comparisons/Joins 106
Using Medical Dictionaries 108
Other Tricks and Traps in Data Manipulation 112
Common Analysis Data Sets 118
Critical Variables Data Set 118
Change-from-Baseline Data Set 118
Time-to-Event Data Set 121
Chapter 5 Creating Tables and Listings 125
Creating Tables 126
General Approach to Creating Tables 126
A Typical Clinical Trial Table 127
Using PROC TABULATE to Create Clinical Trial Tables 128
Using PROC REPORT to Create Clinical Trial Tables 132
Creating Continuous/Categorical Summary Tables 137
Creating Adverse Event Summaries 146
Creating Concomitant or Prior Medication Tables 162
Creating a Laboratory Shift Table 169
Creating Kaplan-Meier Survival Estimates Tables 176
Creating Listings 184
vi Contents
Output Appearance Options and Issues 191
Creating ASCII Text Output 191
Creating Rich Text Format (RTF) Output 192
Creating Portable Document Format (PDF) Files 194
“Page X of N” Pagination Solutions 196
Footnote Indicating SAS Program and Date 197
SAS Macro-Based Reporting Systems 198
Chapter 6 Creating Clinical Trial Graphs 199
Common Clinical Trial Graphs 200
Scatter Plot 200
Line Plot 201
Bar Chart 202
Box Plot 203
Odds Ratio Plot 203
Kaplan-Meier Survival Estimates Plot 204
SAS Tools for Creating Clinical Trial Graphs 205
Common Clinical Trial SAS/GRAPH Procedures 205
Using the Annotate Facility for Graph Augmentation 206
Sample Graphs 207
Creating a Scatter Plot 207
Creating a Line Plot 210
Creating a Bar Chart 214
Creating a Box Plot 218
Creating an Odds Ratio Plot 228
Creating a Kaplan-Meier Survival Estimates Plot 233
Output Options 240
Selecting Graphics Drivers 240
Using ODS Destinations for SAS/GRAPH 241
Contents vii
Using SAS/GRAPH Assistants 244
Graph-N-Go 245
SAS Enterprise Guide 245
ODS Graphics 245
When You Should Use SAS/GRAPH 246
Chapter 7 Performing Common Analyses and Obtaining
Statistics 247
Obtaining Descriptive Statistics 248
Using PROC FREQ to Export Descriptive Statistics 248
Using PROC UNIVARIATE to Export Descriptive Statistics 249
Obtaining Inferential Statistics from Categorical Data
Analysis 251
Performing a 2x2 Test for Association 251
Performing an NxP Test for Association 252
Performing a Stratified NxP Test for Association 253
Performing Logistic Regression 254
Obtaining Inferential Statistics from Continuous Data
Analysis 255
Performing a One-Sample Test of the Mean 255
Performing a Two-Sample Test of the Means 257
Performing an N-Sample Test of the Means 258
Obtaining Time-to-Event Analysis Statistics 259
Obtaining Correlation Coefficients 260
General Approach to Obtaining Statistics 260
Chapter 8 Exporting Data 263
Exporting Data to the FDA 264
Using the SAS XPORT Transport Format 264
Creating XML Files 266
Exporting Data Not Destined for the FDA 276
Exporting Data with PROC CPORT 276
Exporting ASCII Text 276
viii Contents
Exporting Data to Microsoft Office Files 283
Exporting Other Proprietary Data Formats 287
Encryption and File Transport Options 288
Chapter 9 The Future of SAS Programming in
Clinical Trials 289
Changes in the Business Environment 290
Changes in Technology 290
Changes in Regulations 291
Changes in Standards 291
Use of SAS Software in the Clinical Trial Industry 292
Chapter 10 Further Resources 293
Regulatory Resources 294
SAS Programming Validation 294
FDA Resources 295
Standards and Industry Organizations 296
SAS Help 296
SAS-L 296
SAS Technical Support 297
SAS Users Groups 297
SAS Manuals and Online Documentation 297
SAS Press 298
Community Pages at SAS 298
Third-Party SAS Web Pages 298
Useful Technical Skills 299
Scripting 299
Version Control Software 299
VBScript/JavaScript for Applications 299
Systems Development Life Cycle 299
Modeling Tools 300
Markup Languages 300
Contents ix
File Transport and Data Encryption Technologies 300
Other Applications Development Languages 300
Qualifying for and Obtaining a Job 301
Glossary 303
Index 321