Home
Contact
SAS Paper Search
SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PharmaSUG China papers
SAS:PhUSE papers
FDA/PhUSE CSS posters
SAS:PNWSUG papers
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
India
South America

Powered by SAS® 9.01.01M3P02162005.

Valid XHTML 1.0 Transitional

Google
  Search results
SAS PharmaSUG proceedings: Macros, 382 papers

Pharmaceutical SAS Users Group 2017   May 14-17, 2017 - Baltimore, Maryland

tweet!  Challenge for Dramatic Streamlining of TLFs Creation Process with SAS and Java
  Yohei Takanami, Takeda Pharmaceutical Company, Ltd.; Fumihiro Yamasaki, Takeda Pharmaceutical Company, Ltd.
Keywords: Report ODS System Standardization Java TLF Macro CDISC ADaM GUI
Pages: 8 Size: 443 Kb 
tweet!  Integration of multiple files into a study report using Word VBA macros
  Heather Wood, DCRI; Jack Shostak, DCRI
Keywords: integration Word VBA report macro
Pages: 10 Size: 544 Kb 
tweet!  SAS Macro for Derivation of Best Overall Response per RECIST v. 1.1
  Bob Zhong, Johnson & Johnson; Jiangfan Li, Johnson & Johnson; Hong Xie, Johnson & Johnson; Peter De Porre, Johnson & Johnson; Kenneth Maahs, Johnson & Johnson; Kyounghwa Bae, Johnson & Johnson
Keywords: RECIST 1.1 Best Overall Response Confirmed CR/PR Unconfirmed CR/PR CR PR uCR uPR SD PD NE SAS Macro Tool
Pages: 9 Size: 834 Kb 
Best Paper
tweet!  Making Documents 'Intelligent' with Embedded Macro Calls, DOSUBL and Proc STREAM: An example with the CONSORT Flow Diagram
  Joseph Hinson, inVentiv Health
Keywords: CONSORT Proc STREAM DOSUBL SYSFUNC , macro
Pages: 15 Size: 451 Kb 
tweet!  I've Got to Hand It to You; Portable Programming Techniques
  Art Carpenter, CA Occidental Consultants
Keywords: Macro %SYSGET AUTOEXEC %SYSFUNC portable SAS_EXECFILEPATH Batch submissions UNIX Windows
Pages: 21 Size: 417 Kb 
tweet!  A Macro to carry values through observations forwards or backwards over null values within a by group or a SAS(R) dataset.
  Timothy Harrington, SAS Programmer
Keywords: by group processing macro
Pages: 9 Size: 56 Kb 
tweet!  The %NEWSURV Family of Macros: An Update on the Survival Plotting Macro %NEWSURV and an Introduction to Expansion Macros
  Jeffrey Meyers, Mayo Clinic
Keywords: Survival Graphics Analysis Macros Adjusted Survival
Pages: 21 Size: 966 Kb 
tweet!  Five Ways to Create Macro Variables: A Short Introduction to the Macro Language
  Art Carpenter, CA Occidental Consultants
Keywords: macro
Pages: 12 Size: 99 Kb 
tweet!  ClinicalTrials.gov Results: an End of Study Deliverable That Should Be Considered at Study Startup
  Maya Barton, Rho; Elizabeth Paynter, Rho
Keywords: ClinicalTrials.gov Project Management Results Standardization Macro
Pages: 9 Size: 135 Kb 
tweet!  Generating Colors from the Viridis Color Scale with a SAS® Macro
  Shane Rosanbalm, Rho, Inc
Keywords: vidiris macro
Pages: 8 Size: 1046 Kb 
tweet!  Building Intelligent Macros: Using Metadata Functions with the SAS® Macro Language
  Art Carpenter, CA Occidental Consultants
Keywords: Metadata macro language DATA step functions %SYSFUNC OPEN ATTRN ATTRC FETCH CLOSE
Pages: 17 Size: 478 Kb 

Pharmaceutical SAS Users Group 2016   May 8-11, 2016 - Denver, Colorado

tweet!  The Benefits and Know-how of Building a Central CDISC-Terminology Dictionary with a Macro System
  Solomon Lee, Ph D, South San Francisco, CA; Ronghai Bo, Medicine, WI
Keywords: CDISC macro
Pages: 4 Size: 30 Kb 
tweet!  DOSUBL and the Function Style Macro
  John Henry King, Ouachita Clinical Data Services, Inc. Caddo Gap, AK
Keywords: DOSUBL MACRO FUNCTION
Pages: 6 Size: 456 Kb 
tweet!  Macro to get data from specific cutoff period
  Kiranmai Byrichetti, SCRI, Nashville, TN; Jeffrey Johnson, SCRI, Nashville, TN
Keywords: macro
Pages: 11 Size: 375 Kb 
tweet!  What's Hot – Skills for SAS® Professionals
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS, SAS skills, what's hot, what's hot in sas, the hottest topics in sas are, what's not so Hot, Enterprise Guide, EG, hash objects, ODS, PROC SQL, SQL, PROC REPORT, Macro Language, Dictionary Tab ...
Pages: 6 Size: 558 Kb 
tweet!  Hands-On SAS® Macro Programming Essentials for New Users
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS, Macro Language, macro, keyword macro, positional macro, SQL, SQL procedure, consultant, SAS consultant, consulting, SAS consulting, sql, sql consultant, sql consulting, author, sas author, sas ...
Pages: 10 Size: 617 Kb 
Best Paper
tweet!  PrecMod: An Automated Precision SAS® Macro for Random Effects Models
  Jesse A. Canchola, Roche Molecular Diagnostics, Pleasanton, CA; Pari Hemyari, Roche Molecular Diagnostics, Pleasanton, CA
Keywords: macro
Pages: 15 Size: 405 Kb 
tweet!  SAS Macro for Summarizing Adverse Events
  Julius Kirui, Sarah Cannon Research Institute, Nashville, TN; Rakesh Mucha, Sarah Cannon Research Institute, Nashville, TN
Keywords: macro
Pages: 11 Size: 938 Kb 
tweet!  SDTM Automation with Standard CRF Pages
  Taylor Markway, SCRI Development Innovations, Carrboro, NC
Keywords: CDISC SDTM Macro Automation Pharmaceutical SAS Programming
Pages: 10 Size: 338 Kb 
tweet!  Log Checks Made Easy
  Yogesh Pande, Merck Sharp & Dohme Corp., Rahway, NJ
Keywords: SAS Log Macro report infile print
Pages: 4 Size: 409 Kb 
tweet!  A SAS Macro Tool to Automate Generation of Customized Patient Profile in PDF Documents
  Haining Li, Massachusetts General Hospital, Boston, MA; Merit E. Cudkowicz, Massachusetts General Hospital, Boston, MA; Hong Yu, Massachusetts General Hospital, Boston, MA
Keywords: Customized Patient Profile PDF document macro
Pages: 6 Size: 326 Kb 
tweet!  Selecting Analysis Dates - A Macro Approach Using Raw Data for Expediting Results
  Abdul Ghouse, Seattle Genetics, Inc., Bothell, WA
Keywords: TTE macro efficacy
Pages: 4 Size: 70 Kb 
tweet!  Breaking up (Axes) Isn’t Hard to Do: A Macro for Choosing Axis Breaks
  Alex Buck, Rho®, Chapel Hill, NC
Keywords: macro
Pages: 6 Size: 402 Kb 
tweet!  PROC SQL: To Create Macro Variables with Multiple Values and the Uses in Clinical Programming
  Anish Kuriachen, inVentiv Health Clinical, NJ
Keywords: Proc Sql macro
Pages: 4 Size: 81 Kb 
tweet!  A Macro to Automatically Flag Baseline in SDTM
  Taylor Markway, SCRI Development Innovations, Carrboro, NC
Keywords: Pharmaceutical SAS Macro Baseline SDTM Automation CDISC
Pages: 8 Size: 250 Kb 
tweet!  SAS® Abbreviations: a Shortcut for Remembering Complicated Syntax
  Yaorui Liu, Department of Preventive Medicine, University of Southern California, Los Angeles, CA
Keywords: SAS Abbreviation Enhanced Editor Macro
Pages: 8 Size: 642 Kb 
tweet!  A SAS® Macro Tool to Automate Generation of Define.xml V2.0 from SDTM Specification for FDA Submission
  Min Chen, Alkermes Inc., Waltham, MA; Xiangchen (Bob) Cui, Alkermes Inc., Waltham, MA
Keywords: CDISC macro xml
Pages: 24 Size: 751 Kb 
tweet!  Let’s Make Music: Using SAS® Functions for Music Composition
  Kim Truett, KCT Data, Inc., Alpharetta, GA; Zak Truett, KCT Data, Inc., Alpharetta, GA
Keywords: SAS Music macro improvisation
Pages: 8 Size: 193 Kb 
tweet!  Capturing Macro Code when Debugging in the Windows Environment: The Power of MFILE and the Simplicity of Pasting
  Kevin R. Viel, Ph.D., inVentiv Health Clinical, Atlanta, GA
Keywords: SAS Macro debug MFILE MPRINT clipboard pipe log paste INFILE
Pages: 10 Size: 102 Kb 

Pharmaceutical SAS Users Group 2015   May 17-20, 2015 - Orlando, Florida

tweet!  A SAS® Macro Tool to Automate Generation of Define.xml V2.0 from ADaM Specification for FDA Submission
  Min Chen, Alkermes Inc., Waltham, MA; Xiangchen (Bob) Cui, Alkermes Inc., Waltham, MA
Keywords: CDISC macro xml
Pages: 28 Size: 910 Kb 
tweet!  Implementing Union-Find Algorithm with Base SAS DATA Steps and Macro Functions
  Chaoxian Cai, AFS, Exton, PA
Keywords: Union-Find grouping disjoint set connected components macros
Pages: 11 Size: 1083 Kb 
tweet!  Is Your Failed Macro Due To Misjudged “Timing”?
  Arthur Li, City of Hope Comprehensive Cancer Center, Duarte, CA
Keywords: macro
Pages: 22 Size: 1396 Kb 
tweet!  Generic Macros for Data Mapping
  Qian Zhao, J&J Consumer Companies, Inc., Morris Plains, NJ; Jun (John) Wang, J&J Consumer China Ltd, Shanghai, China; Ruofei Hao, J&J Consumer Companies, Inc., Morris Plains, NJ
Keywords: macro
Pages: 9 Size: 400 Kb 
tweet!  Macro Programming Best Practices: Styles, Guidelines and Conventions Including the Rationale Behind Them
  Don Henderson, Henderson Consulting Services, Olney, MD; Art Carpenter, California Occidental Consultants, Anchorage, AK
Keywords: macro
Pages: 1 Size: 102 Kb 
tweet!  What's Hot, What's Not: Skills for SAS® Professionals
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA; Charles Edwin Shipp, Consider Consulting Corporation, San Pedro, CA
Keywords: SAS, SAS skills, what's hot, what's hot in sas, the hottest topics in sas are, what's not so Hot, Enterprise Guide, EG, hash objects, ODS, PROC SQL, SQL, PROC REPORT, Macro Language, Dictionary Tab ...
Pages: 6 Size: 556 Kb 
tweet!  An Enhanced Forest Plot Macro Using SAS®
  Janette Garner, Gilead Sciences, Inc., Foster City, CA
Keywords: macro
Pages: 9 Size: 553 Kb 
tweet!  Are You a Control Freak? Control Your Programs – Don’t Let Them Control You!
  Mary F. O. Rosenbloom, Edwards Lifesciences LLC, Irvine, CA; Art Carpenter, California Occidental Consultants, Anchorage, AK
Keywords: Control file macro list CALL SYMPUTX CALL EXECUTE macro language macro arrays Rosenbloom Carpenter
Pages: 20 Size: 264 Kb 
Best Paper
tweet!  A General SAS® Macro to Implement Optimal N:1 Propensity Score Matching Within a Maximum Radius
  Kathy H. Fraeman, Evidera, Bethesda, MD
Keywords: propensity score matching radius macro
Pages: 12 Size: 360 Kb 
tweet!  The Disposition Table: Make it Easy
  Endri Endri, ProXpress Clinical Research GmbH, Berlin, Germany; Benedikt Trenggono, ProXpress Clinical Research GmbH, Berlin, Germany
Keywords: Disposition Table SAS Macro Programming Artificial Intelligence
Pages: 10 Size: 331 Kb 
tweet!  Efficiently Produce Descriptive Statistic Summary Tables with SAS Macros
  Chunmao Wang, Quintiles, Rockville, MD
Keywords: macro
Pages: 3 Size: 194 Kb 
tweet!  Spelling Checker Utility in SAS® using VBA Macro and SAS® Functions
  Ajay Gupta, PPD, Morrisville, NC
