SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PharmaSUG China papers
SAS:PhUSE papers
FDA/PhUSE CSS posters
SAS:SCSUG papers
SAS:SESUG papers
SAS:SeUGI papers
SAS:SUGI papers
SAS:VIEWS papers
SAS:WUSS papers
SAS:CDISC papers
Fortune records
Marsh 1001
South America

Powered by SAS® 9.01.01M3P02162005.

Valid XHTML 1.0 Transitional

  Search results
SAS Conference Proceedings:
May 22-25, 2005, Phoenix, Arizona, 153 papers
PharmaSUG 2017   PharmaSUG 2016   PharmaSUG 2015   PharmaSUG 2014   PharmaSUG 2013   PharmaSUG 2012   PharmaSUG 2011   PharmaSUG 2010   PharmaSUG 2009   PharmaSUG 2008   PharmaSUG 2007   PharmaSUG 2006   PharmaSUG 2005   PharmaSUG 2004   PharmaSUG 2003   PharmaSUG 2002   PharmaSUG 2001   PharmaSUG 2000   PharmaSUG 1998   PharmaSUG 1997  

Pharmaceutical SAS Users Group 2005: Best Papers and honorable mentions

Automated Excel-lent Validation
  Janet E. Stuelpner, Left Hand Computing, Inc. (Best Paper in Applications Development)
Comparison of Techniques for XML and RTF Tables
  Linda M. Collins, PharmaStat LLC; Alan Hopkins, Pharmastat LLC (Best Paper in Applications Development)