Keywords: macro
Pages: 7 Size: 241 Kb 
Best Paper
tweet!  Macro to Read Mock Shells in Excel and Create a Copy in Rich Text Format
  Rakesh Mucha, Sarah Cannon Research Institute, Nashville, TN; Jeffrey Johnson, Sarah Cannon Research Institute, Nashville, TN
Keywords: SAP Statistical Analysis Plan Mock Shells Shells Converting Shells in Excel to RTF Shells from Excel to Word macro
Pages: 11 Size: 394 Kb 
tweet!  ISPLIT Macro: to split large SAS datasets
  Hany Aboutaleb, Biogen, Cambridge, MA
Keywords: macro
Pages: 4 Size: 448 Kb 
tweet!  Let SAS Generate XML Code for ACCESS Audit Trail Data Macro
  Sijian Zhang, VA Medical Center, Washington, DC
Keywords: macro xml
Pages: 8 Size: 520 Kb 
tweet!  A Simple Macro to Select Various Variables Lists
  Ting Sa, Cincinnati Children’s Hospital, Cincinnati, OH; Yanhong Liu, Cincinnati Children’s Hospital, Cincinnati, OH
Keywords: macro
Pages: 5 Size: 46 Kb 
tweet!  A Macro to Easily Generate a Calendar Report
  Ting Sa, Cincinnati Children’s Hospital Medical Center, Cincinnati, OH
Keywords: macro
Pages: 7 Size: 106 Kb 
tweet!  A Macro to Produce a SAS® Data Set Containing the List of File Names Found in the Requested Windows or UNIX Directory
  Mike Goulding, Experis, Portage, MI
Keywords: macro directory function
Pages: 7 Size: 295 Kb 
tweet!  Mlibcompare – keep an eye on the changes of your data
  Wen Shi, Accenture, Berwyn, PA
Keywords: mlibcompare macro changes cuts of data
Pages: 29 Size: 569 Kb 
tweet!  MMRM: Macro for Selecting Best Covariance Structure with the Method of Interest
  Linga Reddy Baddam, inVentiv Health Clinical, Hyderabad, India; Sudarshan Reddy Shabadu, inVentiv Health Clinical, Hyderabad, India; Chunxue Shi, inVentiv Health Clinical, Maryland, USA
Keywords: MMRM Mixed Model Repeated Measures Missing at Random pattern (MAR) macro
Pages: 7 Size: 84 Kb 
tweet!  %PIC_NPMLE: A SAS Macro For Nonparametric Estimation In Partly Interval-Censored Survival Data
  Liang Zhu, St. Jude Children’s Research Hospital, Memphis, TN; Yimei Li, St. Jude Children’s Research Hospital, Memphis, TN; Qinlei Huang, St. Jude Children’s Research Hospital, Memphis, TN
Keywords: macro
Pages: 12 Size: 556 Kb 
tweet!  SAS® Programming Tips, Tricks and Techniques for Programmers
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS programming and techniques options logic case logic ODS Output Delivery System macro macro programming Lafler Kirk Lafler Kirk Paul Lafler sasNerd
Pages: 16 Size: 984 Kb 
Reusability, Macros, and Automation in SAS Clinical Data Integration
  Melissa R. Martinez, SAS
Keywords: macro

Pharmaceutical SAS Users Group 2014   June 1-4, 2014 - San Diego, California

tweet!  Macro Programming via Parameter Look-Up Tables
  Joseph Hinson, Accenture Life Sciences, Berwyn, PA
Keywords: Macro Parameters Look-up Tables Clinical Summary Reports
Pages: 9 Size: 934 Kb 
Best Paper
tweet!  Let SAS© Improve Your CDISC Data Quality
  Wayne Zhong, Accenture, Berwyn, PA
Keywords: data quality CDISC data driven macros
Pages: 12 Size: 501 Kb 
tweet!  Managing the Organization of SAS® Format and Macro Code Libraries in Complex Environments Including PC SAS, SAS® Enterprise Guide®, and UNIX SAS
  Roger D. Muller Ph.D., Data-To-Events, Inc., Carmel, IN
Keywords: macro
Pages: 9 Size: 673 Kb 
tweet!  D is for Dynamic, putting Dynamic back into CDISC (A simple macro utilizing PROC SQL which auto-formats continuous variables for lab tables)
  Steven Black, SynteractHCR, Carlsbad, CA
Keywords: PROC SQL MACO Language SAS functions CDISC Paramn AVAL macro
Pages: 9 Size: 81 Kb 
tweet!  I Object: SAS® Does Objects with DS2
  Peter Eberhardt, Fernwood Consulting Group Inc., Toronto, ON; Xue Yao, Winnipeg Regional Health Authority, Winnipeg, MB
Keywords: DS2 object oriented parallel HPA performance macro methods functions data types
Pages: 29 Size: 202 Kb 
tweet!  Basics of Macro Processing - ‘Q’ Way
  Usha Kumar, inVentiv Health Clinical, Pune, Maharashtra, India
Keywords: MACRO PROCESSING STAGES PHASES COMPILATION EXECUTION BASICS FUNDAMENTAL QUOTING FUNCTION CHARACTER STRING %NRSTR %STR %NRQUOTE %BQUOTE DEBUG
Pages: 9 Size: 44 Kb 
tweet!  Kaplan-Meier Survival Plotting Macro %NEWSURV
  Jeffrey Meyers, Mayo Clinic, Rochester, MN
Keywords: Kaplan-Meier Survival Graphics Macro Graph Template Language
Pages: 19 Size: 665 Kb 
tweet!  A SAS® Macro Utility to Modify and Validate RTF Outputs for Regional Analyses
  Jagan Mohan Achi, PPD, Austin, TX; Joshua N. Winters, PPD, Rochester, NY
Keywords: RTF Regional Analysis Book Marks Post Processing macro
Pages: 5 Size: 214 Kb 
tweet!  What's Hot, What's Not: Skills for SAS® Professionals
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA; Charles Edwin Shipp, Consider Consulting Corporation, San Pedro, CA
Keywords: SAS, SAS skills, what's hot, what's hot in sas, the hottest topics in sas are, what's not so Hot, Enterprise Guide, EG, hash objects, ODS, PROC SQL, SQL, PROC REPORT, Macro Language, Dictionary Tab ...
Pages: 6 Size: 513 Kb 
tweet!  Quotes within Quotes: When Single (‘) and Double (“) Quotes are not Enough
  Arthur L. Carpenter, California Occidental Consultants, Anchorage, AK
Keywords: Quotes Macro variable resolution Apostrophe Single quotes Double quotes parsing %BQUOTE
Pages: 6 Size: 221 Kb 
tweet!  Standardization of Confidence Intervals in PFS Tables - a Macro Approach
  John Saida Shaik, Seattle Genetics, Inc., Bothell, WA; Boxun Zhang, Seattle Genetics, Inc., Bothell, WA
Keywords: Confidence Interval Progression Free Survival Standardization SAS Macro
Pages: 4 Size: 115 Kb 
tweet!  A Macro to Automate Symbol Statements in Line Plots
  Deli Wang, Ossining, NY; Chunxia Lin, InVentiv Health Clinical, Ossining, NY
Keywords: Line Plots PROC GPLOT Symbol Statement Call Execute macro
Pages: 8 Size: 112 Kb 
tweet!  Macro to check Audit compliance and standards of SAS® programs
  Seeja Shetty, inVentiv Health Clinical, Mumbai, India
Keywords: macro
Pages: 11 Size: 270 Kb 
tweet!  BreakOnWord: A Macro for Partitioning Long Text Strings at Natural Breaks
  Richard Addy, Rho, Chapel Hill, NC; Charity Quick, Rho, Chapel Hill, NC
Keywords: SAS SDTM macro text string partition
Pages: 8 Size: 50 Kb 
tweet!  A SAS® Macro Tool for Visualizing Data Comparison Results in an Intuitive Way
  Hui Wang, Biogen Idec, Boston, MA; Weizhen Ying, Biogen Idec, Boston, MA
Keywords: SAS PROC COMPARE DATA VALIDATION macro
Pages: 12 Size: 327 Kb 
Best Paper
tweet!  Need to Review or Deliver Outputs on a Rolling Basis? Just Apply the Filter!
  Tom Santopoli, Accenture, Berwyn, PA
Keywords: Systask Command Call Execute Macro Quoting Functions CAT Function
Pages: 6 Size: 284 Kb 
tweet!  QC made easy using macros
  Prashanthi Selvakumar, Percept Pharma Services, Bridgewater, NJ
Keywords: macro
Pages: 7 Size: 200 Kb 
tweet!  Macro Makes Final Documentation Quick and Easy
  Indrani Sarkar, inVentiv Health Clinical, Indianapolis, IN; Jean Crain, inVentiv Health Clinical, Indianapolis, IN
Keywords: macro
Pages: 4 Size: 136 Kb 
tweet!  Inserting MS Word Document into RTF Output and Creating Customized Table of Contents Using SAS® and VBA Macro
  Haining Li, Neurological Clinical Research Institute, Mass General Hospital, Boston, MA; Merit E. Cudkowicz, Neurological Clinical Research Institute, Mass General Hospital, Boston, MA; Hong Yu, Neurological Clinical Research Institute, Mass General Hospital, Boston, MA
Keywords: macro
Pages: 6 Size: 82 Kb 
tweet!  Give me EVERYTHING! A macro to combine the CONTENTS procedure output and formats
  Lynn Mullins, PPD, Cincinnati, OH
Keywords: macro contents format metadata dictionary
Pages: 6 Size: 202 Kb 
tweet!  A Macro to Create Occurrence Flags for Analysis Datasets
  Ed Lombardi, Agility Clinical, Inc., Carlsbad, CA
Keywords: macro
Pages: 4 Size: 185 Kb 
tweet!  Self-fulfilling Macros Generating Macro Calls and Enabling Automation from a Specification
  Y. Christina Song, Rho, Inc, Chapel Hill, NC
Keywords: macro
Pages: 6 Size: 231 Kb 
tweet!  An Alternative Way to Create Define.XML for ADaM with SAS Macro Automation
  Yiwen Li, Gilead Sciences, Foster City, CA
Keywords: CDISC macro xml
Pages: 4 Size: 51 Kb 
tweet!  A Hands-on Introduction to SAS® Dictionary Tables
  Peter Eberhardt, Fernwood Consulting Group Inc., Toronto, ON, Canada
Keywords: SAS dictionary constraints macros table column library SQL rdbms
Pages: 15 Size: 275 Kb 
tweet!  %ME: A SAS® Macro to Assess Measurement Equivalence for Patient-Reported Outcome Measures
  Qinlei Huang, St. Jude Children’s Research Hospital, Memphis, TN
Keywords: macro
Pages: 8 Size: 455 Kb 
tweet!  Using the SAS System as a bioinformatics tool: A macro that translates BLASTn results to populate a DNA sequence database table
  Kevin Viel, inVentiv Health Clinical and Histonis, Incorporated, Atlanta, GA
Keywords: DNA RNA BLASTn Genomics Sequencing Bioinformatics Biomedical Healthcare Bioinformatics SAS Pharmacogenomics macro
Pages: 20 Size: 744 Kb 
tweet!  A Parameterized SAS Macro to Select an Appropriate Covariance Structure in Repeated Measures Data Analysis Using PROC MIXED
  Leela Aertker, Rho, Chapel Hill, NC; Paul Nguyen, Rho, Chapel Hill, NC; Charity Quick, Rho, Chapel Hill, NC
Keywords: macro
Pages: 3 Size: 117 Kb 
Best Paper
tweet!  %IC_LOGISTIC: A SAS® Macro to Produce Sorted Information Criteria (AIC/BIC) List for PROC LOGISTIC for Model Selection
  Qinlei Huang, St. Jude Children’s Research Hospital, Memphis, TN; Liang Zhu, St. Jude Children’s Research Hospital, Memphis, TN
Keywords: macro
Pages: 12 Size: 406 Kb 
tweet!  A SAS® Macro to address PK timing variables issues
  Timothy J Harrington, Dataceutics inc, Pottstown, PA
Keywords: macro
Pages: 14 Size: 71 Kb 
tweet!  A SAS® Macro to Evaluate Balance after Propensity Score Matching
  Erin Hulbert, Optum Life Sciences, Eden Prairie, MN; Lee Brekke, Optum Life Sciences, Eden Prairie, MN
Keywords: macro
Pages: 12 Size: 127 Kb 

Pharmaceutical SAS Users Group 2013   May 12-15, 2013 - Chicago, Illinois

tweet!  A GUI-Based Utility Macro for Creating a Version Controlled Project Directory Structure and Copying in Standard Tools and Template Files
  Hisham Madi, INC Research, Wilmington, NC; Anna Maeser, MS, INC Research, Wilmington, NC; Michael Zichy, MS, INC Research, Wilmington, NC
Keywords: macro
Pages: 12 Size: 189 Kb 
tweet!  Solving Samurai Sudoku Puzzles - A First Attempt
  John R Gerlach, CSG Inc., Raleigh, NC
Keywords: Sudoku SAS Macro Language
Pages: 15 Size: 380 Kb 
tweet!  A Simple Approach to the Automated Unit Testing of Clinical SAS® Macros
  Matthew Nizol, United BioSource Corporation, Ann Arbor, MI
Keywords: Test Testing Unit Test Framework Macro Validation
Pages: 12 Size: 222 Kb 
tweet!  A Macro to Batch Submit a List of Programs with Real Time Feedback
  Andrew E. Hansen, Quintiles, Columbia, MO
Keywords: SYSTASK Batch macro
Pages: 7 Size: 177 Kb 
tweet!  A Simple Interface for Metadata
  Magnus Mengelbier, Limelogic AB, Malmö, Sweden
Keywords: interface metadata data set table listing figure graph protocol statistical analysis plan sap shells sas macro program sdtm adam cdisc html javascript
Pages: 8 Size: 306 Kb 
tweet!  Submitting SAS® Code On The Side
  Rick Langston, SAS Institute Inc., Cary NC
Keywords: macro %include call execute sql dosubl run_macro proc stream
Pages: 5 Size: 135 Kb 
tweet!  Can you export all the datasets into Excel for me? - A small dynamic macro that does it as fast as they think it should.
  Steven Black, W. L. Gore & Associates Inc., Flagstaff, AZ
Keywords: PROC SQL PROC TEMPLATE PROC REPORT EXCELXP TAGSET MACRO language
Pages: 8 Size: 43 Kb 
tweet!  Combining SAS ® LIBNAME and VBA Macro to Import Excel ® file in an Intriguing, Efficient way
  Ajay Gupta, PPD Inc, Morrisville, NC
Keywords: EXCEL DDE VBA macro
Pages: 7 Size: 248 Kb 
tweet!  Dynamic Project Setup and Programming Using SAS Automatic Macro Variables and Environment Variables
  Gary E. Moore, Moore Computing Services, Inc., Little Rock, AR
Keywords: project setup programming interactive non-interactive SAS automatic macro environment variables
Pages: 3 Size: 178 Kb 
tweet!  A Closer Look at PROC SQL’s FEEDBACK Option
  Kenneth W. Borowiak, PPD, Inc., Morrisville, NC
Keywords: PROC SQL feedback select * natural joins macro variables operator mnemonics
Pages: 7 Size: 286 Kb 
tweet!  Combining First Page of Multiple RTF Outputs in SAS ® using Bookmark and VBA Macro
  Ajay Gupta, PPD Inc, Morrisville, NC
Keywords: RTF VBA BOOKMARK.DDE macro
Pages: 8 Size: 224 Kb 
tweet!  Macro to Conduct Consistency Checks
  Walter H. Hufford, Jr., Novartis Pharmaceuticals Corporation, East Hanover, NJ
Keywords: PARMBUFF DICTIONARY FILES CNTLIN EXCELXP TAGSET TRAFFIC LIGHTING macro
Pages: 6 Size: 373 Kb 
tweet!  Using SAS Driver Programs to Automate Workflows and Respond to the Unexpected
  Brit Minor, REGISTRAT-MAPI, Lexington, KY
Keywords: Drivers workflow macros log checking sending mail
Pages: 9 Size: 255 Kb 
Best Paper
tweet!  Leveraging SDTM Standards to Cut Datasets at Any Visit
  Anthony L. Feliu, Genzyme, Cambridge, MA; Stephen W. Lyons, Genzyme, Cambridge, MA
Keywords: SDTM CDISC interim analysis SAS/macro
Pages: 12 Size: 240 Kb 
tweet!  Macro %D_ADSL - Automating ADSL Creation from Metadata File
  Jianhua (Daniel) Huang, Celgene Corporation, Basking Ridge, NJ
Keywords: Macro ADaM
Pages: 9 Size: 78 Kb 
tweet!  Communication of Statistical Findings by Tables and Graphs
  Howard Liang, inVentiv Health Clinical, Eden Prairie, MN
Keywords: Outliers Macro PROC MIXED Distant Data
Pages: 12 Size: 278 Kb 
tweet!  Using PROC FCMP to the Fullest: Getting Started and Doing More
  Arthur L. Carpenter, California Occidental Consultants, Anchorage, AK
Keywords: FCMP user defined functions conversions function libraries %SYSFUNC
Pages: 10 Size: 589 Kb 
tweet!  The Challenges and Opportunities for SAS Statistical Programmers in Two Commonly Used CRO Resourcing Models
  Mark Matthews, inVentiv Health Clinical, Indianapolis, IN; R. Mouly Satyavarapu, inVentiv Health Clinical, Ann Arbor, MI
Keywords: Challenges, Opportunities, SAS, Statistical, Programmers, CRO, Resourcing, Model, Deliverable, FTE, Leadership, Interpersonal, Financial, Programming, Employee, Macro, System, Utilization, Realizat ...
Pages: 6 Size: 58 Kb 
tweet!  Validating Listing Output: A Better Way
  Hunter Vega, Stat-Tech Services, LLC, Chapel Hill, NC; James Kniffen Jr., Stat-Tech Services, LLC, Chapel Hill, NC
Keywords: RTF Macro Validation Listing
Pages: 4 Size: 273 Kb 
tweet!  Doctoring Your Clinical Trial with Adaptive Randomization: SAS® Macros to Perform Adaptive Randomization
  Jenna Colavincenzo, University of Pittsburgh, Pittsburgh, PA
Keywords: macro
Pages: 9 Size: 522 Kb 
tweet!  Probability Based Criteria in Early Phase Drug Development
  Howard Liang, inVentiv Health Clinical, Eden Prairie, MN
Keywords: Outliers Macro PROC MIXED Distant Data
Pages: 5 Size: 195 Kb 
tweet!  Let’s get SAS®sy
  Amie Bissonett, inVentiv Health Clinical, Minneapolis, MN
Keywords: Good programming practice indentation macro retain lab
Pages: 6 Size: 61 Kb 
tweet!  What's Hot, What's Not: Skills for SAS® Professionals
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA; Charles Edwin Shipp, Consider Consulting, Inc., San Pedro, CA
Keywords: SAS, SAS skills, what's hot, what's not so Hot, Enterprise Guide, EG, hash objects, ODS, PROC SQL, SQL, PROC REPORT, Macro Language, Dictionary Tables, BI, SAS/XML, sasCommunity, SAS-L, LexJansen.c ...
Pages: 6 Size: 582 Kb 

Pharmaceutical SAS Users Group 2012   May 13-16, 2012 - San Francisco, California

tweet!  SAS® Programming Tips, Tricks and Techniques
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS programming and techniques options logic case logic ODS Output Delivery System macro macro programming Lafler Kirk Lafler Kirk Paul Lafler
Pages: 15 Size: 560 Kb 
tweet!  Experience of Generating an XML file and Uploading Serious and Frequent Adverse Events to ClinicalTrials.gov
  Juan Wu, Medtronic Inc., Santa Rosa, CA; Min Lai, Medtronic Inc., Santa Rosa, CA
Keywords: Serious Adverse Events Frequent Adverse Events XML file ClinicalTrials.gov SAS Macro
Pages: 9 Size: 341 Kb 
Best Paper
tweet!  A SAS Macro Utility to Append SAS-Generated RTF Outputs and Create the Table of Contents
  Sudhakar Anbazhagan, Ockham Development Group, Chennai, India; Shridhar Patel, Ockham Development Group, Cary, NC
Keywords: TOC Table of Contents RTF SAS macro
Pages: 4 Size: 83 Kb 
tweet!  Is Your Failed Macro Due To Misjudged “Timing”?
  Arthur Li, City of Hope Comprehensive Cancer Center, Duarte, CA
Keywords: macro
Pages: 22 Size: 1638 Kb 
tweet!  Automatic Version Control and Track Changes of CDISC ADaM Specifications for FDA Submission
  Xiangchen (Bob) Cui, Vertex Pharmaceuticals, Cambridge, MA; Min Chen, Vertex Pharmaceuticals, Cambridge, MA
Keywords: CDISC ADaM Version Control Tracking Changes FDA Submission Automation Macro
Pages: 8 Size: 113 Kb 
tweet!  Automatic Detection and Identification of Variables with All Missing Values in SDTM/ADaM Datasets for FDA Submission
  Min Chen, Vertex Pharmaceuticals, Cambridge, MA; Xiangchen (Bob) Cui, Vertex Pharmaceuticals, Cambridge, MA
Keywords: CDISC SDTM ADaM FDA Submission Empty Variables Automation Macro Core Variable Categories
Pages: 7 Size: 110 Kb 
tweet!  The application of variable-dependent macro on SDTM conversion
  Mindy Wang, Independent Consultant, North Potomac, MD
Keywords: SDTM CDISC macro
Pages: 9 Size: 755 Kb 
tweet!  Reporting Outliers in Data: A Macro to Identify and Report Distant Data Points
  Howard Liang, PharmaNet/i3, Eden Prairie, MN; Jason Bishop, PharmaNet/i3, Louisa, VA
Keywords: Outliers Macro PROC MIXED Distant Data
Pages: 5 Size: 72 Kb 
tweet!  One Macro Call to a Table with both Frequency and Summary Elements from a Subject-Level Dataset
  Wayne Zhong, Octagon Research Solutions Inc., Wayne, PA
Keywords: macro table wide dataset ADSL
Pages: 9 Size: 250 Kb 
tweet!  A Macro to Indent and Hyphenate Lengthy Text in PROC REPORT
  Stanley Yuen, SimulStat Inc., San Diego, CA
Keywords: SAS PROC REPORT flow split macro ODS indent hyphen
Pages: 5 Size: 218 Kb 
tweet!  Macro to Combine Listing and Descriptive Statistics Table in One Report
  Chenille Lloyd, PharmaNet/i3, Cary, NC
Keywords: Macro Listing Table Descriptive Statistics
Pages: 7 Size: 336 Kb 
tweet!  Easy-to-use Macros to Create a Line Plot with Error Bars Including Functions of Automated Jittering and Adjusting Axis Ranges
  Andrew Miskell, GlaxoSmithKline, Research Triangle Park, NC; Peixin Sun, GlaxoSmithKline, Research Triangle Park, NC; Yufei Du, GlaxoSmithKline, Research Triangle Park, NC
Keywords: macro
Pages: 41 Size: 250 Kb 
tweet!  SAS® Macro Programming Tips and Techniques
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS Macro Language macro keyword macro positional macro SQL SQL procedure Lafler Kirk Lafler Kirk Paul Lafler
Pages: 9 Size: 293 Kb 
Best Paper
tweet!  Using the SAS System as a bioinformatics tool: a macro that calls the standalone Basic Local Alignment Search Tool (BLAST) setup
  Kevin Viel, Ph.D., Histonis, Incorporated, Atlanta, GA
Keywords: macro
Pages: 8 Size: 75 Kb 
tweet!  A Practice to Create Executable SAS® Programs for Regulatory Agency Reviewers
  Hongyu Liu, Vertex Pharmaceuticals, Inc., Cambridge, MA; Lynn Anderson, Vertex Pharmaceuticals, Inc., Cambridge, MA; James O'Hearn, Vertex Pharmaceuticals, Inc., Cambridge, MA; Kexi Chen, Vertex Pharmaceuticals, Inc., Cambridge, MA
Keywords: Executable SAS Program NDA Submission eCDT Analysis Data Macro Agency Review
Pages: 6 Size: 62 Kb 
tweet!  Automatic Consistency Checking of Controlled Terminology and Value Level Metadata between ADaM Datasets and Define.xml for FDA Submission
  Xiangchen (Bob) Cui, Vertex Pharmaceuticals, Cambridge, MA; Min Chen, Vertex Pharmaceuticals, Cambridge, MA
Keywords: CDISC ADaM Consistency Checking Controlled Terminology Value Level Metadata define.xml FDA Submission Automation Macro
Pages: 15 Size: 262 Kb 
tweet!  Creating Metadata Driven Macros to Gain Dynamism and Reduce Complexity in Macro Calls
  Fernando Enriquez, PharmaNet/i3, Mexico City, Mexico
Keywords: Metadata Macro
Pages: 5 Size: 56 Kb 
tweet!  A SAS® Macro for Biomarker Analysis using Maximally Selected Chi-Square Statistic With Application in Oncology
  Quan Jenny Zhou, Eli Lilly and Company, Indianapolis, IN; Bala Dhungana, Eli Lilly and Company, Indianapolis, IN