Generate Word Macros to organize and maintain Tables/Listings
  Elizabeth R. Taylor, Endo Pharmaceuticals Inc. (Best Paper in Coders' Corner)
Use Proc Format To Apply Value Specific Suffixes To Your Data
  Lara E. Guttadauro, Kendle International Inc (Best Paper in Coders' Corner)
Lab Unit Conversions: Taking Advantage of "Expert" External Resources
  Sandra Minjoe, Genentech (Best Paper in Data Management)
Preventing Data Loss when Combining SAS Datasets
  John Cantrell, University of North Carolina (Best Paper in Data Management)
Strategies for Implementing SDTM and ADaM Standards
  Susan J. Kenny, Maximum Likelihood Solutions (Best Paper in FDA Compliance)
Risk-Based Approach to SAS Program Validation
  Keith C. Benze, SEC Associates, Inc. (2nd Best Paper in FDA Compliance)
Advanced Array Applications in Clinical Data Manipulation
  Jane Lu, AstraZeneca (Best Paper in Posters)
To Macro Or Not To Macro
  Amy E. Gillespie, Merck & Co., Inc. (2nd Best Paper in Posters)
Assessing within- and between-subject effects with correlated clinical data
  Marla J. Husnik, Fred Hutchinson Cancer Research Center; Yijian (Eugene) Huang, Emory University, Rollins; Grant Colfax, San Francisco Department of Public Health (Best Paper in Public Health Research)
Analyzing and Displaying Study Data in Clinical Trials Made Easy
  Denise J. Smith, Mayo Clinic - Cancer Center Statistics (Best Paper in Statistics & Pharmacokinetics)
Programming Tips and Examples for Your Toolkit, II
  John Morrill (Best Paper in Technical Techniques)
How To Get Ten Pounds Of Data Into A Five Pound Can
  Daniel K. Downing, CaremarkPCS (2nd Best Paper in Technical Techniques)
An Introduction to Regular Expressions with Examples from Clinical Data
  Richard F. Pless, Ovation Research Group (Best Paper in Tutorials)
Retaining, Lagging, Leading, and Interleaving Data
  Toby Dunn, Texas Eductation Agency; Chang Chung, Office of Population Research, Princet (2nd Best Paper in Tutorials)

Applications Development
Coders' Corner
Data Management
FDA Compliance
Hands-On Workshops
Public Health Research
SAS Institute
Statistics & Pharmacokinetics
Technical Techniques

Applications Development
tweet!  An Automated Reporting Application for Safety Sciences
  Fang Dong, Pfizer
Keywords:  Safety Science Study Reporting  Automation  Macros  Proc Report  ODS  RTF 
Pages: 9 Size: 54 Kb 
tweet!  Creating Flexible Graphics with Data Step Graphics Interface (DSGI)
  Hui-Ping Chen, Eli Lilly and Company
Keywords:  Annotate  External  Gprint  Printto  Greplay  Gslide 
Pages: 8 Size: 199 Kb 
Best Paper
tweet!  Automated Excel-lent Validation
  Janet E. Stuelpner, Left Hand Computing, Inc.
Keywords:  Excel  Validation  Import Wizard 
Pages: 9 Size: 32 Kb 
tweet!  CDISC for electronic submissions - A Table Translation Program
  John H. Adams, Boehringer Ingelheim; Kirill Tchernakov, Boehringer Ingelheim
Pages: 15 Size: 319 Kb 
tweet!  Access to SAS Data Using the Integrated Object Model (IOM) in Version 9.1
  Frederick E. Pratter, Eastern Oregon University
Keywords:  Integration Technologies  IOM  Visual Basic  C++  Java 
Pages: 18 Size: 384 Kb 
tweet!  Managing a SAS Programming Environment using DAPs and MSODSC
  Brian P. Fairfield-Carter, PRA International; Stephen Hunt, PRA International
Keywords:  Data Access Pages  MSODSC  VBScript  Jscript 
Pages: 12 Size: 72 Kb 
tweet!  An Interactive Application to Document, Check Syntax and Run SAS Macros
  Eugene C. Yeh, PharmaNet Inc.
Keywords:  macro  check  syntax  document 
Pages: 12 Size: 826 Kb 
tweet!  Using SAS/IntrNet as a Web-Enabled Platform for Clinical Reporting
  Paul Gilbert, DataCeutics Inc; Steve Light, DataCeutics Inc; Greg Weber, DataCeutics Inc
Keywords:  IntrNet  Clinical Reporting  Web Enabled  internet 
Pages: 6 Size: 201 Kb 
tweet!  Generating Customized Analytical Reports from SAS Procedure Output
  Brinda Bhaskar, RTI International; Kennan Murray, RTI International
Keywords:  table generation  macro  proc report  proc template  proc transpose  ODS  variable information function 
Pages: 9 Size: 54 Kb 
tweet!  SAS Macro Technique for Embedding and Using Metadata in Web Pages
  Gregory T. Weber, DataCeutics Inc.; Troy A. Ruth, DataCeutics Inc.; Paul Gilbert, DataCeutics Inc.
Keywords:  IntraNet  Clinical  Dynamic  macro  internet 
Pages: 6 Size: 212 Kb 
tweet!  SAS and the Intranet: How a Comments System Creates In-House Efficiencies
  Morris Lee, Gilead Sciences, Inc.
Keywords:  IntrNet  SQL Serrver  Efficiencies 
Pages: 7 Size: 485 Kb 
tweet!  A Simple Solution for Managing SAS Program Validation Process
  Tony Chang, Amgen Inc.; Dana Soloff, Amgen Inc
Keywords:  Java  Excel  Validation 
Pages: 6 Size: 253 Kb 
tweet!  Statistical Table Specifications and Automatic Code Generation using XML
  Alan Hopkins, PharmaStat LLC; Linda Collins, PharmaStat LLC
Keywords:  Statistical Tables  XML  reporting macros  code generation 
Pages: 7 Size: 111 Kb 
tweet!  Create your customized CRF tracking system for customized reports
  Tikiri B. Karunasundera, Medpace Inc
Keywords:  CRF  Tracking 
Pages: 9 Size: 121 Kb 
tweet!  Constructing Stack Tables With Proc Report and ODS RTF
  Lei Zhang, Merck & Co. Inc.
Keywords:  Stack Table  ODS RTF  Proc REPORT  Proc Template  Separation of Concerns  Clinical Table Programming  Code Pattern  %Glue 
Pages: 11 Size: 297 Kb 
Best Paper
tweet!  Comparison of Techniques for XML and RTF Tables
  Linda M. Collins, PharmaStat LLC; Alan Hopkins, Pharmastat LLC
Keywords:  XML  RTF  ODS  PROC TEMPLATE  Statistical Tables 
Pages: 15 Size: 263 Kb 
tweet!  How is Outsourcing Going to Affect SAS Programming?
  Thu-Thuy Truong, Meta-Xceed Inc.; Sy T. Truong, Meta-Xceed Inc.
Keywords:  Outsource  Offshore 
Pages: 7 Size: 108 Kb 
Coders' Corner
tweet!  %isnum, A Macro Function Check Data Type
  Fuping Peng, Eisai Medical Research
Keywords:  Input Function  Boolean  macro 
Pages: 3 Size: 30 Kb 
tweet!  Storing and Using a List of Values in a Macro Variable
  Art Carpenter, CA Occidental Consultants
Keywords:  Macro variables  %SCAN  &&VAR&I  PROC SQL  INTO  CALL SYMPUT  %DO 
Pages: 6 Size: 111 Kb 
tweet!  A Dynamic SAS/IntrNet Example with Help of ASP and JavaScript
  Sijian Zhang, University of Alabama at Birmingham
Keywords:  IntrNet  Java  ASP  dynamic  Clinical trial  web 
Pages: 6 Size: 325 Kb 
tweet!  Assigning Treatment Group in Cross-over Studies:A Practical Approach
  Shulin Yuan, AstraZeneca; Charles C. Ling, AstraZeneca
Keywords:  Treatment Group  Cross-over  SAS 
Pages: 3 Size: 15 Kb 
tweet!  Programming Gems that are worth learning SQL for!
  Pamela L. Reading, Rho, Inc.
Keywords:  SQL  fuzzy merge  Cartesian merge  merging 
Pages: 5 Size: 378 Kb 
tweet!  Automate and Customize Printing of Word Files in Windows Environment
  Jay Zhou, Amylin
Keywords:  print  wordBasic  DDE  %print 
Pages: 6 Size: 215 Kb 
tweet!  Creating HTML Output with Output Delivery System
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords:  ODS  HTML  SAS output  FRAME 
Pages: 6 Size: 222 Kb 
tweet!  Reading a Pipe Delimited File within a Comma Delimited File
  Carey G. Smoak, Roche Molecular Systems, Inc
Keywords:  Delimited Files  Reading Data  Automating Programs 
Pages: 6 Size: 33 Kb 
  Varsha C. Shah, Dept. of Biostatistics
Keywords:  detail 
Pages: 5 Size: 56 Kb 
tweet!  SAS 9 Migration Automation
  Xiaoming Liang, Fred Hutchinson Cancer Research Center
Keywords:  migration automation  automated migration  SAS 9 migration 
Pages: 4 Size: 30 Kb 
tweet!  Locating an Autocall Macro
  Weiqin Pan, Bristol-Myers Squibb Co.
Pages: 5 Size: 255 Kb 
tweet!  Data Transfer from Microsoft Access to SAS Made Easy
  Jane Lu, AstraZeneca
Keywords:  Data Transfer  MS Access 
Pages: 5 Size: 53 Kb 
tweet!  A Log File Parser that Creates Data Mappings
  John W. Kaye, Kendle
Keywords:  parser  log  data set 
Pages: 3 Size: 25 Kb 
Best Paper
tweet!  Generate Word Macros to organize and maintain Tables/Listings
  Elizabeth R. Taylor, Endo Pharmaceuticals Inc.
Keywords:  Microsoft  Word  Macros 
Pages: 8 Size: 419 Kb 
tweet!  Utility Macros Used in the Process for Database Translations
  Yuguang Zhao, sanofi-aventis research; Jingchun Yu, sanofi-aventis research
Keywords:  macros  database  CRF 
Pages: 3 Size: 23 Kb 
tweet!  Produce Sorted Columns with a Hanging First Line Using PROC REPORT
  David C. Izard, GlaxoSmithKline; David C. Chen, GlaxoSmithKline
Keywords:  PROC REPORT  Adverse Event Reporting  Outdent  Hanging Indent 
Pages: 6 Size: 179 Kb 
tweet!  Sort Your SAS Graphs and Create a Bookmarked PDF Document Using ODS PDF
  Dirk Spruck, Accovion GmbH; Monika Kawohl, Accovion GmbH
Keywords:  ODS PDF  SAS graphs  PDF bookmarks  description=  PROC GREPLAY  SAS dictionary table CATALOG 
Pages: 5 Size: 100 Kb 
tweet!  Macro Design & Development by Example
  Dante diTommaso, Novartis Pharma AG
Keywords:  SAS macro language  variable attributes  autocall  sasautos  macro design  macro development  macro implementation  generic programming  error handling  comment styles  macro quoting  character constants 
Pages: 6 Size: 47 Kb 
tweet!  RETAIN or NOT? Is LAG far behind?
  Venky Chakravarthy, Bristol-Myers Squibb Co., Wallingford, CT
Keywords:  Retain  Lag  Loop 
Pages: 9 Size: 209 Kb 
Best Paper
tweet!  Use Proc Format To Apply Value Specific Suffixes To Your Data
  Lara E. Guttadauro, Kendle International Inc
Keywords:  format  suffix  display  picture 
Pages: 2 Size: 15 Kb 
tweet!  Using DDE with SAS to execute VBA macros in Excel and enhance output from SAS with Excel features
  Gary Chen, AstraZeneca Pharmaceuticals
Keywords:  DDE  VBA  macro  MicroSoft Office 
Pages: 4 Size: 23 Kb 
tweet!  Oh No, a Zero Row: 5 Ways to Summarize Absolutely Nothing
  Stacey D. Phillips, i3 Statprobe; Gary Klein, i3 Statprobe
Keywords:  missing data  zero row  completetypes  sparse 
Pages: 5 Size: 135 Kb 
tweet!  What's New in PROC FREQ Procedure, Version 9.
  Jyotheeswara N. Yellanki, HTC Global Services; Raj S. Suligavi, HTC Global Services
Pages: 8 Size: 198 Kb 
tweet!  Producing Patient Profiles Using PROC DOCUMENT and ODS Layout
  Doug Lassman, PRA International
Keywords:  Patient Profiles  PROC DOCUMENT  ODS Layout 
Pages: 8 Size: 113 Kb 
tweet!  A Macro to Keep Titles and Footnotes in One Place
  John Morrill, Quintiles, Inc.
Keywords:  Title  Footnote  Header  Macro 
Pages: 5 Size: 43 Kb 
tweet!  Everything You Always Wanted to Know About Fuzzy Merges But Were Afraid to Ask - A Guide to Merging Datasets with Non-Exact Keys Using SAS Proc SQL
  Robert W. Graebner, Quintiles
Keywords:  SQL  Fuzzy Merge 
Pages: 4 Size: 72 Kb 
tweet!  Using SAS Proc Frequency for manageable data analysis.
  Curtis B. Wolf, DataCeutics, Inc.
Keywords:  PROC  Freq 
Pages: 6 Size: 31 Kb 
tweet!  Simplifying Hard-Coding Using A Macro Call
  Jay Huang, Gilead Sciences, Inc.
Keywords:  hard-code  macro  parameters 
Pages: 4 Size: 209 Kb 
tweet!  Individual Data Reviews
  Ananth Kumar, Gilead Sciences
Keywords:  Data  Reviews 
Pages: 3 Size: 127 Kb 
tweet!  SAS_TRAN: A SAS Macro for Generating SAS Transport Files
  Taghi R. Garacani, AstraZeneca; Donald W. Peterson, AstraZeneca
Pages: 12 Size: 120 Kb 
tweet!  Page X of Y with Proc Report
  Toby Dunn, Texas Eductation Agency; Chang Chung, Office of Population Research, Princet
Pages: 6 Size: 62 Kb 
tweet!  Processing Name/Value Input in SAS Web Applications
  Don Boudreaux, SAS Institute Inc.
Keywords:  web  IntrNet  Stored_Process  internet 
Pages: 5 Size: 119 Kb 
Data Management
tweet!  An Animated Guide: The details of %Str and %NRStr
  Russell M. Lavery, Self
Keywords:  Macro  Quoting  %Str  %NRStr 
Pages: 13 Size: 336 Kb 
tweet!  Prepare Data Listings with SAS Software for Database Audit
  Jay Zhou, Amylin; Larry Shen, Amylin
Keywords:  Database Audit  Quality Control  Random Sampling  Listing 
Pages: 8 Size: 223 Kb 
Best Paper
tweet!  Lab Unit Conversions: Taking Advantage of "Expert" External Resources
  Sandra Minjoe, Genentech
Keywords:  look-up table  lab  unit  conversion  validation  maintenance  Excel  Oracle Clinical 
Pages: 7 Size: 95 Kb 
tweet!  SAS Efficient & Effective Utilization
  Karthikeyan Chidambaram, Cognizant Technology Solutions
Keywords:  Hidden  features 
Pages: 5 Size: 31 Kb 
tweet!  A Single SAS Macro for Range Checking an Entire Database
  Kim R. Truett, KCT Data, Inc.
Keywords:  Data Management  Macro  Range Checking  Generic Programming 
Pages: 7 Size: 102 Kb 
tweet!  Consistent Variables + Consistent Checks = Cleaner Data
  Greg Silva, Biogen Idec
Keywords:  data checking  data management  macro  checking 
Pages: 5 Size: 155 Kb 
tweet!  Remembering the Past: Ensuring Quality though Historical Benchmarking
  Marc-Paul Lee, Sg2, LLC
Keywords:  QA Quality Assurance  Benchmarking  Benchmark  SUMMARY  FREQ  MACRO 
Pages: 8 Size: 37 Kb 
tweet!  Streamlining Processes: Reconciling Programming and Documentation
  Hansjörg Frenzel, PRA International
Keywords:  Process development  specification  ddt  report  variable  attribute 
Pages: 11 Size: 130 Kb 
tweet!  Issues in Intermittent coding of Concomitant Medication
  James E. Witt, PRA International; Julius Asubonteng, Statking Consulting Inc.
Keywords:  Concomitant  Medication 
Pages: 5 Size: 19 Kb 
Best Paper
tweet!  Preventing Data Loss when Combining SAS Datasets
  John Cantrell, University of North Carolina
Keywords:  Merge  Data Loss  Set 
Pages: 9 Size: 89 Kb 
tweet!  Know your data while writing the SAS codes
  Shu-Min Chuang, Gilead Sciences, Inc.
Keywords:  Check 
Pages: 4 Size: 24 Kb 
FDA Compliance
tweet!  Implementation of the CDISC SDTM at the Duke Clinical Research Institute
  Jack Shostak, Duke Clinical Research Institute
Keywords:  SDTM  CDISC 
Pages: 12 Size: 243 Kb 
Best Paper
tweet!  Strategies for Implementing SDTM and ADaM Standards
  Susan J. Kenny, Maximum Likelihood Solutions
Keywords:  CDISC  SDTM  ADaM  FDA  analysis datasets  submission files 
Pages: 8 Size: 239 Kb 
2nd Best Paper
tweet!  Risk-Based Approach to SAS Program Validation
  Keith C. Benze, SEC Associates, Inc.
Keywords:  computer validation  computer compliance  part 11 
Pages: 7 Size: 132 Kb 
tweet!  Benefits of Validating SAS Systems in a Regulated Environment
  Sy T. Truong, Meta-Xceed Inc.
Keywords:  Validation 
Pages: 8 Size: 200 Kb 
tweet!  The Role of Analysis Datasets in Successful FDA Advisory Meetings
  Sandy Chang, Gilead Sciences, Inc; Steve Wong, Gilead Sciences, Inc.
Keywords:  analysis dataset  analysis metadata  NDA submission 
Pages: 9 Size: 640 Kb 
tweet!  Designing Helpful Audit Trails
  John Gorden, Quintiles
Keywords:  audit trails  documentation  tracking sheet 
Pages: 6 Size: 84 Kb 
tweet!  Quality Testing for Programs Used in Regulatory Submission
  Xiaohui Wang, Merck & Co., Inc.; Elaine Czarnecki, Merck & Co., Inc.
Keywords:  program testing  Regulatory submission  validation 
Pages: 4 Size: 30 Kb 
Hands-On Workshops
tweet!  Good Table Manners with PROC TABULATE
  Cynthia Zender, SAS Institute
Keywords:  tabulate 
Pages: 1 Size: 10 Kb    Download the codedownload (.zip, 1872 Kb)
tweet!  A Hands-on Introduction to SAS 9.1.3 ODS
  Brian C. Shilling, Applied Clinical Intelligence
Keywords:  ODS  RTF  PDF  XML  HTML 
Pages: 5 Size: 185 Kb 
tweet!  Get Experience with New SAS Drug Development Software
  Dana Rafiee, Destiny Corporation
Keywords:  Drug Development  ASP  FDA  Reporting  Analysis  Data Management 
Pages: 5 Size: 108 Kb 
tweet!  There's No Such Thing as Normal Clinical Trials Data, or Is There?
  Daphne Ewing, Octagon Research Solutions, Inc.
Keywords:  PROC REPORT  Normalized data  Reporting  Summary Tables 
Pages: 14 Size: 153 Kb    Download the codedownload (.zip, 310 Kb)
tweet!  Validating Data Using SAS Formats As A Programming Tool
  John R. Gerlach, ASG
Keywords:  Data Validation  SAS Formats  Macro Language 
Pages: 11 Size: 97 Kb    Download the codedownload (.zip, 250 Kb)
tweet!  How SAS Thinks
  Neil Howard, i3 Statprobe
Keywords:  PDV  Program Data Vector  SAS supervisor  defaults  missing data  compile  execute 
Pages: 20 Size: 384 Kb    Download the codedownload (.zip, 346 Kb)
tweet!  PROC REPORT Basics: Getting Started with the Primary Statements
  Art Carpenter, CA Occidental Consultants
Pages: 9 Size: 124 Kb    Download the codedownload (.zip, 14 Kb)
tweet!  Moving Data and Analytical Results between SAS and Microsoft Office
  Vincent DelGobbo, SAS Institute
Keywords:  Microsoft Office  HTML  XML  Words  Excel  import  ODS 
Pages: 20 Size: 1341 Kb    Download the codedownload (.zip, 4889 Kb)
tweet!  Retrieving SAS Programs Back From PDF Files
  Eric A. Zhang, Centocor, Inc.
Keywords:  PDF2PGM  PGM2PDF  Macro  PDF Files  SAS Programs 
Pages: 6 Size: 296 Kb 
tweet!  Using V9 ODS LAYOUT to Simplify Generation of Individual Case Summaries
  Ling Chen, Rho, Inc
Pages: 8 Size: 40 Kb 
Best Paper
tweet!  Advanced Array Applications in Clinical Data Manipulation
  Jane Lu, AstraZeneca
Keywords:  Array  Advanced Array Application  Data Manipulation 
Pages: 9 Size: 35 Kb 
tweet!  Speed Up Your SAS Programs
  Karthikeyan Chidambaram, Cognizant Technology Solutions
Pages: 5 Size: 44 Kb 
tweet!  Integrated presentation of clinical data with graph and text
  Binbin Zhang, Novartis; Wei V. Wang, Eli Lilly Canada; Sunny J. Xie, Forest Research Institute
Keywords:  graph  schewart  boxplot  integration 
Pages: 8 Size: 255 Kb 
tweet!  Building Dynamic Informats Formats
  Michael zhang, Merck & Co., Inc.
Keywords:  Proc Format  Informats  Formats  Ranges 
Pages: 8 Size: 117 Kb 
tweet!  XML Basics for SAS Programmers
  Yong G. Li, sanofi-aventis
Keywords:  XML  HTML  XPT  SAS MXL Engine  ODS 
Pages: 5 Size: 101 Kb 
tweet!  Understanding the Inner Working of SAS
  Yan Lei, Centocor Inc.
Pages: 5 Size: 26 Kb 
tweet!  Icon Do It!
  William C. Csont, H.M. Proskin & Associates, Inc.
Keywords:  Icon  config  autoexec 
Pages: 4 Size: 130 Kb 
tweet!  A Better Perspective of SASHELP Views
  John R. Gerlach, ASG
Keywords:  Meta-data  Dictionary Tables  Relational Schema 
Pages: 7 Size: 231 Kb 
tweet!  Pharmaceutical Programming: From CRFs to Tables, Listings and Graphs, a process overview with real world examples
  Mark Penniston, Omnicare Clinical Research
Keywords:  CRF  SAP  Derived dataset  protocol 
Pages: 8 Size: 114 Kb 
tweet!  Applications for Running DOS Commands within SAS
  Na Li, Pharmacyclics, Inc.
Keywords:  DOS  X statement  Permission attributes  File directory 
Pages: 5 Size: 182 Kb 
tweet!  Program Templates for Report Generation
  Roger J. DeAngelis, AMGEN
Keywords:  Report  ODS  Template 
Pages: 9 Size: 164 Kb 
tweet!  A SAS Macro for Generating Informative Cumulative/Point-wise Bar Charts
  Mao Xuejing, Eli Lilly and Company; Mario Widel, Eli Lilly and Company
Keywords:  Bar Chart Macro Generator  Cumulative Chart  Point-wise Chart 
Pages: 5 Size: 107 Kb 
tweet!  User-Specified Text Flow Inside the Report Procedure
  Donald W. Peterson, AstraZeneca; Taghi R. Garacani, AstraZeneca
Keywords:  User-Specified  Text Flow  Report Procedure 
Pages: 5 Size: 31 Kb 
tweet!  Extending the SAS environment with Trellis Graphics
  Chris Thornton, Insightful; Sven Knudsen, Insightful; Michael O'Connell, Insightful
Keywords:  Graphics  ODS  S-PLUS  integrate  visual communication  clinical data 
Pages: 7 Size: 186 Kb 
tweet!  Analyze group-randomized trial data using weighted paired t-test
  Don (Dongguang) Li, NCIC-CTG
Keywords:  Group-randomized trial  Binary Outcome  Weighted paired t-test  SAS Macro 
Pages: 5 Size: 65 Kb 
2nd Best Paper
tweet!  To Macro Or Not To Macro
  Amy E. Gillespie, Merck & Co., Inc.
Keywords:  SAS Macro Library  Metrics  Efficiency 
Pages: 8 Size: 60 Kb 
tweet!  PREFTAB-A macro to automatically create adverse event tables
  Wilfried Esken, PRA International Walter Leskopf, PRA International; Christoph Gross, PRA International; Hansjörg Frenzel, PRA International
Keywords:  adverse events  frequency tables  recursive algorithm  macro 
Pages: 11 Size: 92 Kb 
tweet!  %SETUP - A Utility Macro to Build Directory Structures and a SAS Initialization Program
  Guowei Wu, Merck & Co., Inc.
Keywords:  Initialization Program  Standard Directory Structure  Portable  macro 
Pages: 7 Size: 92 Kb 
tweet!  Automatic Parameter Checking
  Greg Silva, Biogen Idec
Keywords:  parmbuff  syspbuff  macro  parameter 
Pages: 4 Size: 157 Kb 
tweet!  An Approach Finding the Right Tolerance Level for Clinical Data Acceptance
  Karen E. Walker, Walker Consulting LLC
Keywords:  error rate  edit checks  rank  manual review  clinical data  data audit 
Pages: 6 Size: 92 Kb 
tweet!  De Morgan's Laws Revisited: To Be AND/OR NOT To Be
  Raoul A. Bernal, Medical Affairs, Amgen
Keywords:  Boolean  DeMorgan  tautology 
Pages: 4 Size: 84 Kb 
tweet!  A Macro to Generate a Study Report
  Hany A. Aboutaleb, Biogen Idec
Keywords:  Report  Inventory  Study Report  macro 
Pages: 10 Size: 192 Kb 
tweet!  Useful Techniques for Enhancement of SAS/GRAPH Output
  Louie Huang, Baxter BioScience
Pages: 8 Size: 369 Kb 
tweet!  Exploring DICTIONARY Tables and Views
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords:  Dictionary Tables  Dictionary Views  read-only tables  read-only views 
Pages: 6 Size: 565 Kb 
tweet!  Object Oriented Programming, Mimic it in SAS
  Fuping Peng, Eisai Medical Research
Keywords:  Modular design  Patient profile  Base SAS  Macro 
Pages: 3 Size: 36 Kb 
tweet!  Two SAS Programming Techniques for Annotating Graphs
  Lingling Xie, Eli Lilly and Company
Keywords:  annotate  gplot gchart 
Pages: 3 Size: 31 Kb 
tweet!  The Power of PROC SQL Techniques and SAS Dictionary Tables in Handling Data
  MaryAnne D. Hope, Health Services Advisory Group Fen Fen Li, Health Services Advisory Group
Keywords:  PROC SQL  Dictionary Tables  VCOLUMN  VTABLE 
Pages: 6 Size: 115 Kb 
tweet!  A Hackers Guide to SAS Environment Customization
  Brian P. Fairfield-Carter, PRA International Stephen Hunt, PRA International
Keywords:  Configuration  Code templates  VBScript  Windows Shell 
Pages: 12 Size: 129 Kb 
tweet!  Play Nice with Others: Waiting for a Lock on a SAS Table
  John P. Leveille, d-Wise Technologies, Inc.; Jimmy Hunnings, d-Wise Technologies, Inc.
Keywords:  lock  wait  batch  contention  macro  timeout  multiple 
Pages: 4 Size: 132 Kb 
tweet!  Using SAS to automate the process of microarrays data normalization
  Don (Dongguang) Li, NCIC-CTG Lei Qin, Cacer Research Institute, Queen's Univ
Keywords:  Microarray data analysis  Normalization  SAS automation 
Pages: 7 Size: 2836 Kb 
tweet!  A Simple, Inexpensive Solution to the Dilemma of SAS Training
  Erin M. Christen, Statprobe, Inc.
Keywords:  training  tips  tricks 
Pages: 4 Size: 37 Kb 
tweet!  A Switchboard as A Information Kit for Programmers and Statisticians
  Rubin Nan, PRA International; Kent Letourneau, PRA International
Keywords:  GUI  Visual Basic  Interface 
Pages: 4 Size: 54 Kb 
tweet!  Program Flow Design for Efficient CRT Programming
  Sam Mao, Quintiles, Inc.; Sid G. Morris, Quintiles, Inc.
Keywords:  CRT  CDISC  SDM  SDTM  SDS  Programming Flow Design 
Pages: 10 Size: 100 Kb 
tweet!  A Microsoft Work Macro for Post-processing of ODS RTF files
  Susan A. Parker, ZymoGenetics
Keywords:  ODS RTF  medical writing  post-processing  macro 
Pages: 2 Size: 25 Kb    Download the codedownload (.zip, 387 Kb)
tweet!  SAS Macros to Match Data from External Data Sources
  Arkady M. Kushnir, AmEx
Keywords:  SAS  macro  %LET  PROC FORMAT  PROC SQL 
Pages: 6 Size: 54 Kb 
tweet!  Some Statistical Programming Considerations for e-Submission
  Hang Pang, sanofi-aventis Pharma Inc.
Keywords:  e-Submission  Define.pdf  Statistical Review Aids  SAS Data Transport File 
Pages: 6 Size: 179 Kb 
tweet!  A SAS Macro to Automate Listings
  Elizabeth R. Taylor, Endo Pharmaceuticals Inc.
Keywords:  Macros  Listings 
Pages: 5 Size: 274 Kb 
tweet!  Creating Efficient SQL - The De-normalize Transpose
  Paul D. Sherman, Independent
Keywords:  SQL  query  database  beancounting  data modeling  data warehouse  normalization  pass-through  table  select 
Pages: 14 Size: 199 Kb 
Public Health Research
tweet!  Analyzing Clinical Drug Utilization
  Jianming He, Solucient; Brian Griffin, Solucient
Keywords:  drug utilization  drug switching  drug combo therapy 
Pages: 10 Size: 426 Kb 
tweet!  Data Mining Medication Prescriptions for a Representative National Sample
  Patricia B. Cerrito, University of Louisville; Antonio Badia, University of Louisville; John C. Cerrito, Statistical Consulting of Louisville,
Keywords:  Enterprise Miner  text miner  clinical databases 
Pages: 13 Size: 546 Kb 
tweet!  Want to Do a Better Job? - Want to Do a Better Job? - Select Appropriate Statistical Analysis in Healthcare Research
  Liping Huang, Visiting Nurse Service of New York
Keywords:  proper statistical tests  outcome comparison  healthcare 
Pages: 7 Size: 51 Kb 
Best Paper
tweet!  Assessing within- and between-subject effects with correlated clinical data
  Marla J. Husnik, Fred Hutchinson Cancer Research Center; Yijian (Eugene) Huang, Emory University, Rollins; Grant Colfax, San Francisco Department of Public Health
Keywords:  non-linear mixed models  Proc NLMIX  conditional logistic regression  Proc PHREG  generalized estimating equations  Proc GENMOD  data  correlated  clinical  study  randomized  screening  HIV  EXPLORE 
Pages: 10 Size: 106 Kb 
tweet!  Programming & Data Differences Between Clinical Trial & Observational Studies
  Margaret M. Coughlin, Merck
Pages: 6 Size: 50 Kb 
tweet!  Don't Stay up Late Completing your Late-Phase Analysis!
  Kathleen A. Kushner, Covance Periapproval; Philip L. Pellicone, Covance Periapproval
Keywords:  Post-Marketing  Late-Phase  Data Collection  Data Cleaning  SAP 
Pages: 8 Size: 167 Kb 
SAS Institute
tweet!  Tips and Tricks: Using SAS/Graph Effectively
  A. Darrel Massengill, SAS Institute
Keywords:  Graphs  SAS/GRAPH 
Pages: 15 Size: 464 Kb 
tweet!  An Introduction to ODS for Statistical Graphics in SAS 9.1
  Robert N. Rodriguez, SAS Institute
Keywords:  ODS  Graphics 
Pages: 27 Size: 7629 Kb 
tweet!  Pharmacovigilance and Drug Safety Reporting Algorithms (Content and Process)
  David Olaleye, SAS Institute
Keywords:  CDISC  FDA 
Pages: 8 Size: 145 Kb 
tweet!  SAS® Dataset Content Conversion to CDISC Data Standards
  Anthony Friebel, SAS Institute; Thomas Cox, SAS Institute; Edward Helton, SAS Institute
Keywords:  CDISC  ODM  metadata 
Pages: 10 Size: 486 Kb 
Statistics & Pharmacokinetics
tweet!  A SAS Macro for Analyzing Quality of Life data: NCIC-CTG standard Method
  Don (Dongguang) Li, NCIC-CTG
Keywords:  Health Related Quality of Life (HRQOL)  Statistical analysis  SAS macros 
Pages: 5 Size: 35 Kb 
tweet!  Smoothing pharmacokinetic and pharmacodynamic profiles
  Naum M. Khutoryansky, Novo Nordisk, Inc.
Keywords:  Smoothing  Pharmacokinetic Profiles  Nonlinear Regression 
Pages: 5 Size: 159 Kb 
tweet!  Using Procedure-Based ODS Data Components in Statistical Reporting
  Vincent J. Faber, DM-STAT,Inc.
Keywords:  ODS  Output  Delivery  Results  Components  Propensity 
Pages: 10 Size: 74 Kb 
tweet!  Calculating posterior probability of the maximum contrast using proc iml
  Akira Wakana, Banyu Pharmaceutical Co., Ltd.; Isao Yoshimura, Tokyo University of Science; Chikuma Hamada, Tokyo University of Science
Keywords:  phase II clinical trial  dose-response  contrast 
Pages: 6 Size: 73 Kb 
tweet!  Power Analysis and Sample Size Estimation using Bootstrap
  Xiaomei Peng, Eli Lilly and Company
Keywords:  Simulatioin  Statistical power  Sample size  Bootstrap 
Pages: 7 Size: 30 Kb 
tweet!  %KMPlot - An Enhancement of SAS PROC Lifetest
  Weifeng Xu, merck
Keywords:  SAS PROC LIFETEST  Kaplan-Meier  Survival Analysis  SAS Macro 
Pages: 8 Size: 163 Kb 
tweet!  Noncompartmental pharmacokinetics and bioequivalence analysis
  Arturo Soto-Matos, PharmaMar; Bernardo de Miguel-Lillo, PharmaMar
Keywords:  pharmacokinetics  noncompartmental  bioequivalence 
Pages: 10 Size: 275 Kb 
Best Paper
tweet!  Analyzing and Displaying Study Data in Clinical Trials Made Easy
  Denise J. Smith, Mayo Clinic - Cancer Center Statistics
Keywords:  QOL  macros  graphs  tables 
Pages: 15 Size: 210 Kb 
Technical Techniques
tweet!  Understanding WHERE Clause Processing and Indexes
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords:  Index  WHERE clause  query  performance 
Pages: 4 Size: 356 Kb 
tweet!  Using SAS Enterprise Guide in a Global Programming Environment
  Karen K. Curran, Omnicare Clinical Research
Keywords:  SAS  Enterprise Guide  EG  Unix 
Pages: 5 Size: 94 Kb 
tweet!  The Use and Abuse of the Program Data Vector (The Procs)
  Jim Johnson, Covance
Keywords:  Print  Sort  Freq  SQL  program data vector 
Pages: 17 Size: 187 Kb 
tweet!  Make 'em %LOCAL: Avoiding Macro Variable Collisions
  Art Carpenter, CA Occidental Consultants
Keywords:  Macro variables  macro symbol tables  %LOCAL  macro variable collisions 
Pages: 4 Size: 96 Kb 
tweet!  Job Security: Using the Macro Language to Full Advantage
  Art Carpenter, CA Occidental Consultants
Keywords:  Macro variables  %SCAN  macro comments  statement style macros  macro variable collisions 
Pages: 7 Size: 119 Kb 
tweet!  Selected Macro and SQL Techniques For Efficient SAS Programming
  Brian P. Fairfield-Carter, PRA International; Sam Wang, PRA International
Keywords:  SQL  interpolation  macro 
Pages: 12 Size: 97 Kb 
tweet!  SAS and Oracle PL/SQL: Partners or Competitors?
  Stanley E. Fogleman, HCRI
Keywords:  SQL  PL/SQL  ORACLE 
Pages: 5 Size: 46 Kb 
tweet!  Developing Varargs Macros For Integrated Clinical Study Analysis and Reporting
  Lei Zhang, Merck & Co. Inc.; George Li, Amgen Inc.
Keywords:  Varargs Macro  variable argument  PBUFF  default argument  keyword argument  scalability  standard macro  integrated clinical study analysis and reporting 
Pages: 10 Size: 293 Kb 
tweet!  Use ODS Generating Patient Profiles
  Haibin Shu, Duramed Research; Zhuge Young, Duramed Research
Keywords:  ODS  Patient Profile  Modules  Efficient  Portable 
Pages: 6 Size: 228 Kb 
tweet!  What Would I Do without PROC SQL and the Macro Language?
  Jeffrey M. Abolafia, Rho, inc.
Keywords:  SQL  Macro 
Pages: 5 Size: 193 Kb 
tweet!  Proc Telecommute
  Susan Bairnsfather, PharmaNet, Inc; Angela S. Ringelberg, PharmaNet, Inc.
Keywords:  Telecommute  Telework  Benefits  Challenges  Productivity 
Pages: 5 Size: 31 Kb 
tweet!  ADVANCE TIPS for Manipulating Data in Commonly used Procedures.
  RAJ S. SULIGAVI, HTC Global Services Inc.; Jyotheeswara N. Yellanki, Systems analyst
Keywords:  Abort  Stop  Propcase  Scan  Substr  If  Where  OBS  FIRSTOBS  DO  Leave  List  Informat  Put  Colon Opeartor  MOD operator  In operator  PROC SQL  PROC SORT  PROC REPORT 
Pages: 11 Size: 243 Kb 
tweet!  Rules for Tools - The SAS Utility Primer
  Frank C. DiIorio, CodeCrafters, Inc.
Keywords:  application development  dictionary tables  utilities  program development 
Pages: 19 Size: 684 Kb 
Best Paper
tweet!  Programming Tips and Examples for Your Toolkit, II
  John Morrill
Keywords:  Concordance  tips  array  null  put  merge  multilevel  indicator  comment 
Pages: 12 Size: 91 Kb 
2nd Best Paper
tweet!  How To Get Ten Pounds Of Data Into A Five Pound Can
  Daniel K. Downing, CaremarkPCS
Keywords:  FLYOVER  HTML  ODS 
Pages: 7 Size: 53 Kb    Download the codedownload (.zip, 2 Kb)
tweet!  Visualizing Minimum Spanning Tree (Working with Pharmacal Genetic data)
  Zhuoye Xu, Merck & Co., Inc; Xiaohui Wang, Merck & Co., Inc.
Keywords:  Minimum spanning tree  data presentation  haplotype  genetic 
Pages: 6 Size: 116 Kb 
tweet!  Looking for a Date? A Tutorial on Using SAS Dates and Times
  Art Carpenter, CA Occidental Consultants
Keywords:  date  time  format  INTNX  INTCK  date literal  shift operator  alignment options 
Pages: 13 Size: 246 Kb 
Best Paper
tweet!  An Introduction to Regular Expressions with Examples from Clinical Data
  Richard F. Pless, Ovation Research Group
Keywords:  regular expressions  Perl  regex  text processing 
Pages: 8 Size: 49 Kb 
2nd Best Paper
tweet!  Retaining, Lagging, Leading, and Interleaving Data
  Toby Dunn, Texas Eductation Agency; Chang Chung, Office of Population Research, Princet
Keywords:  RETAIN statement  LAG function  lead technique  interleaving  Schreier Self-interleave  DoW  Double DoW  SQL 
Pages: 8 Size: 47 Kb 
tweet!  Markup 101: Markup Basics
  Cynthia Zender, SAS Institute
Keywords:  Markup  HTML  XML  Tagsets  ODS 
Pages: 16 Size: 426 Kb 
Powered by SAS®.
SAS® and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries.
Copyright © 1999-2017 Lex Jansen. All rights reserved.