Keywords: SAS macro biomarker Maximally Chi-Square Oncology
Pages: 8 Size: 372 Kb 
tweet!  Why Does SAS® Say That? What Common DATA Step and Macro Messages Are Trying to Tell You
  Charley Mullin, SAS Institute, Cary, NC; Kevin Russell, SAS Institute, Cary, NC
Keywords: macro
Pages: 17 Size: 92 Kb 
tweet!  Macro Quoting to the Rescue: Passing Special Characters
  Mary F. O. Rosenbloom, Edwards Lifesciences LLC, Irvine, CA; Art Carpenter, California Occidental Consultants, Anchorage, AK
Keywords: %BQUOTE %QLEFT %NRSTR macro variable resolution special characters
Pages: 10 Size: 372 Kb 
tweet!  Interesting technical mini-bytes of Base SAS® – From Data step to Macros
  Airaha Chelvakkanthan Manickam, Cognizant Technology Solutions, Teaneck, NJ
Keywords: Error handling Problem Solving Knowledge Gain Performance Improvement _all_ PERL pattern matching SET with KEY= option Multi-way random access Data step views CALL SET CALL EXECUTE macro
Pages: 13 Size: 370 Kb 
tweet!  Validating SAS Macros and Updated SAS Version
  Sy Truong, Meta-Xceed, Inc. (MXI), Fremont, CA; Carey Smoak, Roche Molecular Systems, Inc., Pleasanton, CA
Keywords: iPhone Mobile Computing SAS Delivery macro
Pages: 11 Size: 916 Kb 
tweet!  Reading and Writing RTF Documents as Data: Automatic Completion of CONSORT Flow Diagrams
  Art Carpenter, California Occidental Consultants, Anchorage, AK; Dennis G. Fisher, Ph.D., CSULB, Long Beach, CA
Keywords: RTF CONSORT flow diagram macro language INFILE _INFILE_
Pages: 9 Size: 520 Kb 

Pharmaceutical SAS Users Group 2011   May 8-11, 2011 - Nashville, Tennessee

tweet!  A SAS Macro Tool for Selecting Differentially Expressed Genes from Microarray Data
  Huanying Qin, Baylor Institute of Immunology Research, Dallas, TX; Laia Alsina, Baylor Institute of Immunology Research, Dallas, TX; Hui Xu, Baylor Institute of Immunology Research, Dallas, TX; Elisa L. Priest, Institute for Health Care Research and Improvement, Baylor Health Care System, Dallas, TX
Keywords: SAS Macro Microarray Differentially Expressed Genes
Pages: 7 Size: 97 Kb 
Best Paper
tweet!  Creating reference amplicons and genotyping using the SAS System
  Kevin Viel, Saint Joseph's Translational Research Institute, Atlanta, GA
Keywords: SAS bioinformatics genotyping genome database DNA sequencing regular expressions macro amplicon
Pages: 15 Size: 275 Kb 
tweet!  Protecting Macros and Macro Variables: It Is All About Control
  Eric Sun, sanofi-aventis U.S. Inc., Bridgewater, NJ; Arthur L. Carpenter, CALOXY, Anchorage, AK
Keywords: ClinicalTrials.gov XML PRS FDAAA macro
Pages: 11 Size: 93 Kb 
tweet!  A Cost-Effective SDTM Conversion for NDA Electronic Submission
  Xiangchen (Bob) Cui, Vertex Pharmaceuticals, Cambridge, MA; Scott Moseley, Vertex Pharmaceuticals, Cambridge, MA; Min Chen, Vertex Pharmaceuticals, Cambridge, MA
Keywords: CDISC Clinical Trials Macros Microsoft Excel Regulatory Submissions XML
Pages: 12 Size: 505 Kb 
tweet!  Automating the Process of Preparing Data Definition Document for NDA Electronic Submission from Programming Specification in Word Format
  Min Chen, Vertex Pharmaceuticals, Cambridge, MA; Xiangchen (Bob) Cui, Vertex Pharmaceuticals, Cambridge, MA; Scott Moseley, Vertex Pharmaceuticals, Cambridge, MA
Keywords: CDISC Clinical Trials Macros Microsoft Excel Regulatory Submissions XML
Pages: 12 Size: 288 Kb 
tweet!  Making a List, Checking it Twice (Part 1): Techniques for Specifying and Validating Analysis Datasets
  Elizabeth Li, PharmaStat LLC, Newark, California; Linda Collins, PharmaStat LLC, Newark, California
Keywords: CDISC ADaM Macros SAS® programming validation analysis data specification
Pages: 8 Size: 72 Kb 
tweet!  A Non-Invasive Macro to Track Submission Metadata in SAS Drug Development
  Katrina E. Canonizado, Celerion, Lincoln, NE; Bradford J. Danner, i3 Statprobe, Lincoln, NE; Matthew J. Wiedel, Celerion, Lincoln, NE
Keywords: Metadata SDDPARMS SAS Drug Development SQL macro
Pages: 8 Size: 96 Kb 
tweet!  Macros to Help You Clean Up!
  Kavitha Madduri, Boehringer Ingelheim Pharmaceuticals Inc., Ridgefield, CT
Keywords: SAS Dictionary Tables Macros SQL
Pages: 7 Size: 72 Kb 
tweet!  A SAS® Macro to Indent the un-indented SAS programs
  Sreekanth Reddy Middela, Novartis Pharmaceuticals Corporation, East Hanover, New Jersey; Jyothsna Samala, Percept Pharma Services, Bridgewater, New Jersey; Anirudh Bhetala, Percept Pharma Services, Bridgewater, New Jersey
Keywords: Indent Indentation LIFO macro
Pages: 8 Size: 153 Kb 
tweet!  Macro to Generate Summary and Descriptive Statistics Tables
  Yogesh Pande, Merck Sharp & Dohme Corp., Rahway, New Jersey
Keywords: Summary Descriptive Macro continuous categorical
Pages: 6 Size: 73 Kb 
tweet!  A Recursive SAS Macro to Automate Importing Multiple Excel Worksheets into SAS Data Sets
  Wenyu Hu, Merck Sharp & Dohme Corp., Upper Gwynedd, PA; Liping Zhang, Merck Sharp & Dohme Corp., Upper Gwynedd, PA
Keywords: proc import Excel recursive macro
Pages: 6 Size: 46 Kb 
tweet!  Smart Import/Append Data in Excel Sheets
  Zhengping Ma, Eli Lilly and Company, Indianapolis, IN; Liping Liu, i3 StatProbe, Indianapolis, IN
Keywords: Clinical Trials Data Management Macros Microsoft Excel
Pages: 8 Size: 176 Kb 
Best Paper
tweet!  SYMply PUT: GET the most out of SYMPUTX and SYMGETN
  Robert Howard, Veridical Solutions, San Diego, CA
Keywords: SAS SYMPUTX SYMGETN macro variable SAS functions practical application
Pages: 4 Size: 63 Kb 
tweet!  Permutation via Recursive SAS® Macro
  Jian Dai, Clinovo, Sunnyvale, CA
Keywords: macro
Pages: 5 Size: 61 Kb 
tweet!  A Mass Symphony: Directing the Program Logs, Lists, and Outputs
  Tom Santopoli, Octagon Research Solutions, Inc., Wayne, PA
Keywords: Macros ODS Reporting
Pages: 7 Size: 212 Kb 
tweet!  Powerful and “Sometimes” Hard-to-find PROC SQL® Features
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, California
Keywords: PROC SQL SQL queries case logic views Dictionary tables macro variables joins query performance
Pages: 17 Size: 724 Kb 
tweet!  A Practical Approach to Process Improvement Using Parallel Processing
  Viraj Kumbhakarna, Cognizant Technology Solutions Corporation, Lake Hiawatha, NJ
Keywords: Parallel Processing Macros Large datasets
Pages: 16 Size: 299 Kb 
tweet!  Automatization of Patient Characteristics Report
  Mirjana Stojanovic, Cancer Center Biostatistics, Duke University Medical Center, Durham, NC
Keywords: macro array %If %then call symput proc report
Pages: 8 Size: 59 Kb 
tweet!  Good Programming Practices in Healthcare Creating Robust Programs
  Gregory S. Nelson, ThotWave Technologies; Jay Zhou, Q-Squared Business Intelligence, Inc.
Keywords: SAS Base SAS Macro SQL Data Step healthcare
Pages: 17 Size: 349 Kb 
tweet!  You Want that Program to Run on the PC in New Jersey and the Unix in Basel, without Modification??
  David Franklin, TheProgrammersCabin.com, Litchfield, NH
Keywords: macros unix windows
Pages: 6 Size: 110 Kb 
tweet!  Leave Your Bad Code Behind: 50 Ways to Make Your SAS Code Execute More Efficiently
  William E Benjamin Jr, Owl Computer Consultancy, LLC, Phoenix, AZ
Keywords: Base SAS Code Tips Macro Variables Procedures Conditional Code
Pages: 20 Size: 388 Kb 

Pharmaceutical SAS Users Group 2010   May 23-26, 2010 - Orlando, Florida

tweet!  Let your title macro report study progress
  Yang Chen, Independent Consultant
Keywords: macro report
Pages: 5 Size: 59 Kb 
tweet!  Leave No Trace: A Set of Macros to Remove Evidence of Program Execution
  Jim Johnson, ReSearch Pharmaceutical Services (RPS)
Keywords: clean-up macro
Pages: 10 Size: 81 Kb 
tweet!  Make Easy Style Templates Using SAS Macro
  Barbara Harlan, Louisiana State University
Keywords: Style Templates SAS Macro
Pages: 11 Size: 274 Kb 
tweet!  Automating Comparison of Integrated studies vs. Individual studies
  Sandeep Kottam, Sr. Statistical Programmer consultant, Eisai Pharmaceuticals, NJ; Sree Lakshmi K Tripuraneni, Sr.Statistical Programmer consultant, Purdue pharma, Stamford, CT
Keywords: Metafile macro individual studies
Pages: 4 Size: 35 Kb 
tweet!  Need reporting deliverables the painless and easy way? A batch submit macro call, of course!
  Jim Cawley, Merck & Co., Inc.;Jillian Prescod, Merck & Co., Inc.
Keywords: macro parameter
Pages: 8 Size: 72 Kb 
tweet!  Making an RTF file Out of a Text File, With SAS
  David Franklin, Independent SAS Consultant
Keywords: RTF macro
Pages: 3 Size: 107 Kb 
tweet!  Do you want to do matrix calculations with Base SAS software without SAS/IML? No worries.
  Sarfaraz Sayyed, Accenture Services Pvt Ltd.;Binoy Varghese, Cybrid, Inc.
Keywords: matrix operation macro
Pages: 11 Size: 152 Kb 
tweet!  A SAS macro to generate Caterpillar plots
  Guochen Song, i3 Statprobe
Keywords: Annotate Catepillar plot macro
Pages: 5 Size: 56 Kb 
Best Paper
tweet!  An error bar macro with PROC GPLOT
  Xingshu Zhu, Merck & Co
Keywords: Error bar PROC GPLOT Standard deviation bar. macro
Pages: 11 Size: 149 Kb 
tweet!  Missing Pages Report
  David Gray, PPD;Zhuo Chen, PPD
Keywords: SAS Macro Missing Page Page Due CRF page Forecast
Pages: 10 Size: 275 Kb 
Best Paper
tweet!  Macros Are Helpful - Tips to Avoid Giving Them a Bad Rep
  Deb Cassidy, PPD
Keywords: macros efficiency
Pages: 7 Size: 64 Kb 
tweet!  %disposition_plot A Macro Application for Clinical Study Disposition Analysis
  Yao Huang, i3
Keywords: Macro Application Clinical Study Disposition Analysis
Pages: 8 Size: 167 Kb 
Best Paper
tweet!  SAS Programming Techniques for Manipulating Metadata on the Database Level
  Chris Speck, PAREXEL International
Keywords: Metadata Macro Library Database SQL Quoting Dictionary Tables
Pages: 7 Size: 58 Kb 
tweet!  Add the Power of Regular Expressions to SAS Macro
  Lei Zhang, Celgene Corporation
Keywords: Regular Expressions PCRE Macro %Sysfunc %SYSCALL Perl PRX functions Pattern Matching Perl operators String replacement
Pages: 16 Size: 100 Kb 
tweet!  %whatChanged: A Tool for the Well-Behaved Macro
  Frank DiIorio, CodeCrafters, Inc
Keywords: macro design macro debugging tool building dictionary tables
Pages: 14 Size: 85 Kb 
tweet!  Building the Better Macro: Best Practices for the Design of Reliable, Effective Tools
  Frank DiIorio, CodeCrafters, Inc
Keywords: macro design programming best practices
Pages: 16 Size: 190 Kb 
tweet!  %rtf2data : A utility macro to convert RTF Table to SAS dataset
  Neeral Beladia, MaxisIT Inc.
Keywords: convert RTF Table to SAS dataset macro
Pages: 11 Size: 1091 Kb 
tweet!  %TABLEMAKER: Data Reporting Made Easy
  Bernadette Johnson, Premier, Inc
Keywords: ODS Output Delivery System macro reporting table RTF descriptive categorical statistics
Pages: 6 Size: 133 Kb 
tweet!  OBJECT_EXIST: A Macro to Check if a Specified Object Exists
  Jim Johnson, ReSearch Pharmaceutical Services (RPS)
Keywords: object_exist macro
Pages: 7 Size: 60 Kb 
tweet!  When Best to Use the %LET Statement, the SYMPUT Routine, or the INTO Clause to Create Macro Variables
  Arthur Li, City of Hope/University of Southern California
Keywords: macro variable %LET %SYMPUT input stack macro processor INTO clause SQL DATA step compiler
Pages: 18 Size: 268 Kb 

Pharmaceutical SAS Users Group 2009   May 31 - June 3, 2009 - Portland, Oregon

tweet!  Using Functions SYSFUNC and IFC to Conditionally Execute Statements in Open Code
  Ronald Fehd
Keywords: assertions function ifc nrstr parameterized include program sysfunc macro
Pages: 10 Size: 99 Kb 
tweet!  %ANYTL: A versatile Table/Listing Macro
  Yang Chen
Keywords: macro
Pages: 11 Size: 121 Kb 
tweet!  Building Reusable and Highly Effective Tools with the SAS® Macro Language
  Kirk Paul Lafler
Keywords: macro
Pages: 9 Size: 291 Kb 
tweet!  MACRO %NEWFLOW
  JIAN (DANIEL) HUANG
Keywords: macro
Pages: 7 Size: 45 Kb 
tweet!  A SAS Macro for Creating AE dataset
  Daniel Li
Keywords: Adverse Events PROC SQL DO LOOP PROC REPORT macro
Pages: 10 Size: 93 Kb 
tweet!  A Macro for Transforming Almost Any Character Calendar Date into a SAS Date Value
  Ruben Chiflikyan
Keywords: macro
Pages: 12 Size: 63 Kb 
Best Paper
tweet!  A Simple Macro to Flag New/Changed Records
  Zhuo Chen
Keywords: Macro Flag New/Changed records
Pages: 4 Size: 53 Kb 
tweet!  A SAS Macro Application for Generating Patient-Level Reports in Clinical Studies
  Yao Huang
Keywords: macro
Pages: 4 Size: 109 Kb 
tweet!  The Care and Feeding of SAS Macro Program Parameters
  Don Boudreaux
Keywords: macro
Pages: 9 Size: 86 Kb 
tweet!  Automating the pooling of variables across multiple datasets using Proc SQL and SAS Macro
  Sanjiv Ramalingam
Keywords: SQL macro
Pages: 10 Size: 176 Kb 
tweet!  Building the Better Macro: Best Practices for the Design of Reliable, Effective Tools
  Frank DiIorio
Keywords: macro design generalized programs macro debugging tool building
Pages: 16 Size: 141 Kb 

Pharmaceutical SAS Users Group 2008   June 1-4, 2008 - Atlanta, Georgia

tweet!  EZTABLE Macros
  Jian (Daniel) Huang, Forest Research Institute
Keywords: macro
Pages: 12 Size: 68 Kb 
tweet!  SHARE: A Reporting System for Efficacy Outputs Using SAS Macro
  Axel Muehlig, Roche
Keywords: macro
Pages: 12 Size: 43 Kb 
tweet!  Quickly and easily make your SAS programs interactive with macro QCKGUI
  Vineet Jain, Smith Hanley Consulting Group
Keywords: macro
Pages: 12 Size: 175 Kb 
tweet!  Do Which? Loop, Until or While? A Review Of Data Step And Macro Algorithms
  Ronald Fehd, Centers for Disease Control
Keywords: do until do while Do-Whitlock double DOW DOW until(last.by-var) loop repeat subsetting until while Whitlock do-loop macro
Pages: 9 Size: 102 Kb 
tweet!  Exploring the SAS Macro Function %SYSFUNC
  Lin Yan, Merck Co., Inc
Keywords: macro
Pages: 5 Size: 45 Kb 
tweet!  Single Page Graphical Display of Multiple Subjects' Time Pattern on Studies
  Louie Huang, Baxter International Inc.
Keywords: PROC GPLOT ANNOTATION PROC SQL MACROS SAS/GRAPH
Pages: 9 Size: 100 Kb 
tweet!  Taking Out the Garbage
  Adam LaManna, Howard Proskin and Associates, Inc.
Keywords: macro macros
Pages: 3 Size: 33 Kb 
Best Paper
tweet!  Keeping your macro robust: Does your dataset exist, does your variable exist?
  Lara Guttadauro, i3 Statprobe
Keywords: macro
Pages: 2 Size: 20 Kb 
tweet!  Detecting Incorrect P-values
  John Morrill, Pharmion Corporation
Keywords: P-value consistency check frequency suspect questionable detect macro QC quality control
Pages: 5 Size: 45 Kb 
tweet!  Case Report Form Auto-Annotation in PDF Files with a Metadata Database and SAS ODS XML Tagsets in a Data Management Unit
  David Escobar, Seattle Children's Hospital
Keywords: SAS Macro Case Report Form Auto-Annotation xml
Pages: 5 Size: 67 Kb 
tweet!  Generating a List of Macro Variables for Lab Data through a Simple Macro Call
  Huijuan Xu, Biogen Idec, Inc.
Keywords: macro
Pages: 3 Size: 163 Kb 
tweet!  SAS® Macro Programming Tips and Techniques
  Kirk P Lafler, Software Intelligence Corporation
Keywords: Macro facility, macro variables, macro functions, global variable, local variable, arithmetic expression, logical expression, SQL-Macro interface, store macros, reuse macros, macro debugging, porta ...
Pages: 8 Size: 53 Kb 
tweet!  %YAMGAST: Yet Another Macro to Generate a Summary Table
  Zang Xiong, St Jude Children's Research Hospital
Keywords: macro
Pages: 10 Size: 102 Kb 
Best Paper
tweet!  %CHCKFRQS — A Macro Application for Generating Frequencies for QC and Simple Reports
  John R Iwaniszek, Stat-Tech Services, LLC; Natalie Walker, Stat-Tech Services, LLC; Laura J Lovette, Stat-Tech Services, LLC
Keywords: macro
Pages: 8 Size: 36 Kb 
tweet!  Writing Testing-Aware Programs that Self-Report when Testing Options are True
  Ronald Fehd, Centers for Disease Control
Keywords: call execute echoauto macro module mprint options parameterized include file routine source2 subroutine testing verbose
Pages: 20 Size: 132 Kb 
Best Paper
tweet!  Validating CDISC SDTM-Compliant Submission-Ready Clinical Datasets with an In-House SAS® Macro-Based Solution
  Bhavin A. Busa, Cubist Pharmaceuticals Inc.; Sheila Vince, Cubist Pharmaceuticals Inc.; Jameelah Aziz, Cubist Pharmaceuticals Inc.
Keywords: CDISC macro
Pages: 12 Size: 358 Kb 
tweet!  Sample size estimation for (Bio)equivalence Testing between two treatments
  Madan Kundu, i3 Statprobe
Keywords: sample size proc power bioequivalence crossover design replicated crossover sas macro
Pages: 13 Size: 375 Kb 
Best Paper
tweet!  Approximate Simultaneous Nonparametric Confidence Intervals for All-Pairwise Comparisons and Comparisons with a Designated (Control) Group in a One-Way Layout Using the SAS System
  Paul Juneau, MMS Holdings, Inc.; Aditya Sikka, MMS Holdings, Inc.; Jiawei Qiao, MMS Holdings, Inc.; Michelle Gayari, MMS Holdings, Inc.
Keywords: nonparametric statistical methods multiple comparison procedures one-way layout SAS macro
Pages: 19 Size: 295 Kb 
tweet!  AUTOMATED SAS® MACRO FOR ADVERSE EVENT LOGISTIC REGRESSION ANALYSIS
  Suhas Sanjee, MaxisIT Inc
Keywords: Logistic Regression PROC GENMOD Adverse Event Logistic Regression Safety Analysis Dynamic Model Generation macro
Pages: 8 Size: 55 Kb 
Best Paper
tweet!  A SAS Macro for Single Imputation
  Shuping Zhang, Merck & Co., Inc.; Jane Liao, Merck & Co., Inc.; Xingshu Zhu, Merck & Co., Inc.
Keywords: Missing data Mean Multiple Imputation data imputation methods RANNOR macro
Pages: 8 Size: 64 Kb 
tweet!  Programming Tips and Examples for Your Toolkit, IV
  John Morrill, Pharmion Corporation
Keywords: karyotype cytogenetics cancer chromosome SMQ MedDRA logical Boolean dates macro dynamic Access where also
Pages: 12 Size: 43 Kb 
tweet!  Building the Better Macro: Best Practices for the Design of Reliable, Effective Tools
  Frank DiIorio, CodeCrafters, Inc.
Keywords: macro
Pages: 16 Size: 136 Kb 

Pharmaceutical SAS Users Group 2007   June 3-6, 2007 - Denver, Colorado

tweet!  Automatic Creation of Analysis Datasets for Clinical Trials - A Macro Program
  John H Adams, Boehringer Ingelheim Pharmaceutical
Keywords: analysis datsets macro automatic creation
Pages: 17 Size: 434 Kb 
tweet!  %SurvTab: A SAS Macro To Make Survival Analysis Easier
  Yinmei Zhou, St. Jude Children's Research Hospital
Keywords: macro survival analysis RTF ODS graphics
Pages: 15 Size: 117 Kb 
tweet!  Combining ODS Output Datasets to Increase Program Clarity and Reduce Macro Load
  Rod A Norman, i3 Statprobe
Keywords: ODS Proc Freq Proc Univariate macro
Pages: 7 Size: 112 Kb 
tweet!  %DIFF: A SAS Macro to Compare Documents in Word or ASCII format
  Michelle Xu, Amylin Pharmaceuticals Inc.; Jay Zhou, Amylin Pharmaceuticals Inc.
Keywords: QC Word RTF DDE Data transfer Discrepancy macro
Pages: 7 Size: 90 Kb 
tweet!  Journeymen's Tools: Data Review Macro FreqAll: Using PROC SQL List Processing with Dictionary.Columns to Eliminate Macro Do Loops
  Ronald Fehd, Centers for Disease Control and Prevention
Keywords: data review dynamic programming list processing do loop macro SQL
Pages: 10 Size: 129 Kb    Download the presentationdownload (.pdf, 129 Kb)
tweet!  A SAS Macro for Comparing the Size of Compressed and Uncompressed SAS Data Sets
  Xingshu Zhu, Merck; Shuping Zhang, Merck
Keywords: compress dataset size macro
Pages: 4 Size: 40 Kb 
tweet!  Three Step Table Validation
  Yang Chen, Forest Laboratories Inc.
Keywords: SAS Table Validation Macro
Pages: 7 Size: 43 Kb 
tweet!  Combining RTFs While Retaining Each Original Document's Page Numbering
  James Worley, PPD, Inc.
Keywords: RTF Page Numbering Pagination Combinging RTFs retaining SAS Word macro
Pages: 3 Size: 63 Kb 
tweet!  A Macro Solution for Updating Report Titles and Footnotes
  Hong Qi, Merck & Co. Inc.; Xiang (Alice) Zong, Merck & Co. Inc.
Keywords: %editft footnote title macro
Pages: 5 Size: 32 Kb 
tweet!  A Macro to Automate the QC of CRT Transport Files (Using ODS 'Traffic Lighting')
  Todd J Case, Genentech, Inc.; Ed Stamm, DataCeutics, Inc.
Keywords: SAS Macro CRT Transport Files ODS Traffic Lighting QC
Pages: 5 Size: 65 Kb 
tweet!  A SAS Macro for Rapid Checking the Data Records
  Heng Zou, Pluman Inc
Keywords: SAS Macro Data Check Record
Pages: 8 Size: 269 Kb 
tweet!  CDISC: Pains and Pitfalls to Dataset Creation
  Janet Stuelpner, Left Hand Computing; Steven Michaelson, Simulstat, Inc.
Keywords: CDISC macros
Pages: 5 Size: 56 Kb 
tweet!  Automated Way to Develop Data Definition Document for Regulatory Submission
  Mustaq Ahmad, Merck & Co., Inc.
Keywords: Regulatory Submission Statistical Review Aid (SRA) Automation SAS Macro Quality Efficiency and Data Definition Document
Pages: 11 Size: 255 Kb 
tweet!  SAS Macro: Symbols of Frustration? %Let Us Help! A Guide to Debugging Macros
  Art Carpenter, CA Occidental Consultants; Kevin Delaney, Centers for Disease Control and Prevention, Atlanta, GA
Keywords: SAS Macro Language global local debugging %IF %SCAN
Pages: 20 Size: 138 Kb 
tweet!  Saving QC Time for Production Tables
  Linfeng Xu, Quintiles; Sunil Gupta, Quintiles
Keywords: production tables QC TLGs SAS macro %getfrq %getstat saving time PharmaSug SAS QC table
Pages: 10 Size: 150 Kb 
2nd Best Paper
tweet!  Coding for Efficient Presentations: The Case of Trend Tests
  Karen M Schlangen, Hollis-Eden Pharmaceuticals, Inc.
Keywords: Macro Graphics GPLOT Trend Jonckheere-Terpstra GREPLAY REG QUANTREG
Pages: 11 Size: 59 Kb 
tweet!  Finding Duplicate Records in a SAS Dataset
  David Franklin, Self
Keywords: Duplicates Macros
Pages: 4 Size: 126 Kb 
tweet!  Architecting a Regulatory Compliant Macro Library Using SAS Drug Development
  Margaret M Coughlin, Merck; Virginia Redner, Merck
Keywords: SDD macro library 21CFRPart11 repository
Pages: 6 Size: 65 Kb 
tweet!  "The Analysis System" How a Research Team Can Organize and Analyze Multiple Datasets with Multiple Outcomes Measured Multiple Times
  Kathryn L Benton, UCHSC/COHO; Diane L Fairclough, UCHSC/COHO; Brenda L Beaty, UCHSC/COHO
Keywords: macro multiple users raw data import
Pages: 6 Size: 180 Kb 
tweet!  The ROC Curve Method for the Assessment of Diagnostic Accuracy
  William F McCarthy, Maryland Medical Research Institute; Nan Guo, Maryland Medical Research Institute
Keywords: ROC curve diagnostic accuracy single diagnostic test macro
Pages: 12 Size: 163 Kb 
tweet!  A SAS Macro to Calculate the Ankle Brachial Index
  Rita A Dale, Colorado Prevention Center
Keywords: ankle-brachial index peripheral arterial disease macro
Pages: 4 Size: 70 Kb 
tweet!  SAS Macros to Detect and Evaluate Statistical Outliers
  Marek K Solak , Schering-Plough Research Institute, Monisha Dey , Schering-Plough Research Institute
Keywords: Macros Hofer-Rickard Grubbs Ferguson
Pages: 8 Size: 72 Kb 
tweet!  Format as Macro Parameter: A Design Pattern for Writing Generic Macro Applications with Lean Interfaces
  Lei Zhang, Celgene Corporation; Kenton Wride, Celgene Corporation
Keywords: Design pattern macro application composite parameter programming pattern programming interface formats as parameter FAMP nested format pass-by-format VARARG
Pages: 9 Size: 115 Kb 
Best Paper
tweet!  Methods for Repeated Macro Calls
  Nicholas J Nerren, PPD
Keywords: Macro CALL EXECUTE PARMBUFF SYSPBUFF
Pages: 5 Size: 261 Kb 

Pharmaceutical SAS Users Group 2006   May 21-24, 2006 - Bonita Springs, Florida

tweet!  Developing PDF-Manipulation Macros for eSubmission Automation
  Lei Zhang, Celgene Corporation
Keywords: PDF manipulation Macro Unnamed pipe VBScript command-line esubmission automation OLE/COM PDF tools
Pages: 11 Size: 103 Kb 
Best Paper
tweet!  DIFFTREE: A Macro to Compare Corresponding Files under Two Directory Trees
  Andy E. Barnett, PPD Inc.
Keywords: DIFFTREE compare traverse directory file subtree macro
Pages: 25 Size: 128 Kb 
tweet!  Utilizing the Stored Compiled Macro Facility in a Multi-user Clinical Trial Setting
  Mirjana Stojanovic, Duke University Medical Center; Dorothy Watson, Duke University Medical Center; Donna Hollis, Duke University Medical Center
Keywords: macro SASMSTORE %copy %include
Pages: 8 Size: 69 Kb 
tweet!  Highly Effective Batch Processing
  Haibin Shu, Barr Pharmaceutical/Duramed Research
Keywords: Batch Job Macro Log File
Pages: 3 Size: 166 Kb 
tweet!  %SummaryTable: A SAS Macro to Produce a Summary Table in Clinical Trial
  Yinmei Zhou, St. Jude Children's research hospital, Tennessee; Lijun Zhang, University of Memphis, Memphis, Tennessee; Michael L. Hancock, St. Jude Children's Research Hospital, Tennessee
Keywords: SAS/MACRO RTF table
Pages: 7 Size: 310 Kb 
tweet!  A SAS Macro to Find the Best Fitted Model For Repeated Measures Using PROC MIXED
  Jingjing Wang, U.S. Army Institute of Surgical Research
Keywords: MIXED covariance structure repeated measures macro
Pages: 8 Size: 172 Kb 
tweet!  Human Effciency: A Factor That Can't Be Ignored When Designing a SAS Macro
  Michele Zhang, Merck. & Co., Inc.
Keywords: Efficiency NDA QA macro
Pages: 8 Size: 44 Kb 
tweet!  Back From The Future: Different Ways to Transfer the Values from Later to Earlier Visits
  Alexander Feigin, Synthes USA
Keywords: PROC SORT SQL Macro
Pages: 8 Size: 204 Kb 
tweet!  Using Multiple SAS Sessions in the PC Environment to Facilitate Programming
  Rubin Nan, PPD; Douglas Criger, PPD
Keywords: SAS SAS Multiple session Macro server remote submit SAS technique PC SAS SAS programming clinical trial
Pages: 3 Size: 51 Kb 
tweet!  Dynamic Column Breaking Macro and Other Applications
  Fan Ping, PRA International; Richard Schiefelbein, PRA International
Keywords: column breaking dynamic AE Conmed column width macro
Pages: 3 Size: 40 Kb 
Best Paper
tweet!  Quote Me On This: How To Make SAS® Talk Database
  Paul D. Sherman, self
Keywords: SQL IN-list List of Values Macro Functions
Pages: 5 Size: 164 Kb    Download the presentationdownload (.ppt, 114 Kb)
tweet!  Macros to Create Quality Control (QC) Documents
  Xiaoyu Liu, ClinForce, Inc.; Hong Xiao, Eli Lilly & Company
Keywords: Quality Control QC documents Validation Macro Extract
Pages: 13 Size: 153 Kb 
Best Paper
tweet!  Developing and Managing a SAS Macro Library
  Margaret K. James, Merck & Co.; Carolyn Maass, Merck & Co.; Virginia Redner, Merck & Co.
Keywords: Macro Library Management
Pages: 7 Size: 39 Kb 
tweet!  Streamlining Specimen/Label Shipment Process
  Christina Carty, CSPCC; Elizabeth Spence, CSPCC
Keywords: email macro Proc Report Output Delivery System ODS label shipment specimen process
Pages: 7 Size: 1281 Kb 
tweet!  Macros to get to "Know Thy Data"
  Diane Foose, GlaxoSmithKline; Mike Gunshenan, GlaxoSmithKline; Richard J. Morales, GlaxoSmithKline
Keywords: macros metadata data
Pages: 14 Size: 45 Kb 
tweet!  Approach to Archive Programs in PDF and Retrieve Programs from PDF Files
  Eric Zhang, Centocor Research & Development, Inc.; Leah Bednarek, Centocor Research & Development, Inc.; Daniel Hofstaedter, Centocor Research & Development, Inc.
Keywords: SAS2PDF PDF2SAS Macro PDF
Pages: 12 Size: 278 Kb 
tweet!  PROC SQL: An Efficient Tool for Creating Macro Variables
  Louie Huang, Baxter BioScience
Keywords: PROC SQL SAS Macros Call Symput data _null_ select group by having order by merge concatenate
Pages: 6 Size: 191 Kb 
tweet!  A Method/ Macro Based on Propensity Score and Mahalanobis Distance to Reduce Bias in Treatment Comparison in Observational Study
  Wuwei Wayne Feng, Eli Lilly & Company; Jun Yu, MedFocus Ltd; Rong Michelle Xu, Eli Lilly & Company
Keywords: observational study propensity score Mahalanobis distance macro
Pages: 11 Size: 445 Kb 
tweet!  Macros to Create Quality Control (QC) Documents
  Xiaoyu Liu, ClinForce, Inc.; Hong Xiao, Eli Lilly & Company
Keywords: Quality Control QC documents Validation Macro Extract
Pages: 13 Size: 459 Kb 
tweet!  Convert Oracle Database to SAS Data Sets, a Novel Approach
  Fuping Peng, Eisai Medical Research
Keywords: SASHELP Format macro Oracle System Table
Pages: 4 Size: 51 Kb 
tweet!  CALL EXECUTE: A Primer
  Alissa D. Ruelle, Pharmanet, Inc.; Kitty Moses, PharmaNet, Inc.
Keywords: CALL EXECUTE SAS Macro CALL ROUTINE
Pages: 11 Size: 50 Kb 
Best Paper
tweet!  An Easy, Concise Way to Summarize Multiple Proc COMPAREs using the SYSINFO Macro Variable
  Lexter S. Fennell, PPD
Keywords: sysinfo compare documentation macro
Pages: 2 Size: 104 Kb 
tweet!  Build Your Own SAS Proc: A PARMBUFF Parsing Macro for a SAS-like Syntax Interface to Complex Macro Parameterizations
  Kyle C. McBride, Instat Services
Keywords: macro parmbuff custom syntax complex parameters proc
Pages: 6 Size: 170 Kb 

Pharmaceutical SAS Users Group 2005   May 22-25, 2005 - Phoenix, Arizona

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!  CDISC for electronic submissions - A Table Translation Program
  John H. Adams, Boehringer Ingelheim; Kirill Tchernakov, Boehringer Ingelheim
Keywords: MACRO CDISC DYNAMIC PROGRAMMING METADATA EXCEL
Pages: 15 Size: 319 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!  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!  %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!  Locating an Autocall Macro
  Weiqin Pan, Bristol-Myers Squibb Co.
Keywords: SASAUTOS AUTOCALL SYSFUNC GETOPTION macro
Pages: 5 Size: 255 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!  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 con ...
Pages: 6 Size: 47 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!  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!  Simplifying Hard-Coding Using A Macro Call
  Jay Huang, Gilead Sciences, Inc.
Keywords: hard-code macro parameters
Pages: 4 Size: 209 Kb 
tweet!  SAS_TRAN: A SAS Macro for Generating SAS Transport Files
  Taghi R. Garacani, AstraZeneca; Donald W. Peterson, AstraZeneca
Keywords: PROC COPY PROC CPORT PROC CIMPORT macro
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
Keywords: PROC REPORT MACRO PAGE X of Y CALL EXECUTE SYMGET COMPUTE BLOCK ODS RTF \{pageof}
Pages: 6 Size: 62 Kb 
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!  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!  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!  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!  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 
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!  A Macro to Generate a Study Report
  Hany A. Aboutaleb, Biogen Idec
Keywords: Report Inventory Study Report macro
Pages: 10 Size: 192 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!  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!  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!  A SAS Macro to Automate Listings
  Elizabeth R. Taylor, Endo Pharmaceuticals Inc.
Keywords: Macros Listings
Pages: 5 Size: 274 Kb 
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!  %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 
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 
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!  What Would I Do without PROC SQL and the Macro Language?
  Jeffrey M. Abolafia, Rho, inc.
Keywords: SQL Macro
Pages: 5 Size: 193 Kb 

Pharmaceutical SAS Users Group 2004   May 23-26, 2004 - San Diego, California

tweet!  A Macro Generating a Report-Ready Table in Different Layout and Format
  Renda Cheng, Bristol-Myers Squibb Company
Keywords: Table Macro
Pages: 12 Size: 53 Kb 
tweet!  Mergers, Consolidations and PROC COMPARE
  Fang Dong, Pfizer
Keywords: Database Consolidations Data Integrity SAS Macros Proc Compare
Pages: 8 Size: 32 Kb 
tweet!  %ArrayPerm: A SAS Macro for Permutation Analysis of Microarray Data
  Deqing Pei, St. Jude Children's Research Hospital; Wei Liu, St. Jude Children's Research Hospital; Cheng Cheng, St. Jude Children's Research Hospital
Keywords: Macro Microarray Batch Permutation
Pages: 5 Size: 223 Kb 
tweet!  Create All Those Tables and Call PROC SQL Once!
  Stanley E. Fogleman, Harvard Clinical Research Institute
Keywords: MACRO PROC SQL DATABASE TABLES
Pages: 3 Size: 32 Kb 
tweet!  Changing That Pesky Datetime to a Date
  Stanley E. Fogleman, Harvard Clinical Research Institute
Keywords: DATETIME DATE DATEPART MACRO PROC DATASETS FORMAT
Pages: 3 Size: 32 Kb 
tweet!  Use Regression Algorithm Identifying Repeated Use Patients
  Haibin Shu, Barr Research
Keywords: Repeat Algorithm Macro Regression
Pages: 4 Size: 101 Kb 
tweet!  Automating the Documentation of Oracle Clinical Database Specifications
  Kyle McBride, Instat Consulting, Inc.
Keywords: Oracle Clinical ODS SQL SAS MACRO Specifications Report
Pages: 9 Size: 215 Kb 
tweet!  Module to Create Global Macro Variables with Distinctive Names Matching Date Values They Carry
  Anatoly V. Kulinsky, FBF Fleet Credit Card Services
Keywords: Macro function date format INTNX time-series error handling return code
Pages: 7 Size: 127 Kb 
tweet!  Constructing Analysis Files: A Multi-Tiered Approach
  Tyler W. Cole, Pacific Data Designs, Inc.
Keywords: ANALYSIS MPF REDUNDANT SYSTEM TIER MACRO CRF HIERARCHY DRIVER NEST
Pages: 7 Size: 260 Kb 
tweet!  Invalid: A Data Review Macro Using PROC FORMAT Option OTHER=INVALID to Identify and List Outliers
  Ronald Fehd, Centers for Disease Control
Keywords: 'data review' 'data checking' invalid outlier Format FmtLib other= macro
Pages: 5 Size: 97 Kb 
tweet!  A Useful Macro for Converting SAS Datasets into SAS Transport Files
  Xingshu Zhu, Merck & Co.; Shuping Zhang, Merck & Co.
Keywords: Data set size PROC CONTENTS SAS transport file FDA submission macro
Pages: 7 Size: 98 Kb 
tweet!  Five Ways to Create Macro Variables: A Short Introduction to the Macro Language
  Art Carpenter, CA Occidental Consultants
Keywords: macro variable %LET INTO CALL SYMPUT macro parameter %DO
Pages: 12 Size: 114 Kb 
tweet!  Programming Squared (Writing Programs that Write Programs)
  Jim Johnson, Covance
Keywords: macros generating code generating programs
Pages: 12 Size: 39 Kb 
tweet!  Making Model Selection in Linear Mixed-Effects Models an Easy Process: A SAS Macro Procedure
  Henry Cheng, MDS Pharma Services; Yuli Xie, MDS Pharma Services; Elizabeth A. Reinbolt, MDS Pharma Services
Keywords: proc mixed automated SAS macros statiscal analysis
Pages: 4 Size: 21 Kb 
tweet!  Using Macro to Create a New Format to Transpose Differently Formatted Values
  Shulin Yuan, Astrazeneca
Keywords: MACRO PROC TRANSPOSE FORMATTED VALUES QUESTIONED VARIABLES
Pages: 2 Size: 9 Kb 
tweet!  Using PROC LOESS with Sparse Data
  Kenneth S. Liu, Merck; Alison Kellock, Merck
Keywords: Macro Akaike Information Criterion
Pages: 7 Size: 66 Kb 
tweet!  Processing Large Lists of Parameters and Variables with Macro Techniques
  Eugene Tsykalov, GlaxoSmithKline
Keywords: macro arrays lists lab transpose techniques
Pages: 6 Size: 156 Kb 
tweet!  Producing Data-Driven Plots for Microsoft Word Using SAS/GRAPH and the SAS Macro Language
  Robert Graebner, Quintiles, Inc.
Keywords: SAS/GRAPH GRAPH MACRO VISUAL BASIC MICROSOFT WORD PK PHASE I PHARMACOKINETIC PHARMACODYNAMIC DATA-DRIVEN
Pages: 7 Size: 182 Kb 
tweet!  Programming Tips and Examples for Your Toolkit
  John Morrill, Quintiles, Inc; Kristi Wiser, Quintiles, Inc..
Keywords: Toolkit Combinations Completetypes Adverse Event Select Macro Glance Directory Tabulate
Pages: 8 Size: 187 Kb 
tweet!  Creating PDF Files for SAS Programs
  Eric Zhang, Merck & Co., Inc.
Keywords: PGM2PDF Macro PDF SAS Programs ODS
Pages: 9 Size: 93 Kb 
tweet!  Undocumented and Hard-to-Find PROC SQL Features
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords: PROC SQL CASE _METHOD _TREE DICTIONARY TABLES MACRO VARIABLES PERFORMANCE
Pages: 9 Size: 35 Kb 
tweet!  One Frequency Macro for All Frequency Tables
  Sam Mao, Quintiles; Jim F. Edgington, Quintiles
Keywords: Frequency table modular design adverse event concomitant medication macro
Pages: 9 Size: 162 Kb 
tweet!  Generating N Shell Programs for N Reports in a Clinical Trial
  John R. Gerlach, Aetna.
Keywords: Clinical Trials Macro Language
Pages: 8 Size: 250 Kb 

Pharmaceutical SAS Users Group 2003   May 4-7, 2003 - Miami, Florida

tweet!  Implementing a Quarterly Contract Payments System for Clinical Trials
  Mark McLaughlin, Independent Contractor; Elizabeth Li, Diem Computing Services, Inc.
Keywords: Base SAS Clinical Trial Contract Payment macro
Pages: 6 Size: 149 Kb 
tweet!  XPDL - An Extensible Project Database Loading and Table Translation Program
  John Adams, Boehringer Ingelheim Pharmaceutical
Keywords: Macro database remap Excel datadriven translation table dynamic spreadsheet project
Pages: 8 Size: 198 Kb 
tweet!  Capabilities of a Flexible SAS Macro for Generating Clinical Datasets and Summary Reports in Different Formats.James Decker, Procter and Gamble Pharmaceutical
  Jun Wang, Procter and Gamble Pharmaceuticals
Keywords: Macro Flexible RTF Report Clinical Summary
Pages: 8 Size: 202 Kb 
Best Paper
tweet!  Creating Display Manager Abbreviations and Keyboard Macros for the Enhanced Editor
  Arthur L. Carpenter, California Occidental Consultants
Keywords: Keyboard macro Display Manager Abbreviation Enhanced Editor
Pages: 4 Size: 127 Kb 
tweet!  Macros Used to Create Descriptive Statistic Summary Tables of Neurotoxicity Scores
  Jonson C. Jiang, Inex Pharmaceuticals Corporation
Keywords: SAS Macros Descriptive Statistic Summary Table Clinical trials Neurotoxicity Score
Pages: 4 Size: 101 Kb 
tweet!  The SAS Data step/macro interface.
  Lawrence Heaton-Wright, Quintiles Limited
Keywords: Macro symput execute datastep
Pages: 4 Size: 92 Kb 
tweet!  Application of Some Advanced PROC SQL Features in Clinical Trial Programming
  Changhong Shi, Merck & Co; Sylvianne Roberge, Merck & Co.
Keywords: PROC SQL DATA Step Clinical Trials Macro Variable(s) Merge Missing Data
Pages: 6 Size: 141 Kb 
tweet!  Automatically Output Rich Text Format Tables Using Dynamic Table Definitions in DATA _NULL_ Step
  Mei Tang, Ventana Clinical Research Corporation
Keywords: Tables SAS macro ODS RTF Proc Template Data _null_ ODS file Put _ods_
Pages: 10 Size: 190 Kb 
tweet!  Generating Data Definition Tables for Electronic NDA Submissions
  Robert Abelson, KAI
Keywords: electronic submission data definition tables Output Delivery System macro
Pages: 4 Size: 61 Kb 
tweet!  An Application of Dummy Variable and Placeholder Macro Parameter in Programming for Clinical Trial Data Quality Monitoring
  Sijian Zhang, University of Alabama at Birmingham; Mark Carpenter, University of Alabama at Birmingham
Keywords: clinical trial data quality monitoring macro dummy variable placeholder macro parameter
Pages: 4 Size: 135 Kb 
tweet!  A SAS® Macro for Simple Statistical Summary
  Michael Gunshenan, GlaxoSmithKline
Keywords: Macro Statistic Summary Freq Means
Pages: 10 Size: 298 Kb 
tweet!  A SAS Macro for Producing Clinical Laboratory Shift Table
  Shi-Tao Yeh, GlaxoSmithKline
Keywords: macro
Pages: 6 Size: 134 Kb 
tweet!  Generating Custom Excel Spreadsheets using ODS
  Chevell Parker, SAS Institute
Keywords: Excel Spreadsheets spreadsheet ODS markup XML VBA Macro
Pages: 10 Size: 123 Kb 
tweet!  Nine Steps to Get Started using SAS® Macros
  Jane Stroupe, SAS Institute
Keywords: macro variables macro programs symput sql
Pages: 6 Size: 141 Kb 
tweet!  A SAS Macro to Automate The Covariance Structure Determination in Repeated Measures Data Analysis
  Don Li, National Cancer Institute of Canada - CTG
Keywords: Covariance structure Repeated measures Data Mixed model SAS Macro
Pages: 4 Size: 81 Kb 
tweet!  SAS Macro to Create ADDL Records to Estimate Dosing Not Represented in the Collected Data, In a NONMEM Population Pharmacokinetic Analysis Dataset
  Richard Schneck, Eli Lilly and Company; Mike Heathman, Eli Lilly and Company; Lynn Reynolds, Eli Lilly and Company
Keywords: ADDL Macro NONMEM Estimated Pharmacokinetic Dosing
Pages: 6 Size: 126 Kb 
tweet!  A Reporting Macro to Create Descriptive Statistical Summary Tables
  Ellen Forman, GlaxoSmithKline
Keywords: macro descriptive statistical summary tables
Pages: 4 Size: 336 Kb 
tweet!  Macro Specializing in Adverse Events Reporting
  Tony Salehi, Quintiles, Inc; Doug Moore, Quintiles, Inc.
Keywords: Adverse Events Reporting Readability Macro
Pages: 2 Size: 72 Kb 
tweet!  Generating PDF Files from Outputs by DATA _NULL_
  Eric Zhang, Merck & Co.; Snow Fu, Merck & Co; Jian (James) Wu, Merck & Co.
Keywords: OUT2PDF MACRO PDF DATA _NULL_ SAS Output Text Files ODS NDA Submissions
Pages: 4 Size: 98 Kb 
tweet!  Invisible Environmental Awareness Techniques
  John Troxell, Merck & Co; Chang-Min Chen, Merck & Co.
Keywords: macro session sashelp log
Pages: 4 Size: 76 Kb 
tweet!  Data Extraction & MedDRA: A SAS Coding Shortcut
  Fang Dong, Pfize; Saket Badola, STATPROBE
Keywords: SAS Macros SAS/Access SQL Passthrough MedDRA Lookup Function
Pages: 4 Size: 164 Kb 
tweet!  Automated Page Breaking and Numbering for Output
  Lara Guttadauro, Kendle International Inc.
Keywords: Page Break Page Numbering Wrapped Text Output Report Macro
Pages: 4 Size: 61 Kb 

Pharmaceutical SAS Users Group 2002   May 5-8, 2002 - Salt Lake City, Utah

tweet!  An Automation System for Generating Case Report Form Tabulations
  David Izard, GlaxoSmithKline; Shi-Tao Yeh, GlaxoSmithKline
Keywords: CRT case report form tabulation FDA patient profile macro
Pages: 6 Size: 104 Kb 
tweet!  A Data-Driven Macro Automating the Data Presentation Process by Generating Tailored, Customizable SAS Code: Relax, let %TABGEN do your work!
  John Morrill, Quintiles, Inc.; Kristi Wiser, Quintiles, Inc; Jay Zhou, Quintiles, Inc.
Keywords: %TABGEN code generator data-driven macro PROC REPORT tabulation
Pages: 6 Size: 146 Kb 
tweet!  MacStat: A Statistical Analysis and Reporting System using SAS Macros, Visual Basic, and Microsoft Word
  Richard Thomas, Palarco, Inc; Nick Ronca, AstraZeneca Pharmaceuticals LP
Keywords: Visual Basic Microsoft Word SAS/SHARE report statistics client-server macro
Pages: 6 Size: 155 Kb 
Best Paper
tweet!  %Qexcel Tackles the Challenges of Converting Data to SAS® from Excel®
  Jay Zhou, Quintiles, Inc.
Keywords: Excel spreadsheet DDE macro function data transfer
Pages: 6 Size: 114 Kb 
tweet!  Macro Functions: How to Make Them - How to Use Them
  Art Carpenter, CA Occidental Consultants
Keywords: macro function exist macro variable resolution
Pages: 6 Size: 45 Kb 
tweet!  Recovering Lost Lines: Using the Whole Page with Proc Report
  Richard Allen, Peak Statistical Services
Keywords: proc report 12pt font pagesize titles footnotes macro
Pages: 6 Size: 150 Kb 
tweet!  Documenting the Database: A SAS® Macro to Automate the Process
  William Murphy, Howard M. Proskin & Associates, Inc.
Keywords: macro ODS documentation database SYMPUT DATA _NULL_ PROC DATASETS PROC CONTENTS PROC PRINT
Pages: 4 Size: 108 Kb 
tweet!  You CAN Save Your Log and View It, Too: An Improved Process for Automatically Saving the Contents of the Log and Output Windows
  Amy Rhoads, PRA International; Kent Letourneau, PRA International
Keywords: log save button macro output
Pages: 6 Size: 92 Kb 
tweet!  SAS® Macros for Graphical Data Analysis
  Doug Lassman, PRA International
Keywords: macro
Pages: 8 Size: 72 Kb 
Best Paper
tweet!  %Addval: A SAS® Macro which completes the Cartesian Product of dataset observations for all values of a selected set of variables.
  Richard Schiefelbein, PRA International
Keywords: addval macro cartesian product key freq clinical programming
Pages: 6 Size: 70 Kb 
tweet!  A SAS Macro for Producing Data Summary Tables
  Yajie Wang, Palo Alto Institute of Research and Education; Lan Zhao, Palo Alto Institute of Research and Education; Surai Thaneemit-Chen, VA Palo Alto Health Care System; Vaishali Krishnan, VA Palo Alto Health Care System; Galina Shamayeva, VA Palo Alto Health Care Syste; Bob Edson, Palo Alto Institute of Research and Education
Keywords: SAS macro summary tables data _null_ ODS
Pages: 6 Size: 92 Kb 
tweet!  Rapid Assessment of Data Set Structures
  Philip Vecchione, Cognigen Corp.
Keywords: macro var varlist varcomp varsum varscan Cognigen variable dataset structure
Pages: 4 Size: 109 Kb 
tweet!  Using SAS® Macros to Construct Items 5 and 11 of an Electronic Submission
  Elizabeth Dennis, Quintiles, Inc; Jay Zhou, Quintiles, Inc.
Keywords: FDA electronic submission SAS macro item 11 transport file data definition table
Pages: 4 Size: 120 Kb 
tweet!  Macros for Model Building, Summarizing, and Displaying Results of Stepwise Logistic Regressions
  Lori Parsons, Ovation Research Group
Keywords: Logistic Procedure PROC LOGISTIC stepwise regression model building model information odds ratio confidence interval macro
Pages: 6 Size: 144 Kb 
tweet!  Report Macro - A Tool to Generate Flexible Summary Reports
  Diane Foose, GlaxoSmithKline
Keywords: macro across proc report tool summary report=
Pages: 6 Size: 408 Kb 
tweet!  Convert ASCII Output Files to SAS® Data Sets
  Lara Guttadauro, Kendle International Inc; Pingping Zhang, Kendle International Inc.
Keywords: ASCII data set data listing macros validation
Pages: 4 Size: 17 Kb 
Best Paper
tweet!  Bulletproofing and Knowledge Encapsulation in Statistical Macros
  John Troxell, Merck & Co., Inc.
Keywords: macro bulletproofing knowledge encapsulation %sysfunc statistics statistical expert error messages
Pages: 4 Size: 83 Kb 
tweet!  Post-processing MPRINT Outputs to Generate Macro-Free Code
  Jim Edgington, Quintiles, Inc; Jay Zhou, Quintiles
Keywords: macro mprint mfile reservedb1 decode
Pages: 6 Size: 105 Kb 
tweet!  Expanding the Functionality of Min()/Max(): Finding Tied Minimum or Maximum Values and Their Contributing Variables
  Kent Nassen, Pfizer Global Research & Development -- Ann Arbor Laboratories; Subra Pilli, Pfizer Global Research & Development -- Ann Arbor Laboratories; Luai Alzoubi, Pfizer Global Research & Development -- Ann Arbor Laboratories
Keywords: Macro min() max() tied minimum tied maximum iterative processing array proc sql nested do loop
Pages: 8 Size: 105 Kb 

Pharmaceutical SAS Users Group 2001   May 20-23, 2001 - Boston, Massachusetts

tweet!  From SAS® ASCII Output to Word Document - A SAS® Macro Approach
  Jianlin 'Jay' Zhou, Quintiles, Inc., Kansas City, MO
Keywords: SAS Macro Word Document RTF ASCII
Pages: 4 Size: 721 Kb 
Best Paper
tweet!  %ICS - A SAS® Macro to Automate Individual Case Summaries
  Doug E. Lassman, PRA International, Lenexa, KS
Keywords: Individual Case Summaries Patient Profiles Case Report Form Tabulations macro
Pages: 8 Size: 70 Kb 
tweet!  Using Recursion in the SAS® System
  David Ward, InterNext, Inc., Somerset, NJ
Keywords: Recursion Algorithm Macro SCL AF
Pages: 2 Size: 60 Kb 
tweet!  Converting CP World Application to SAS® V8: A Discussion of Issues and Hurdles Encountered
  Fang Dong, Pfizer Global Research and Development, Ann Arbor, Michigan
Keywords: SAS V8 Conversion Macros %syslput DDL. DDE
Pages: 4 Size: 143 Kb 
tweet!  Macros with Global Vision: Using The SAS® Dictionary Tables to Create Tools
  Michael E. Tomb; James R. Carter; Informatica ECS, Inc., Rochester, NY
Keywords: Dictionary Tables Macros CALL EXECUTE Metadata SASHELP Views
Pages: 8 Size: 122 Kb 
tweet!  Automatic Estimation of Dixon's Test for Extreme Values Using a SAS® Macro Driven Program
  Don Li, Biovail Contract Research, Toronto, ON, Canada; Edmond Edwards, Biovail Contract Research, Toronto, ON, Canada
Keywords: Outlier Dixon SAS macro
Pages: 4 Size: 80 Kb 
tweet!  Testing the Trend of a Response Curve to an Increasing Sequence of Doses: A SAS Macro to Automate the Analysis
  Donghui Zhang, Merck Research Laboratories, Rahway, NJ
Keywords: macro
Pages: 4 Size: 145 Kb 
tweet!  _hitlist Macro - A Tool to Obtain Consistent Results in an Integrated Database
  Diane E. Foose, GlaxoSmithKline, Collegeville, PA; David C. Izard, GlaxoSmithKline, Collegeville, PA
Keywords: Hitlist Macro Integrated Database NDA Submission
Pages: 4 Size: 134 Kb 
tweet!  Complex Macros v. Simple Programs: Resolving the Conflict
  John K. Troxell, Merck & Co., Inc., Rahway, NJ
Keywords: macro FDA
Pages: 2 Size: 70 Kb 
tweet!  Using SAS® to Create a Centralized Parameter File for Analysis and Reporting
  Phebe Joseph, ASG, Inc., Stamford, CT
Keywords: titles footnotes report parameter centralized macro table of contents program-tracking analysis and reporting
Pages: 4 Size: 123 Kb 

Pharmaceutical SAS Users Group 2000   May 7-10, 2000 - Seattle, Washington

tweet!  A SAS® Macro for Creating a Standard Directory Structure
  Andrea Dynder; Barry R. Cohen; Gary Cunningham
Keywords: macro
Pages: 5 Size: 110 Kb 
tweet!  RPT_UTIL: A SAS® Macro for Enhancing Reports in Clinical Trials
  Wei Cheng
Keywords: macro
Pages: 6 Size: 36 Kb 
tweet!  A Macro Tool to check if Values of a Variable match It's Format
  Yuguang Zhao
Keywords: macro
Pages: 4 Size: 11 Kb 
tweet!  COMPDIFF: A Macro for Comparing Datasets
  Matthew Clarke; Greg Silva
Keywords: macro
Pages: 2 Size: 16 Kb 
tweet!  A Macro System for Standardizing and Grading Laboratory Data
  Bruce Coate; William Hoskins
Keywords: macro
Pages: 7 Size: 27 Kb 
tweet!  Using SAS Macro to Create Data Driven Format Statement for Clinical Data Flagging
  Pilita Canete; Melanie Paules; Shi-Tao Yeh
Keywords: macro
Pages: 5 Size: 331 Kb 
tweet!  PAGECNT: A simple macro to add page numbers to reports
  Greg Silva
Keywords: macro
Pages: 3 Size: 15 Kb 
Best Paper
tweet!  Using SAS® Macro to List the Frequencies and Statistics in a Summary Table
  Kinwah Fung
Keywords: macro
Pages: 6 Size: 27 Kb 
Best Paper
tweet!  From Data to Study Report in One Step: A SAS® Macro for the 2,2,2 Crossover Design
  Amy Morris; Thomas E. Bradtreet
Keywords: macro
Pages: 5 Size: 358 Kb 
tweet!  An Interactive SAS® Macro Catalog
  Iza Peszek; John Troxell
Keywords: macro
Pages: 1 Size: 4 Kb 

Pharmaceutical SAS Users Group 1998   May 17-20, 1998 - San Francisco, California

tweet!  A Macro to Produce Pre-Formatted Electronic Documents
  Marina V. Kungurtseva, MS, Ohmeda PPD, Liberty Corner, NJ; Cheng-Tao Chang, Ph.D., Ohmeda PPD, Liberty Corner
Keywords: macro
Pages: 11 Size: 236 Kb 
tweet!  Supporting the -Program-Analyze-Write-Review- Process with a Development Environment for Base SAS and the Macro Language
  Barry R. Cohen, Planning Data Systems, Inc.
Keywords: Supporting Barry Cohen macro
Pages: 6 Size: 35 Kb 
tweet!  Validation of SAS Macro Systems
  Philip M. Pochon, Computer Task Group, Inc., Indianapolis, IN; Thomas H. Burger, Source Consulting®, Indianapolis, IN
Keywords: Pochon validation macro
Pages: 5 Size: 18 Kb 
tweet!  Advanced Macro Topics: Utilities and Examples
  Arthur L. Carpenter, California Occidental Consultants
Keywords: macro
Pages: 6 Size: 26 Kb 
tweet!  An Easy-To-Use SAS Macro for Use with Microsoft Windows That Converts Existing Text Tables to Microsoft Word Tables
  Gary Cunningham, Merck & Co., Inc., West Point, PA
Keywords: macro
Pages: 5 Size: 82 Kb 
tweet!  A Technique for Importing External Data into a Relational Database Using PROC SQL, the Pass-Through Facility and the Macro Language
  Paul Doucette, PAREXEL International Corporation, Media, Pennsylvania
Keywords: SQL macro
Pages: 7 Size: 24 Kb 

Pharmaceutical SAS Users Group 1997   May 11-14, 1997 - Hilton Head, South Carolina

tweet!  Playing With Macros: Take The Work Out Of Learning To Do Macros
  Arthur L. Carpenter
Keywords: macro
Pages: 6 Size: 272 Kb 
tweet!  SAS® Macro Plus Proc Report: A Code-free Approach to Table-driven Data Reporting
  Jun Zhao, Boehringer Ingelheim Pharmaceuticals, Inc. Ridgefield, CT
Keywords: macro
Pages: 5 Size: 226 Kb 
tweet!  Developing a Suite of Clinical Report Macros for SAS/PH-Clinical®
  Paul Gilbert, DataCeutics, Inc; Steve Light, DataCeutics, Inc
Keywords: macro
Pages: 9 Size: 695 Kb 
tweet!  A Generalized Macro For Survival Analysis
  Malini Krishnan, Hoechst Marion Roussel, Inc., Bridgewater, N.J.; Irving Hwang, Hoechst Marion Roussel, Inc., Bridgewater, N. J.
Keywords: macro
Pages: 3 Size: 213 Kb 
tweet!  Adverse Events Summary Tables in Clinical Trials: Incorporating P-values Using SAS® Macros and SAS/AF®
  Jun Zuo, Ph.D., STATPROBE, Inc., Ann Arbor, MI48108; Carl R. Haske, Ph.D., STATPROBE, Inc., Ann Arbor, MI 48108
Keywords: macro af
Pages: 10 Size: 544 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.