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
PharmaSUG proceedings: Coders' Corner and Quick Tips, 436 papers

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

Quick Tips
tweet!  Remove the Error: Variable length is too long for actual data
  Eric Larson, inVentiv Health
Keywords: P21 OpenCDISC
Pages: 9 Size: 48 Kb 
tweet!  Importing CSV Data to All Character Variables
  Art Carpenter, CA Occidental Consultants
Keywords: PROC IMPORT CSV Character variables MIXED= option
Pages: 5 Size: 258 Kb 
tweet!  What Are Occurrence Flags Good For Anyway?
  Nancy Brucken, inVentiv Health Clinical
Keywords: ADaM OCCDS occurrence flags AOCCFL
Pages: 4 Size: 27 Kb 
Best Paper
tweet!  Is There a Date In That Comment? Use SAS To Find Out.
  Keith Hibbetts, Eli Lilly and Company
Keywords: Perl Regular Expression dates in text string
Pages: 4 Size: 153 Kb 
tweet!  My bag of SAS lifehacks
  Dmytro Hasan, Experis
Keywords: lifehacks
Pages: 10 Size: 470 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!  PROC DOC III: Self-generating Codebooks Using SAS®
  Louise Hadden, Abt Associates Inc.
Pages: 8 Size: 408 Kb 
tweet!  Basic SDTM House-Keeping
  Emmy Pahmer, inVentiv Health
Keywords: SDTM checks CDISC
Pages: 3 Size: 29 Kb 
tweet!  Everyone can use a little Currency - when dependent data set updates silently make your analysis data set out of date.
  Scott Worrell, PAREXEL
Keywords: analysis data set currency QT10
Pages: 8 Size: 378 Kb 
tweet!  Multi-Dimensional Arrays: Add Derived Parameters
  Siddharth Kumar Mogra, GCE Solutions Inc
Keywords: Multi Dimensional Arrays, SAS, Lab, ADaM, SDTM, GCE, Solutions, Siddharth Kumar Mogra, Siddharth, Mogra, Palanpur, PharmaSUG, Clinical, Statistical, Analysis, Dataset, Outputs, TLFs, Table, Laborat ...
Pages: 7 Size: 326 Kb 
tweet!  Same statistical method different results? Don't panic the reason might be obvious.
  Iryna Kotenko, Experis Clinical A Manpower Group Company
Keywords: SAS SPSS R Python p-value statistics
Pages: 8 Size: 399 Kb 
tweet!  Visual Basic for Applications: A Solution for Handling Non-ASCII Removal and Replacement
  Eric Crockett, Chiltern International
Keywords: Non-ASCII Excel VBA CDISC ASCII
Pages: 4 Size: 280 Kb 
tweet!  How to Create a Journal-Quality Forest Plot with SAS® 9.4
  John O'Leary, Department of Veterans Affairs; Warren Kuhfeld, SAS
Keywords: Forest Plot
Pages: 11 Size: 216 Kb 
tweet!  Common mistakes by programmers & Remedies
  Sairam Veeramalla, GCE SOLUTIONS
Keywords: Common Mistakes Clinical SAS Remedies Clinical programers TLF mistakes
Pages: 9 Size: 502 Kb 

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

Quick Tips
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!  Plan Your Work Using PROC CALENDAR
  Suresh Kumar Kothakonda, inVentiv Health Clinical, Hyderabad, India
Keywords: proc Calendar SAS
Pages: 5 Size: 427 Kb 
tweet!  Quick and Efficient Way to Check the Transferred Data
  Divyaja Padamati, Eliassen Group Inc., NC
Keywords: Data standards SAS Transferred data QC check SAS
Pages: 6 Size: 206 Kb 
tweet!  Keeping Up with Updating Dictionaries
  Divyaja Padamati, Eliassen Group Inc., NC
Keywords: Dictionaries SAS Dictionary Version check sas Dictionary version SAS
Pages: 3 Size: 355 Kb 
tweet!  Scalable Vector Graphics (SVG) using SAS
  Yang Wang, Seattle Genetics, Inc., Bothell, WA; Vinodita Bongarala, Seattle Genetics, Inc., Bothell, WA
Keywords: Scalable Vector Graphics SVG SAS
Pages: 6 Size: 78 Kb 
tweet!  Adding Statistics and Text to the Panel Graphs using INSET option in PROC SGPANEL
  Ajay Gupta, PPD, Morrisville, NC
Keywords: INSET PROC SGPANEL SAS 9.4
Pages: 6 Size: 350 Kb 
Best Paper
tweet!  Trivial Date Tasks? PROC FCMP Can Help
  Jueru Fan, PPD, Morrisville, NC
Keywords: SAS PROC FCMP Partial Dates Imputation
Pages: 10 Size: 353 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!  Data Validation: Bolstering Quality and Efficiency
  Anusuiya Ghanghas, Novartis Healthcare Private Limited, Hyderabad, India; Houde Zhang, Novartis Pharmaceuticals, East Hanover, NJ; Rajinder Kumar, Novartis Healthcare Private Limited, Hyderabad, India
Keywords: Validation PROC COMPAREV programming mannual check format content cross checking SAS log validation approach TFL
Pages: 3 Size: 285 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!  Lab CTCAE – the Perl Way
  Marina Dolgin, Teva Pharmaceutical Industries Ltd., Netanya, Israel
Keywords: CTCAE SAS Perl regex
Pages: 7 Size: 727 Kb 
Best Paper
tweet!  SAS® and R - stop choosing, start combining and get benefits!
  Diana Bulaienko, Experis Clinical, Kharkiv, Ukraine
Keywords: SAS® PROC IML R ExportDatasetToR statement SUBMIT and ENDSUBMIT statements ggplot2 package
Pages: 7 Size: 483 Kb 
tweet!  Tips on Checking and Manipulating Filenames with SAS
  Solomon Lee, K Solomon LLC
Pages: 4 Size: 89 Kb 
tweet!  When ANY Function Will Just NOT Do
  Richann Watson, Experis, Batavia, OH; Karl Miller, inVentiv Health, Lincoln, NE
Keywords: SAS Functions ANY NOT CDISC SDTM ADaM
Pages: 8 Size: 92 Kb 
tweet!  Becoming a more efficient programmer with SAS® Studio
  Max Cherny, GlaxoSmithKline, Collegeville, PA
Keywords: SAS SAS STUDIO QT17
Pages: 9 Size: 404 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!  Enhancing the SAS® Enhanced Editor with Toolbar Customizations
  Lynn Mullins, PPD, Cincinnati, OH
Keywords: Toolbar Customization Enhanced Editor
Pages: 6 Size: 186 Kb 
tweet!  Using PROC GENMOD with count data
  Meera G Kumar, Sanofi, Bridgewater, NJ
Keywords: count data GENMOD epidemiology person-years event rate ratio poisson
Pages: 4 Size: 69 Kb 
tweet!  SAS Techniques for Managing Large Datasets
  Rucha Landge, Inventiv International Pharma Services Pvt. Ltd., Pune, India
Keywords: Options like Compress Index Bufsize and very routinely used statements are described in the paper
Pages: 7 Size: 234 Kb 
tweet!  Remember to always check your simple SAS function code!
  Yingqiu Yvette Liu, Merck & Co. Inc., North Wales, PA
Keywords: SAS function SCAN function LAG function
Pages: 8 Size: 322 Kb 

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

Quick Tips
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!  EXTENDED ATTRIBUTES: A New Metadata Creation Feature in SAS® 9.4 for Data Sets and Variables
  Joseph Hinson, inVentiv Health, Princeton, NJ, USA
Keywords: EXTENDED ATTRIBUTES METADATA CDISC DEFINE-XML
Pages: 8 Size: 181 Kb 
tweet!  PROC SQL for SQL Die-hards
  Jessica Bennett, Advance America, Spartanburg, SC; Barbara Ross, Flexshopper LLC, Boca Raton, FL
Keywords: QT06 SQL
Pages: 7 Size: 419 Kb 
tweet!  Creating the Perfect Table Using ODS to PDF in SAS 9.4®
  Elizabeth Dennis, EMB Statistical Solutions, Overland Park, KS; Maddy Dennis, Independent Contractor, Lawrence, KS
Keywords: ODS PDF table
Pages: 8 Size: 221 Kb 
tweet!  Hands Free: Automating Variable Name Re-Naming Prior to Export
  John Cohen, Advanced Data Concepts LLC, Newark, DE
Pages: 4 Size: 355 Kb 
tweet!  Using Meta-data to Identify Unused Variables on Input Data Sets
  Keith Hibbetts, Inventiv Health Clinical, Indianapolis, IN
Pages: 4 Size: 95 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!  Don’t Get Blindsided by PROC COMPARE
  Joshua Horstman, Nested Loop Consulting, Indianapolis, IN; Roger Muller, Data-to-Events.com, Carmel, IN
Pages: 7 Size: 74 Kb 
tweet!  Let SAS “Modify” Your Excel File
  Nelson Lee, Genentech, South San Francisco, CA
Pages: 5 Size: 130 Kb 
tweet!  Is Your SAS® System Reliable?
  Wayne Zhong, Accretion Softworks
Keywords: server reliability instability accuracy consistency
Pages: 9 Size: 264 Kb 
tweet!  Getting the Most Out of PROC SORT: A Review of Its Advanced Options
  Max Cherny, GlaxoSmithKline, King of Prussia, PA
Keywords: SAS PROC SORT SORTSEQ CASE_FIRST NUMERIC_COLLATION DUPOUT NOUNIQUEKEY
Pages: 6 Size: 169 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!  Using the power of new SGPLOT features in SAS 9.4 – Customized graphic programming made easier for clinical efficacy and exposure-response analyses
  Peter Lu, Novartis Pharmaceuticals Corporation, East Hanover, NJ; Xingji Han, Novartis Pharmaceuticals Corporation, East Hanover, NJ; Hong Yan, Novartis Pharmaceuticals Corporation, East Hanover, NJ
Pages: 7 Size: 740 Kb 
tweet!  Simplicity is the Soul of Efficiency: Simple Tips and Tricks for Efficient SAS® Programming
  Shefalica Chand, Seattle Genetics, Inc., Bothell, WA
Pages: 8 Size: 1997 Kb 
tweet!  Sorting big datasets. Do we really need it?
  Daniil Shliakhov, Experis Clinical, Kharkiv, Ukraine
Pages: 6 Size: 190 Kb 
tweet!  Creating output datasets using SQL (Structured Query Language) only
  Andrii Stakhniv, Experis Clinical, Ukraine
Keywords: SQL
Pages: 10 Size: 358 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!  Reproducibly Random Values
  William Garner, Gilead Sciences, Inc., Foster City, CA; Ting Bai, Gilead Sciences, Inc., Foster City, CA
Pages: 7 Size: 220 Kb 
tweet!  Transitions in Depressive Symptoms After 10 Years of Follow-up Using PROC LTA
  Seungyoung Hwang, Johns Hopkins University Bloomberg School of Public Health, Baltimore, MD
Pages: 7 Size: 99 Kb 
Best Paper
tweet!  Keyboard Macros - The most magical tool you may have never heard of - You will never program the same again (It's that amazing!)
  Steven Black, Agility-Clinical Inc., Carlsbad, CA
Keywords: Keyboard macros Abbreviations Keyboard shortcuts
Pages: 5 Size: 381 Kb 
tweet!  The concept of “Dynamic” SAS programming
  Sergey Sian, Quintiles, Cambridge, MA
Pages: 4 Size: 281 Kb 
tweet!  Which TLFs Have Changed Since Your Previous Delivery? Get a Quick YES or NO for Each TLF
  Tom Santopoli, Accenture, Berwyn, PA
Keywords: Sysinfo Call Execute RTF Infile %NRSTR
Pages: 7 Size: 324 Kb 
tweet!  Sensitivity Training for PRXers
  Kenneth W. Borowiak, PPD, Morrisville, NC
Pages: 6 Size: 256 Kb 
tweet!  FILLPATTERNS in SGPLOT Graphs
  Pankhil Shah, PPD, Morrisville, NC
Pages: 6 Size: 462 Kb 
tweet!  Copying Files Programmatically in SAS® Drug Development (SDD)
  Wayne Woo, Novartis Vaccines, Cambridge, MA
Keywords: SDD copying recfm
Pages: 3 Size: 176 Kb 
tweet!  Accelerating Production of Safety TFLs in Bioequivalence and Early Phase
  Denis Martineau, Algorithme Pharma, Laval, Quebec, Canada
Keywords: PROC SQL Dictionary tables Automation SAS Macro PROC REPORT Oracle Push the button
Pages: 8 Size: 294 Kb 
tweet!  Simulate PRELOADFMT Option in PROC FREQ
  Ajay Gupta, PPD, Morrisville, NC
Pages: 5 Size: 206 Kb 
tweet!  Grooming of Coarse Data by Smart Listing Using SAS System
  Soujanya Konda, inVentiv Health Clinical, Hyderabad, India
Keywords: Grooming of Coarse Data by Smart Listing Using SAS System Soujanya Konda Q34 Data Cleaning
Pages: 6 Size: 271 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!  I/O, I/O, It’s Off To Work We Go: Digging Into the ATTRC Function
  Karleen Beaver, PPD, Morrisville, NC
Keywords: I/O functions ATTRC data set attributes
Pages: 7 Size: 276 Kb 
tweet!  Statistical Review and Validation of Patient Narratives
  Indrani Sarkar, inVentiv Health Clinical, Indianapolis, IN; Bradford J. Danner, Sarah Cannon Research Institute, Nashville, TN
Keywords: patient profile patient narrative
Pages: 5 Size: 81 Kb 
tweet!  Regaining Some Control Over ODS RTF Pagination When Using Proc Report
  Gary E. Moore, Moore Computing Services, Inc., Little Rock, AR
Keywords: SAS Proc Report ODS RTF Pagination Column
Pages: 8 Size: 93 Kb 
tweet!  Automated Checking Of Multiple Files
  Kathyayini Tappeta, Percept Pharma Services, Bridgewater, NJ
Pages: 7 Size: 418 Kb 
Best Paper
tweet!  Automating Clinical Trial Reports with ODS ExcelXP Tagset
  John O'Leary, Department of Veterans Affairs, West Haven, CT
Keywords: ODS ExcelXP tagset
Pages: 8 Size: 207 Kb 
tweet!  Get a Data Dictionary using PROC contents: Easily
  Beatriz Garcia, Inventiv Health Clinical Mexico, Mexico City, Mexico; Alberto Hernandez, Inventiv Health Clinical Mexico, Mexico City, Mexico
Keywords: Data Dictionary Proc Contents QC
Pages: 5 Size: 271 Kb 
tweet!  A Practical Approach to Create Adverse Event Summary by Toxicity Grade Table
  Zhengxin (Cindy) Yang, inVentiv Health, Princeton, NJ
Pages: 8 Size: 116 Kb 
tweet!  Customizing the Graph Templates for a Kaplan-Meier Failure Plot
  Hugh Geary, Novella Clinical, a Quintiles company, Columbus, OH
Keywords: Lifetest failure survival template atrisk figure plot graph Kaplan-Meier
Pages: 8 Size: 359 Kb 

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

Coders Corner
tweet!  How to Keep Multiple Formats in One Variable after Transpose
  Mindy Wang, Independent Consultant, North Potomac, MD
Keywords: Transpose Formats
Pages: 8 Size: 1239 Kb 
tweet!  Let Hash SUMINC Count For You
  Joseph Hinson, Accenture Life Sciences, Berwyn, PA
Keywords: Hash Objects Counting SUMINC SUM Method Protocol Violation
Pages: 7 Size: 350 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!  Having Fun with RACE Derivation in DM Domain
  Chunxia Lin, InVentiv Health Clinical, Ossining, NY; Deli Wang, Tarrytown, NY
Keywords: SDTM DM RACE
Pages: 5 Size: 38 Kb 
tweet!  Tips to Manipulate the Partial Dates
  Deli Wang, Ossining, NY; Chunxia Lin, InVentiv Health Clinical, Ossining, NY
Keywords: Partial dates Leap year INTNX function
Pages: 4 Size: 40 Kb 
tweet!  Preserving Line Breaks When Exporting to Excel
  Nelson Lee, Genentech, South San Francisco, CA
Pages: 5 Size: 76 Kb 
tweet!  Additional Metadata for Common Catalog Entry Types
  Kenneth W. Borowiak, PPD, Morrisville, NC
Pages: 5 Size: 246 Kb 
tweet!  An Alternative Way to Detect Invalid Reference Records in Supplemental Domains
  Steven Wang, inVentiv Health Clinical, Indianapolis, IN
Pages: 5 Size: 30 Kb 
tweet!  Automating the Number of Treatment Columns for a Dose Escalation Study
  Catherine DeVerter, Novella Clinical, Morrisville, NC; Sonali Garg, Alexion Pharmaceuticals, Cheshire, CT
Pages: 5 Size: 49 Kb 
tweet!  Streamline the Dual Antiplatelet Therapy Record Processing in SAS® by Using Concept of Queue and Run-Length Encoding
  Kai Koo, Abbott Vascular, Santa Clara, CA
Pages: 6 Size: 230 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 
Best Paper
tweet!  WHERE, Oh, WHERE Art Thou? A Cautionary Tale for Using WHERE Statements and WHERE= Options
  Britney D. Gilbert, Juniper Tree Consulting, Porter, OK
Pages: 4 Size: 147 Kb 
tweet!  A Toolkit to Check Dictionary Terms in SDTM
  Huei-Ling Chen, Tech Data Services, Bridgewater, NJ; Helen Wang, Sanofi, Bridgewater, NJ
Keywords: CDISC
Pages: 8 Size: 72 Kb 
tweet!  Cleaning up your SAS log: Overwritten Variable Info Messages
  Jennifer Srivastava, Quintiles Transnational Corporation, Durham, NC
Pages: 6 Size: 375 Kb 
tweet!  Need for Speed in Large Datasets – The Trio of SAS® INDICES, PROC SQL and WHERE CLAUSE is the Answer
  Kunal Agnihotri, PPD LLC, Morrisville, NC
Keywords: SQL
Pages: 7 Size: 269 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!  Let Chi-Square Pass Decision to Fisher’s Programmatically
  Linga Reddy Baddam, inVentiv Health Clinical, Hyderabad, India; Sudarshan Reddy Shabadu, inVentiv Health Clinical, Hyderabad, India
Keywords: Fisher Chi-Square well-balanced data spare and unbalanced data small sample size and clinical reporting criteria for Fisher and Chi-square.
Pages: 5 Size: 140 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!  Automating Production of the blankcrf.pdf
  Walter Hufford, Novartis, East Hanover, NJ
Keywords: blankcrf automate FDF
Pages: 5 Size: 289 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!  SCAN and FIND “CALL SCAN”
  Usha Kumar, inVentiv Health Clinical, Pune, Maharashtra, India
Keywords: CALL SCAN ROUTINE CHARACTER STRING FUNCTION SCAN INDEX FIND PARSE WORD
Pages: 4 Size: 27 Kb 
tweet!  Quickly Organize Statistical Output for Review
  Bradford J. Danner, inVentiv Health Clinical, TN
Keywords: statistical output ODS PDF
Pages: 4 Size: 146 Kb 
tweet!  Times Can Be Tough: Taming DATE, TIME and DATETIME Variables
  Sajeet Pavate, PPD, Wilmington, NC
Keywords: SAS DATE TIME DATETIME corrected code issues
Pages: 6 Size: 96 Kb 
tweet!  Let the CAT Catch a STYLE
  Yanhong Liu, Cincinnati Children’s Hospital Medical Center, Cincinnati, OH; Justin Bates, Cincinnati Children’s Hospital Medical Center, Cincinnati, OH
Pages: 11 Size: 133 Kb 
tweet!  1 of N Methods to Automate the Y- Axis
  Sanjiv Ramalingam, Biogen Idec
Keywords: Y-axis Scaling
Pages: 5 Size: 203 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!  Reducing Variable Lengths for Submission Dataset Size Reduction
  Sandra VanPelt Nguyen, inVentiv Health Clinical
Keywords: CDISC FDA dataset size
Pages: 6 Size: 186 Kb 
tweet!  Let SAS® Do That For You
  Emmy Pahmer, inVentiv Health Clinical, Montreal, QC, Canada
Keywords: Find and copy files in SAS
Pages: 4 Size: 165 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!  PRELOADFMT comes to your rescue, it brings missing categories to life in summary reports
  Niraj J. Pandya, Independent Consultant, CT; Ramalaxmareddy Kandimalla, KRL Solutions, CT
Keywords: PRELOADFMT PROC FORMAT
Pages: 6 Size: 190 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!  It’s not the Yellow Brick Road but the SAS PC FILES SERVER® will take you Down the LIBNAME PATH= to Using the 64-Bit Excel Workbooks
  William E Benjamin Jr, Owl Computer Consultancy, LLC, Phoenix AZ
Pages: 14 Size: 1622 Kb 
tweet!  Creating PDF Reports using Output Delivery System
  Shubha Manjunath, eClinical Solutions, Mansfield, MA; Shirish Nalavade, Eliassen Group Inc., Somerset, NJ
Keywords: ods
Pages: 5 Size: 266 Kb 
tweet!  A Shout-out to Specification Review: Techniques for an efficient review of Programming Specifications
  Sajeet Pavate, PPD, Wilmington, NC; Jhelum Naik, PPD, Wilmington, NC
Keywords: SAS Specification Review Analysis Database Specification TLF Specification Import Specification
Pages: 5 Size: 50 Kb 
tweet!  What do you mean 0.3 doesn't equal 0.3? Numeric Representation and Precision in SAS and Why it Matters
  Paul Stutzman, Axio Research LLC, Seattle, Washington
Keywords: Precision Numeric Representation
Pages: 6 Size: 78 Kb 

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

Coders Corner
tweet!  Automating the Footnote Generation
  Sonali Garg, Alexion Pharmaceuticals, Cheshire, CT; Catherine DeVerter, Novella Clinical, Morrisville, NC
Keywords: Footnote automation renumbering footnotes
Pages: 4 Size: 237 Kb 
tweet!  Beep, Beep, Beep, Back It Up! A Fool Proof Approach to Archiving with no Copying
  Kristen Reece Harrington, BS, Rho® Inc., Chapel Hill, NC, USA
Keywords: archive winzip
Pages: 3 Size: 61 Kb 
tweet!  Conditional Processing Using the Case Expression in PROC SQL
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS SQL PROC SQL SQL procedure Case Case expression conditional processing logic logic scenarios simple case searched case Lafler Kirk Lafler Kirk Paul Lafler @sasNerd
Pages: 8 Size: 584 Kb 
tweet!  SAS® Logic Coding Made Easy - Revisit User-defined Function
  Songtao Jiang, Boston Scientific Corporation, Marlborough, MA
Keywords: User-Defined Function Logic logic operator
Pages: 6 Size: 1165 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!  Bring Excel file with SDTM data in multiple sheets to SAS®
  Mindy Wang, Independent Consultant, North Potomac, MD
Keywords: STDM Excel, CDISC
Pages: 7 Size: 1304 Kb 
tweet!  Tracking the Use of Standard Programs in Clinical Trials
  Adel Salem, Novo Nordisk A/S, Søborg, Denmark
Keywords: Tracking the use of programs
Pages: 12 Size: 605 Kb 
tweet!  Methods to Derive COVAL-COVALn in CO Domain
  Chunxia Lin, inVentiv Health Clinical, Indianapolis, IN
Keywords: CDISC SDTM COMMENTS COVAL TRUNCATION
Pages: 8 Size: 97 Kb 
tweet!  Array, Hurray, Array; Consolidate or Expand Your Input Data Stream Using Arrays
  William E Benjamin Jr, Owl Computer Consultancy, LLC, Phoenix, AZ
Keywords: Arrays BASE SAS
Pages: 10 Size: 427 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!  Creating a Clinical Summary Table within a Single DATA Step with the Dynamic Trio: DOSUBL(), Hash Objects, and ODS Objects
  Joseph Hinson, Princeton, NJ
Keywords: DOSUBL
Pages: 14 Size: 237 Kb 
tweet!  Graph Your SAS® Off
  Karena Kong, InterMune Inc., Brisbane, CA
Keywords: SAS Graphs GPLOT SGPLOT PROC TEMPLATE SGRENDER Bubbly STATISTICAL GRAPHICS PROCEDURES SG Procedures GRAPHICS TEMPLATE LANGUAGE PROCEDURES StatGraph
Pages: 6 Size: 151 Kb 
tweet!  Get in line! How to make your data alignment easy!
  Ying (Evelyn) Guo, PAREXEL International, Durham, NC
Pages: 4 Size: 344 Kb 
tweet!  An alternate log axis using SAS® PROC GPLOT
  Lucius Reinbolt, DataCeutics, Inc., NE
Keywords: SAS PROC GPLOT ANNOTATE LOG SCALE
Pages: 7 Size: 45 Kb 
tweet!  Numeric and Decimal Place Alignment in RTF Files with Non-Monospaced Fonts
  Gary E. Moore, Moore Computing Services, Inc., Little Rock, AR
Keywords: SAS decimal alignment rtf code justification left right center tab
Pages: 6 Size: 230 Kb 
tweet!  Creating a Batch Command File for Executing SAS with Dynamic and Custom System Options
  Gary E. Moore, Moore Computing Services, Inc., Little Rock, AR
Keywords: batch command file Windows SAS invocation system options
Pages: 5 Size: 250 Kb 
tweet!  PRXChange: Accept No Substitutions
  Kenneth W. Borowiak, PPD, Inc., Morrisville, NC
Pages: 9 Size: 393 Kb 
tweet!  When Asked for Subject Incidences, Go Ahead and FREQ OUT
  Rod Norman, Inventiv Health Clinical, San Diego, CA
Keywords: ADaM ODS Output FREQ Adverse Events
Pages: 8 Size: 59 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!  Extending the PRX Functions with PROC FCMP
  Kunal Agnihotri, PPD, Inc., Morrisville, NC; Kenneth W. Borowiak, PPD, Inc., Morrisville, NC
Keywords: ÿþPRX regex FCMP
Pages: 7 Size: 170 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!  Add a Little Magic to Your Joins
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS SQL PROC SQL SQL procedure join joins join algorithm step-loop sort-merge index hash Lafler Kirk Lafler Kirk Paul Lafler @sasNerd
Pages: 6 Size: 427 Kb 
tweet!  Automating the Labeling of X- Axis
  Sanjiv Ramalingam, Vertex Pharmaceuticals, Inc. , Cambridge, MA
Pages: 5 Size: 163 Kb 
tweet!  Creating Customized Spaghetti Plots
  Sanjiv Ramalingam, Vertex Pharmaceuticals, Inc. , Cambridge, MA
Pages: 4 Size: 139 Kb 
tweet!  How MEAN is T-test?
  Naina Pandurangi, Inventiv Health Clinical, Mumbai, India
Pages: 4 Size: 49 Kb 
tweet!  Handling Dynamic Variable Types in SAS®
  Venkat Lajapathirajan, PPD Inc., Hamilton, NJ
Keywords: CC29 PharmaSUG Variable Types
Pages: 7 Size: 103 Kb 
tweet!  Useful Tips for Handling and Creating Special Characters in SAS®
  Bob Hull, SynteractHCR, Inc., Carlsbad, CA; Robert Howard, Veridical Solutions, Del Mar, CA
Keywords: SAS Special Characters Excel
Pages: 5 Size: 186 Kb 
tweet!  A Quick Patient Profile: Combining External Data with EDC-generated Subject CRF
  Titania Dumas-Roberson, Grifols Therapeutics, Inc., Durham, NC; Yang Han, Grifols Therapeutics, Inc., Durham, NC
Keywords: Patient Profile EDC Visual Basic VB unquote CRF vendor multiple PDF
Pages: 5 Size: 101 Kb 
tweet!  Using SAS® to Locate and Rename External Files
  Lu Gan, Pharmaceutical Product Development, LLC, Austin, TX
Keywords: External Locate Latest Remove Rename
Pages: 8 Size: 592 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 
tweet!  A One Line Method to Extract a Substring from a String using PRX
  Joel Campbell, Advanced Analytics, Wilmington, NC
Keywords: Perl Regular Expressions PRXMATCH PRXPARSE PRXPOSN PRXCHANGE substring string
Pages: 3 Size: 27 Kb 
Best Paper
tweet!  Don’t Get Blindsided by PROC COMPARE
  Joshua Horstman, Nested Loop Consulting, Indianapolis, IN; Roger Muller, Data-to-Events.com, Carmel, IN
Keywords: PROC COMPARE validation dataset comparison
Pages: 5 Size: 64 Kb 
tweet!  Turn Your Plain Report into a Painted Report Using ODS Styles
  Cynthia Zender, SAS Institute Inc., Cary, NC
Keywords: SAS ODS TABULATE REPORT PRINT
Pages: 22 Size: 753 Kb 
Best Paper
tweet!  A Strategy to Ensure Non-Estimable Confidence Intervals Having Equal Lower and Upper Confidence Limits are Displayed Correctly
  Claudia Jimenez-Castro, inVentiv Health Clinical, Mexico City, Mexico
Keywords: Non-Estimable Confidence Intervals
Pages: 5 Size: 61 Kb 

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

Coders' Corner
tweet!  Use Your Cores! An Introduction to Multi-core Processing with SAS
  Erik Dilts, INC Research, Raleigh, NC
Keywords: SAS SMP multithreaded efficiency
Pages: 3 Size: 131 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!  Using PROC COMPARE to identify new and updated records in a subject listing
  Mark McLaughlin, Biogen Idec, Cambridge, MA
Keywords: PROC COMPARE
Pages: 5 Size: 178 Kb 
tweet!  Using Skype to run SAS® programs
  Romain Miralles, Genomic Health, Redwood City, CA
Keywords: SAS skype
Pages: 6 Size: 341 Kb 
Best Paper
tweet!  Watermarking and Combining Multiple RTF Outputs in SAS®
  Ajay Gupta, PPD Inc, Morrisville, NC
Keywords: WORD DDE VBA WATERMARK RTF
Pages: 6 Size: 91 Kb 
tweet!  Importing Excel ® File using Microsoft Access ® in SAS ®
  Ajay Gupta, PPD Inc, Morrisville, NC
Keywords: EXCEL ACCESS BASIC
Pages: 8 Size: 133 Kb 
tweet!  Automation of Comparing ODS RTF Outputs in Batch using VBA and SAS®
  Dongsun Cao, UCB BioSciences, Inc., Raleigh, NC
Keywords: TLGs (Tables Listings and Graphs) Visual Basic for Applications (VBA) QC (Quality Check) ODS (Output Delivery System). RTF (Rich Text Format)
Pages: 8 Size: 371 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!  Calculating time-to-event parameters using a single DATA step and a RETAIN statement
  Andrew L Hulme, PRA, Lenexa, KS
Keywords: Time-to-event time to response duration of response censor DATA RETAIN ADTTE RECIST
Pages: 7 Size: 94 Kb 
tweet!  Short-circuiting PROC COMPARE: Techniques for Focusing Dataset Comparisons
  Tracy Sherman, ICON Clinical Research, Redwood City, CA; Brian Fairfield-Carter, ICON Clinical Research, Redwood City, CA
Keywords: proc compare data set comparison record count
Pages: 8 Size: 84 Kb 
tweet!  An Efficient Method to Create Titles for Multiple Clinical Reports Using Proc Format within A Do Loop
  Youying Yu, PharmaNet/i3, West Chester, OH
Pages: 5 Size: 49 Kb 
tweet!  Techniques for Improvising the Standard Error Bar Graph and Axis Values Completely Through SAS Annotation
  Sunil Kumar Ganeshna, PharmaNet/i3, Pune, India; Venkateswara Rao, PharmaNet/i3, Pune, India
Keywords: SAS ANNOTATION Graphs Error bars axis symbol
Pages: 12 Size: 352 Kb 
tweet!  Quick Data Definitions Using SQL, REPORT and PRINT Procedures
  Bradford J. Danner, PharmaNet/i3, TN
Keywords: data definitions SQL REPORT PRINT ExcelXP tagset
Pages: 5 Size: 50 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!  Efficiently Trim Character Variable Lengths to Fit Data, Reduce Dataset Size
  Wayne Zhong, Octagon Research Solutions Inc., Wayne, PA
Keywords: trim dataset variable efficient
Pages: 7 Size: 207 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 
Best Paper
tweet!  DON'T HAVE A “WEEK” REPORT
  Barbara Ross, DataX Ltd, Las Vegas, NV
Keywords: week sas date date dates weeks label weeks
Pages: 6 Size: 107 Kb 
tweet!  Beyond %LET: Building a GUI to Pass Run-Time Parameters to SAS Programs Using VBScript and HTML Applications
  Shawn Hopkins, Seattle Genetics, Bothell, WA
Keywords: SAS HTA VBScript HTML CSS GUI graphic user interface dHTML
Pages: 8 Size: 190 Kb 
tweet!  Identifying and Verifying Treatment-Emergent Adverse Events and Concomitant Medications by Date Specificity
  Tom Santopoli, Octagon Research Solutions, Inc., Wayne, PA
Keywords: Partial Date Processing Treatment-Emergent Adverse Events Concomitant Medications ISO 8601
Pages: 5 Size: 45 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!  Figure Out Your Programming Logic Errors via DATA Step Debugger
  Wuchen Zhao, University of Southern California, Los Angeles, CA
Keywords: Debugger DATA Step DSD command
Pages: 8 Size: 154 Kb 
tweet!  Need a hand to locate your variables in an entire library?
  Ying Guo, PAREXEL International, Indianapolis, IN
Keywords: variable search efficiency
Pages: 5 Size: 347 Kb 
tweet!  Formats in another format
  Bettina Ernholt Nielsen, Ferring Pharmaceuticals A/S, Copenhagen, Denmark
Keywords: Formats
Pages: 4 Size: 46 Kb 
tweet!  The power of using options COMPLETETYPES and PRELOADFMT
  Naren Surampalli, Novartis Pharmaceuticals, Florham Park, NJ
Keywords: completetypes preloadfmt
Pages: 5 Size: 188 Kb 
tweet!  “V” Can Transpose: Transposing Data Sets Using Functions
  Neha Mohan, PharmaNet/i3, Mumbai, India
Keywords: Transpose Function
Pages: 4 Size: 79 Kb 
tweet!  Sending Emails in SAS® to Facilitate Clinical Trial
  Frank Fan, Clinovo, Sunnyvale, CA
Keywords: SAS, email, EM_TO EMAILSYS, Clinovo
Pages: 8 Size: 86 Kb 
tweet!  A Mean Way to Count, Enumerating the Values of Multiple Variables Using Formats with the Means Procedure
  Rod Norman, PharmaNet/i3 (an InVentiv Health Company) San Diego, CA
Pages: 6 Size: 46 Kb 
tweet!  Using File Modification Date Comparisons to Alert Study Teams of Potential SAS Program Revisions between Shared Folders
  Stephen Hunt, ICON Clinical Research, Redwood City, CA; Brian Fairfield-Carter, ICON Clinical Research, Redwood City, CA
Keywords: Diff Compare HTA VBScript
Pages: 6 Size: 82 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!  Determining and Reporting Significant Decimal Places for Continuous Data in Mixed Form
  Gary E. Moore, Moore Computing Services, Inc., Little Rock, AR
Keywords: data mixed precision determining significant decimal place Laboratory ECG Vitals
Pages: 6 Size: 138 Kb 
tweet!  Export SAS Data to Excel in SAS® Drug Development
  Chun Feng, Celerion, Lincoln, NE; Xiaopeng Li, Celerion, Lincoln, NE
Keywords: SAS Drug Development Export ODS ExcelXP tagset Data Explorer Excel
Pages: 10 Size: 355 Kb 

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

Coders Corner
tweet!  Producing Clinical Laboratory Shift Tables From ADaM Data
  Rao Bingi, Octagon Research Solutions, Wayne, PA
Keywords: lab shift table shift table SAS ADaM shift tables proc freq Rao Bingi Bingi proc sql CDISC
Pages: 12 Size: 385 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!  Plotting an Error/Line Plot and Bar Graph in a Single Plot with Dual Y-Axis Scales
  Sanjiv Ramalingam, Octagon Research Solutions Inc.
Pages: 6 Size: 205 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!  Reading Title and Footnote from RTF Output into SAS® utilizing Microsoft® Excel
  Ajay Gupta, PPD Inc, Morrisville, NC
Keywords: WORD EXCEL DDE ODS
Pages: 6 Size: 107 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 
tweet!  Beyond the Comma Delimited File for Bringing Data into a SAS Dataset
  David Franklin, TheProgrammmersCabin.com, Litchfield, NH
Keywords: datastep csv
Pages: 5 Size: 96 Kb 
tweet!  Semi log plots - Getting the axis tick mark labels in expanded Log10 scale
  Neha Mohan, i3 Statprobe (Ingenix Pharmaceutical Services), Mumbai, India
Keywords: Semi-log plots
Pages: 5 Size: 50 Kb 
tweet!  Quick – Ready Set Retain, and Maybe Reset!
  Lisa Fine, United Biosource Corporation, Ann Arbor, MI
Keywords: RETAIN RESET CONCATENATE INTERLEAVE MERGE
Pages: 8 Size: 133 Kb 
tweet!  A Programmer's Introduction to Survival Analysis Using Kaplan Meier Methods
  John Ventre, United Biosource Corporation, Blue Bell, PA; Lisa Fine, United Biosource Corporation, Ann Arbor, MI
Keywords: Survival Analysis Kaplan Meier
Pages: 8 Size: 232 Kb 
tweet!  Combining RTF Graphs
  Lucius Reinbolt, Celerion, Lincoln, Nebraska
Keywords: ODS RTF SAS/GRAPH
Pages: 4 Size: 30 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!  Some Useful Techniques of Proc Format
  Stan Li, Minimax Information Services, Belle Mead, NJ
Keywords: Format Very Large Dataset
Pages: 6 Size: 51 Kb 
tweet!  Your Age In People Years: Not All Formulas Are the Same
  Art Carpenter, California Occidental Consultants, Anchorage, AK
Keywords: Age INTCK YRDIF datetime time birthday
Pages: 5 Size: 106 Kb 
tweet!  Permutation via Recursive SAS® Macro
  Jian Dai, Clinovo, Sunnyvale, CA
Keywords: macro
Pages: 5 Size: 61 Kb 
Best Paper
tweet!  Importing and Parsing Comments From a PDF Document With Help From Perl Regular Expressions
  Joel Campbell, PPD, Inc., Wilmington, NC; Ryan Wilkins, PPD, Inc., Wilmington, NC
Keywords: XFDF PDF Importing Parsing aCRF blankcrf.pdf XML Mapper PRXMATCH PRX PRXPOSN PRXPARSE XML Libname engine Perl Regular Expressions
Pages: 5 Size: 360 Kb 
tweet!  Choosing the Best Method to Create an Excel Report
  Romain Miralles, Clinovo, Sunnyvale, CA
Keywords: excel excelxp tagset ods dde proc export libname engine
Pages: 12 Size: 452 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!  Using Two SET Statements in One DATA Step
  Ben Cochran, The Bedford Group, Raleigh, NC
Pages: 5 Size: 99 Kb 
tweet!  2 PROC TRANSPOSEs = 1 DATA Step DOW-Loop
  Nancy Brucken, i3 Statprobe, Ann Arbor, MI
Keywords: DOW-Loop transpose
Pages: 4 Size: 33 Kb 

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

Coder's Corner
tweet!  Looking for a function called LEAD?Couldn't find?Here you go - multiple ways to simulate it
  Niraj Pandya, Element Technologies Inc.; eClinical Solutions, A Division of Eliassen Group
Keywords: LEAD FUNCTION LAG POINT
Pages: 5 Size: 129 Kb 
tweet!  Methodologies to Create Multiple Symbols on a Single Line Plot
  Sanjiv Ramalingam, Octagon Research Solutions;Lelia McConnell, SAS Institute
Keywords: Multiple Symbols Single Line Plot
Pages: 5 Size: 174 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!  Which Sub-macros are Called by that macro?
  Ginger Redner, Merck & Co., Inc.
Keywords: Sub-macros macro libraries
Pages: 7 Size: 93 Kb 
tweet!  The Interaction Between the SYNTAXCHECK and OBS= System Options During Batch Unix Sessions
  Robert Adams, Merck & Co., Inc.
Keywords: Unix Batch SAS session SAS System Option
Pages: 4 Size: 23 Kb 
tweet!  Importing Data from RTF Output into SAS® utilizing Microsoft® Access/Word in an intriguing, efficient way
  Ajay Gupta, MPI Research;Matthew Lesko, MPI Research
Keywords: WORD EXCEL ACCESS ODS
Pages: 8 Size: 121 Kb 
tweet!  Updating SDTM Metadata Excel File (Define.xls) with SAS
  Lin Yan, Merck & Co., Inc
Keywords: SDTM Metadata Define Excel CDISC
Pages: 6 Size: 75 Kb 
tweet!  Watermarking SAS® Outputs Without Using Proc Template and ODS
  Sam Mao, Amylin;Jay Zhou, Amylin
Keywords: SAS Output Watermark WordBasic
Pages: 6 Size: 48 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!  Insert Diagnostic Code Using Pipes and PRX (Regular Expression) Functions
  Brian Fairfield-Carter, ICON Clinical Research
Keywords: Diagnostic Code Pipes PRX (Regular Expression) Functions
Pages: 6 Size: 4278 Kb 
tweet!  Non-printable characters: Problems and how to overcome them
  Sridhar Dodlapati, i3 Statprob; Praveen Lakkaraju, Forest Laboratories;Naresh Tulluru, Numeric Technologies Corp;Zemin Zeng, Forest Research Institute, Inc.
Keywords: Non Printable Invisible Special ASCII table TRANTAB Compress K & W modifiers Indexc Byte and Rank
Pages: 13 Size: 200 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 
Best Paper
tweet!  Order, order please: sorting data using proc report
  Lisa Fine, United Biosource Corporation
Keywords: Proc Report Sorting Order
Pages: 9 Size: 122 Kb 
tweet!  Looking for columns with all values missing “ Not any more!
  Binoy Varghese, Cybrid Inc
Keywords: values missing ODS proc datasets
Pages: 5 Size: 57 Kb 
tweet!  An Introduction to Survival Analysis and Creating Kaplan-Meier Curves
  Ojesh Upadhyay, PPD, Inc.
Keywords: Survival Analysis Kaplan-Meier Curves Annotate PROC GPLOT.
Pages: 10 Size: 394 Kb 
tweet!  Embed Special Characters
  Kiran Karidi, Novartis Pharmaceuticals;Mahipal Vanam, EMD Serono, Inc.;Sridhar Dodlapati, i3 Statprob
Keywords: Embed Special Characters Titles FootNotes Hexadecimal Codes
Pages: 5 Size: 102 Kb 
tweet!  SDTM Attribute Checking Tool
  Ellen Xiao, Merck
Keywords: SDTM Checking Tool CDISC
Pages: 6 Size: 176 Kb 
tweet!  A SAS macro to generate Caterpillar plots
  Guochen Song, i3 Statprobe
Keywords: Annotate Catepillar plot macro
Pages: 5 Size: 56 Kb 
tweet!  SAS to Excel using ExcelXP ODS tagset and XML
  Mahipal Vanam, EMD Serono, Inc.;Kiran Karidi, Novartis Pharmaceuticals;Sridhar Dodlapati, i3 Statprob
Keywords: Excel ExcelXP ODS tagset XML
Pages: 7 Size: 189 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!  Wonderful Unix SAS Scripts: SAS Quickies for Dummies
  Raoul Bernal, Amgen Inc
Keywords: Unix shellscript script
Pages: 9 Size: 93 Kb 

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

Coder's Corner
tweet!  Step-by-Step approach in generating multiple plots on one page
  Yogesh Pande
Pages: 7 Size: 89 Kb 
tweet!  MACRO %NEWFLOW
  JIAN (DANIEL) HUANG
Keywords: macro
Pages: 7 Size: 45 Kb 
tweet!  Producing Simple and Quick Graphs With PROC GPLOT
  Sheng Zhang
Pages: 6 Size: 61 Kb 
tweet!   Customizing Your Own Box Plot
  Wenjie Wang
Pages: 7 Size: 126 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!  SAS 1-liners
  Stephen Hunt
Pages: 6 Size: 65 Kb 
tweet!  One-step change from baseline calculations
  Nancy Brucken
Keywords: DOW-Loop DATA Step change from baseline
Pages: 5 Size: 42 Kb 
Best Paper
tweet!  Multiple Graphs on One Page Using GREPLAY with "100% Templates"
  Dirk Spruck
Keywords: GREPLAY multiple graphs 100%-templates
Pages: 9 Size: 226 Kb 
tweet!  Presenting Descriptive Statistics by the Rapid Processing of Datasets from Proc Means
  Rod Norman
Keywords: ODS proc freq proc univariate
Pages: 4 Size: 42 Kb 
tweet!   Sleepless in Seattle - For How Many Consecutive Nights?
  Fikret Karahoda
Pages: 4 Size: 32 Kb 
tweet!   Using SAS® to Create Graphs with Pop-up Functions
  Shiqun (Stan) Li
Pages: 7 Size: 183 Kb 
tweet!   Automated Verification of Data Set Metadata to Specification
  David Gray
Keywords: Automate verify specification data set metadata
Pages: 8 Size: 124 Kb 
tweet!   Get Your TLGs LinkedIn: Dynamically Hyperlinked Metadata and Output Files
  Suzanne Humphreys
Pages: 7 Size: 293 Kb 
tweet!  Dynamic reporting – a data driven approach
  Shan Bai
Pages: 4 Size: 66 Kb 
tweet!  Check cumulative incidence plot
  Lin Yan
Pages: 6 Size: 48 Kb 
tweet!  Importing Data from Microsoft Word into SAS®
  Jay Zhou
Keywords: Data SAS Word Import DDE Word2SAS
Pages: 5 Size: 43 Kb 
tweet!  Your Place or Mine: Data-Driven Summary Statistic Precision
  Nancy Brucken
Keywords: precision data
Pages: 4 Size: 36 Kb 
tweet!  Are you computing Confidence Interval for binomial proportion using PROC FREQ? Be Careful!!
  Sandeep Sawant
Pages: 6 Size: 60 Kb 
tweet!  Touring the SASHelp Neighborhood
  William Turner
Pages: 12 Size: 476 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!  Reverse-engineer a Reference Curve: Capturing Tabular Data from Graphical Output
  Brian Fairfield-Carter
Pages: 6 Size: 231 Kb 

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

Coder's Corner
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!  %LOGCHECK: a Convenient Tool for Checking Multiple Log Files
  Suzanne Humphreys, Cardiome Pharma Corp
Pages: 9 Size: 102 Kb 
tweet!  Embrace Your Inner Programmer: An Overview of the Critical Elements of Outstanding Programming
  Melissa Martinez, Ba Research International LP
Pages: 6 Size: 34 Kb 
tweet!  Dynamically Create Variable Labels from Data Set Values
  Wei Xu, Boston Scientific
Pages: 4 Size: 48 Kb 
tweet!  Display gene network using Data Step Graphics Interface (DSGI)
  Wenjie Song, Johns Hopkins University
Pages: 7 Size: 256 Kb 
tweet!  Line Feeds — How to detect them and get rid of them?
  Kalyani Kothapalli, MDS Pharma Services
Keywords: Line feed LF CSV DSD missover
Pages: 5 Size: 300 Kb 
tweet!  SQL or not SQL When Performing Many-to-Many Merge — A Realistic Example
  Jade(xiqun) Huang, Merck Co.
Keywords: SQL
Pages: 6 Size: 52 Kb 
tweet!  An Application of the SAS® Hash Object
  John King, Ouachita Clinical Data Services, Inc.
Keywords: HASH VNEXT 'FIRST.variable' 'LAST.variable'
Pages: 3 Size: 21 Kb 
tweet!  Backup Early, Backup Often / CC09b: Backup from the Startup
  Paul McDonald, PRA International
Pages: 7 Size: 69 Kb 
Best Paper
tweet!  Table Numbers - Chaos to Simplicity
  Michael Stout, DePuy, a Johnson Johnson company
Pages: 6 Size: 36 Kb 
tweet!  Exploring the SAS Macro Function %SYSFUNC
  Lin Yan, Merck Co., Inc
Keywords: macro
Pages: 5 Size: 45 Kb 
tweet!  An Alternative Method of Transposing Multiple Variable for Report Generation
  Li Luo, Wyeth
Pages: 7 Size: 105 Kb 
tweet!  An Automatic Process to Compare Files
  Simon Lin, Merck Co.
Pages: 6 Size: 110 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!  Tips and Tricks in Creating Graphs Using PROC GPLOT
  Qin Lin, Applied Clinical Intelligence, LLC
Pages: 7 Size: 160 Kb 
tweet!  Smoke and Mirrors !!! Come see how the _INFILE_ automatic variable and SHAREBUFFERS infile option can speed up your flat file text processing throughput speed.
  William Benjamin, Owl Computer Consultancy, LLC
Pages: 8 Size: 800 Kb 
Best Paper
tweet!  One-Step Change from Baseline Calculations
  Nancy Brucken, i3 Statprobe
Keywords: DOW-Loop change from baseline
Pages: 5 Size: 30 Kb 
tweet!  Taking Out the Garbage
  Adam LaManna, Howard Proskin and Associates, Inc.
Keywords: macro macros
Pages: 3 Size: 33 Kb 
tweet!  When a Period Really is Not a Period and How to Fix It
  William Csont, H.M. Proskin Associates, Inc.
Keywords: Missing DDE Import Excel
Pages: 4 Size: 164 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!  Exploitation of Metadata for Restructuring Datasets and Code Generation
  Bradford Danner, MDS Pharma Services
Pages: 6 Size: 89 Kb 
tweet!  An Annotated Guide: Using Proc Tabulate And Proc Summary to Validate SAS Code
  Yanmei Lu, Datameans
Keywords: tabulate
Pages: 13 Size: 207 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!  Annotate facilitates data-driven graphs
  Meera Kumar, Sanofi-Aventis
Pages: 5 Size: 97 Kb 
tweet!  Watermarking SAS® Outputs Without Using Proc Template and ODS
  Jay Zhou, Amylin Pharmaceuticals, Inc., San Diego, CA
Keywords: Watermark SAS Output Word Document WordBasic DDE
Pages: 6 Size: 78 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!  Creating Special Symbols in SAS® Graph
  Shiqun Li, MiniMax Information Services
Keywords: Special Symbol Special Character SAS/Graph NOTE-MOVE Subscription Superscription Underline Customized Font
Pages: 6 Size: 122 Kb 

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

Coder's Corner
tweet!  Teaching a New Dog Old Tricks - Using the EXCEPT Operator in PROC SQL and Generation Data Sets to Produce a Comparison Report
  Stanley E Fogleman, Harvard Clinical Research Institute
Keywords: generation datasets proc sql compare
Pages: 3 Size: 36 Kb 
tweet!  Link the Unlinked : Documenting Dependencies Among SAS Programs in a Project
  Gopal Rajagopal, Merck & Co.
Keywords: link program metatdata program dependency documentation Unix utility
Pages: 8 Size: 122 Kb 
tweet!  DrSearch: Recursive SAS Macro Solution for Understanding Complete Program Dependencies in Large SAS Reporting System (LSRS)
  Jim Fang, sanofi aventis
Keywords: Recursive SAS Macro Large SAS reporting system Program dependency Excel spreadsheet
Pages: 5 Size: 62 Kb 
tweet!  Coding Technique to Validate Output Automatically
  Hui-Ping Chen, Eli Lilly and Company
Keywords: Validation translate tranwrd
Pages: 4 Size: 29 Kb 
tweet!  In The Compute Block: Issues Associated with Using and Naming Variables
  Art Carpenter, CA Occidental Consultants
Keywords: PROC REPORT Compute Block Computed variables Composite names Report items
Pages: 9 Size: 63 Kb 
tweet!  Reading Format Values From Formats Library and Creating Labels Automatically
  Kalyani Kothapalli, MDS Pharma Services
Keywords: CNTLOUT PROC FORMAT Adverse event severity relationship
Pages: 4 Size: 149 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!  Taking the PROC SUMMARY a Step Beyond
  Priya Suresh, RTI International
Keywords: Pattern matching PROC SUMMARY
Pages: 7 Size: 43 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!  PROC FORMAT Advanced Techniques: Multi-label and Nested Formats
  Tatiana A Nevmyrych, PPD; Jennifer Clark, Associate Programming Manager
Keywords: proc format multi-label format nested format
Pages: 4 Size: 168 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!  2 PROC TRANSPOSEs = 1 DATA Step DOW-Loop
  Nancy Brucken, i3 Statprobe
Keywords: Transpose DOW
Pages: 4 Size: 28 Kb 
Best Paper
tweet!  Using GSLIDE Procedure to Assemble Multiple Graphs on One Single Page
  Louie Huang, Baxter BioScience
Keywords: PROC GSLIDE SAS/GRAPH PROC GPLOT GOPTIONS HORIGIN VORIGIN ODS LAYOUT
Pages: 10 Size: 135 Kb 
tweet!  How to Avoid Overwriting Work Data Sets and Work Formats - An Essential Macro Design Topic
  Zizhong (James) Fan, MedImmune, Inc.
Keywords: Macro Design Work Library Overwrite
Pages: 7 Size: 244 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!  Statistical Outputs as Groups of Related Data: Pagination Techniques
  Alexandr G Alexin, Quintiles, Inc.
Keywords: report pagination pagination technique
Pages: 6 Size: 115 Kb 
Best Paper
tweet!  Using Multiple Output Statements in the SUMMARY Procedure
  Britney D Gilbert, PPD
Keywords: PROC SUMMARY OUTPUT statement
Pages: 3 Size: 42 Kb 
tweet!  Three Step Table Validation
  Yang Chen, Forest Laboratories Inc.
Keywords: SAS Table Validation Macro
Pages: 7 Size: 43 Kb 
tweet!  Several Graph Types in Clinical Studies
  Long Zheng, Allergan; Suriani Pokta, Allergan; Pan-Yu Lai, Allergan
Keywords: Graph Parallel line Bubble Success-Failure Lab shift Proportion Logistic Regression
Pages: 8 Size: 70 Kb 
Best Paper
tweet!  The Creation of Time Deviations
  Karen N Easterling, PPD, Inc.
Keywords: Time Deviations Daylight Savings
Pages: 5 Size: 44 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!  Tips and Tricks of Handling Comprehensive ODS Output with SAS 9
  Huei-Ling Chen, Merck & Co., Inc.; Liping Huang, Hoffmann-La Roche
Keywords: ODS HTML GRAPH PROC REPORT GPATH GFOOTNOTE ANCHOR
Pages: 8 Size: 183 Kb 
tweet!  Taking a Walk on the Wildside: Use of the PROC CDISC-SDTM 3.1 Format
  William C Csont, H.M. Proskin & Associates, Inc.
Keywords: PROC CDISC SDTM
Pages: 6 Size: 48 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!  Sorting Out the Possibilities Using Retain
  Tommy Retzlaff, Quintiles, Inc.
Keywords: proc sort retain flags
Pages: 3 Size: 31 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 

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

Coder's Corner
Best Paper
tweet!  Building Stronger Axes for Your SAS Graph Wagons
  Don (Dongguang) Li, NCIC-CTG, Queen's University
Keywords: SAS Graphs Axes graphics
Pages: 6 Size: 207 Kb 
tweet!  Numeric Precision in SAS - an Example
  Varsha C. Shah, University of North Carolina
Keywords: Numeric Precision Discrepancy
Pages: 3 Size: 66 Kb 
tweet!  Page Breaks: Simple and Effective Ways to Neatly Present Data
  Suzanne M. Humphreys, PRA International
Keywords: Page breaks PROC REPORT adverse events counting
Pages: 9 Size: 50 Kb 
tweet!  Put Down That Mouse!
  Daniel J. Boisvert, Genzyme
Keywords: Keyboard shorcuts Display manager Mouse
Pages: 5 Size: 96 Kb 
tweet!  General Methods to Use Special Characters
  Dennis Gianneschi, Amgen, Inc.
Keywords: special characters character map unicode ODS RTF
Pages: 6 Size: 106 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!  When a Shortcut Is More Than a Quick Fix
  Robert A. Diseker, PPDI
Keywords: _all_ short cut quick fix
Pages: 6 Size: 161 Kb 
tweet!  A New Approach to Display Multiple Graphs in One Page And Individual Patient Profile Graph
  Long Zheng, Allergan, Inc.
Keywords: Coordinate Shifting Graph Patient Profile GREPLAY
Pages: 10 Size: 272 Kb 
tweet!  Using ODS Document with SAS/Graph to Remove Unwanted PDF Bookmarks
  John J. Reilly, DataCeutics
Keywords: ODS Document Proc Document SAS/Graph ODS PDF Bookmarks
Pages: 5 Size: 187 Kb 
tweet!  Just Enough SAS to Identify Yourself in a Networked World
  Paul D. Sherman, self; Na Li, Pharmacyclics, Inc.
Keywords: SAS X-command sysexec net.exe net use
Pages: 6 Size: 186 Kb    Download the presentationdownload (.ppt, 272 Kb)
tweet!  Create Descriptive Documentation with hyper-links for SAS Database
  Don (Dongguang) Li, NCIC-CTG, Queen's University
Keywords: database document contents procedure hyper-links
Pages: 4 Size: 83 Kb 
tweet!  Hidden Data Loss in Manipulation of Data
  Tim Tian, Biogen Idec Inc.
Keywords: data manipulation data step first. last. data loss delete
Pages: 5 Size: 201 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)

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

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 
tweet!  THE DATA and SPECS IN SEPARATE FILES
  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.
Keywords: SASAUTOS AUTOCALL SYSFUNC GETOPTION macro
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 con ...
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
Keywords: PROC FREQ NLEVELS ZEROS CONTENTS CROSSLIST NOSPARSE NOWARN WEIGHT TABLES ODS
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
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!  Processing Name/Value Input in SAS Web Applications
  Don Boudreaux, SAS Institute Inc.
Keywords: web IntrNet Stored_Process internet
Pages: 5 Size: 119 Kb 

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

Coder's Corner
tweet!  A Technique to Create a Numeric Variable from a Character Variable
  Hany Aboutaleb, BiogenIdec
Keywords: Technique Numeric Character
Pages: 6 Size: 167 Kb 
Best Paper
tweet!  Using SAS to Speed Up Annotating Case Report Forms in PDF Format
  Dirk Spruck, Covidence GmbH; Monika Kawohl, Covidence GmbH
Keywords: Annotated CRF PDF FDF copy annotations
Pages: 7 Size: 114 Kb 
tweet!  A Simplified Way to Create Flags for the Three-Dimensional Prior, Concomitant and Post Medication
  Aileen L. Yam, Aventis, Inc.
Keywords: simplified prior concomitant post study medication non-study medication flag
Pages: 5 Size: 148 Kb 
Best Paper
tweet!  Backups at the Click of the Mouse
  Jim Box, RTI International; Joey Morris, RTI International
Keywords: Backup archiving automated process DOS commands
Pages: 5 Size: 105 Kb 
tweet!  Integration of Microsoft Office and SAS Software: Implementation of GUI and Automation
  Rubin Nan, PRA International; David Mullins, PRA international
Keywords: SAS Graphical User Interface Automation Microsoft Office Visual Basic
Pages: 5 Size: 27 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!  Using Compute Blocks in PROC REPORT
  Sharon Dunn, Sepracor
Keywords: Compute Block Page Specific Titles Text Limitations Page Stamp
Pages: 4 Size: 122 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!  Cutting the SAS LOG Down to Size
  Malachy J. Foley, University of North Carolina
Keywords: LOG NOTE ERROR WARNING INFO messages
Pages: 7 Size: 177 Kb 
tweet!  Use Regression Algorithm Identifying Repeated Use Patients
  Haibin Shu, Barr Research
Keywords: Repeat Algorithm Macro Regression
Pages: 4 Size: 101 Kb 
tweet!  Frequency Generation Using Indicator Variable
  Jinshi Zhou, Quintiles
Keywords: Indicator Variable Frequency Table Data Step Proc Univariate
Pages: 3 Size: 92 Kb 
tweet!  Creating a Mixed-Case Format for Mono-Case Data Using an Input Control Data Set with PROC FORMAT
  Lisa A Soberano, PPD Development, Inc.
Keywords: mixed case monocase proc format cntlin= cntlout= functions data formats character
Pages: 7 Size: 394 Kb 
tweet!  Common Error: Wrong Result
  Varsha C. Shah, University of North Carolina
Keywords: first last lag qc
Pages: 5 Size: 23 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!  Using a Decision Table to Program Complex Date Logic
  Arthur N. Collins, Biogen Idec, Inc.
Keywords: Date Logic Statistician AE Treatment Emergence Concomitance
Pages: 4 Size: 18 Kb 
tweet!  GSUBMIT: Simple Customization of your SAS Application Toolbar in SAS for Windows
  Robert E. Howard, Synteract, Inc.
Keywords: GSUBMIT SAS for Windows Application Toolbar Customize
Pages: 2 Size: 16 Kb 
tweet!  PROC POWER: V9.1
  Deborah J. Bauer, Sanofi-Synthelabo.
Keywords: power sample size software packages comparison
Pages: 6 Size: 113 Kb 

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

Coders Corner
tweet!  A One-Step Method for Finding the Closest Match
  Erin Christen, STATPROBE, Inc.
Keywords: SQL closest match merge close merge near merge
Pages: 2 Size: 77 Kb 
tweet!  Reading Data from A Large Number of External Files: How to Do It Efficiently?
  Chang-Min Chen, Merck & Co.
Keywords: external files SAS dataset SAS functions INFILE statement
Pages: 4 Size: 91 Kb 
tweet!  Counting the Number of Episodes of a Given Disease from Diary
  Jose F Diaz, GlaxoSmithKline
Keywords: DATA STEP COUNT DIARRHEA CHRONIC
Pages: 2 Size: 31 Kb 
tweet!  Tired in Defining Axis Scale for SAS Graphs? A Solution with Automatic Optimizing Approach
  Don Li, National Cancer Institute of Canada - CTG
Keywords: SAS Graphs Axis Scale GPLOT procedure Automation
Pages: 4 Size: 130 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!  Cross-referencing Data Contents and Case Report Form
  Sam Mao, Quintiles, Inc
Keywords: data contents format decodes CRF SAS options
Pages: 4 Size: 42 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!  To Wrap up an Extremely Long Comments Variable -- Take the Advantage of SAS ODS Template, ODS Listing
  Peter Jiang, Venturi Technology Partners
Keywords: ODS Template Listing Wrap-up
Pages: 4 Size: 62 Kb 
Best Paper
tweet!  A SAS Annotate System for Figure Generation
  Brian Fairfield-Carter, PRA International
Keywords: Figures Annotate SAS/Graph VBScript Windows Scripting Host
Pages: 6 Size: 120 Kb 
tweet!  Queries by ODS beginners
  Varsha Shah, CSCC, Dept. of Biostat, Univ. of North Carolina
Keywords: codes for frequent questions
Pages: 8 Size: 165 Kb 
tweet!  Adjusting Dates in a New Century
  Malachy (Mal) Foley, University of North Carolina
Keywords: Y2K YEARCUTOFF Dates Formats
Pages: 2 Size: 73 Kb 
tweet!  A Method To Create Descriptive Statistics Using The CLASS Statement
  Jihong Jin, Joint Commission on Accreditation of Healthcare Or
Keywords: descriptive statistics tabular report SAS procedures Class variables
Pages: 6 Size: 202 Kb 
tweet!  The SAS Data step/macro interface.
  Lawrence Heaton-Wright, Quintiles Limited
Keywords: Macro symput execute datastep
Pages: 4 Size: 92 Kb 
tweet!  You be Your Own QC Cop - Check your .SAS, .LOG and .LST dates from Within SAS Using Operating System Commands
  Venky Chakravarthy
Keywords: QUALITY CONTROL FORMAT _INFILE_ SCAN .SAS .LOG .LST DATE TIME DATETIME
Pages: 4 Size: 144 Kb 
tweet!  An Useful Chart of the Global Assessment in Clinical Trials
  Zhongwei Zhou, Novartis Pharmaceuticals Co., East Hanover, NJ; Chuanchieh Hsu, Novartis Pharmaceuticals Co., East Hanover, NJ; J. Michael Hardin, University of Alabama, Tuscaloosa, AL
Keywords: Global assessment graphical visualization clinical trials ANOVA Model
Pages: 4 Size: 164 Kb 
tweet!  Using Compute Blocks in Proc Report
  Sharon Gonzalez, Biogen
Keywords: compute block page specific titles text limitations page stamp
Pages: 4 Size: 70 Kb 
tweet!  Version Comparison: A Powerful, Flexible and Easy Method
  Vineet Mathur, Savant Consulting Group Inc.
Keywords: version comparison tracking changes differences file control
Pages: 4 Size: 130 Kb 
tweet!  Automatically Obtaining and Using Data Creation Dates
  Varsha Shah, CSCC, Dept. of Biostat, Univ. of North Carolin; Kathy Roggenkamp, CSCC, Dept. of Biostat, Univ. of North Carolina
Keywords: Two Methods for Obtaining datacreation date
Pages: 2 Size: 157 Kb 

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

Coders Corner
tweet!  Efficient Interpolation Calculation
  Julia Zhang, GlaxoSmithKline; David Chen, EDP Contract Services
Keywords: interpolation calculation missing value SCL function FETCHOBS VARNUM GETVARN/GETVARC OPEN/CLOSE
Pages: 4 Size: 117 Kb 
tweet!  Streamlining SAS® Data Listings to Match CRF Data Flow for Use in Limited Internal Audits
  Michael Acra, Glaxo Smith Kline; Greg Henkle, Glaxo Smith Kline
Keywords: data printouts listings data audits data comparison
Pages: 2 Size: 130 Kb 
tweet!  A data dictionary. A more complete alternative to Proc contents.
  Angelina Cecilia Casas, PPD Development
Keywords: proc contents dictionary.table dictionary.column proc format
Pages: 4 Size: 20 Kb 
tweet!  Don't copy this program: use SYSPARM instead
  Steve Wong, Wyeth-Ayerst/Genetics Institute
Keywords: sysparm option unix flexible
Pages: 4 Size: 100 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!  Making SAS Output Pretty - Creating Customized Documents for your Clients
  Elaine Dempsey, Rho Inc.
Keywords: graphics DSGI custom datastep documentation
Pages: 4 Size: 119 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!  Reduce Paper Output When Using SAS® Proc Compare (A Validator's Dream Come True!)
  Lila Thome, PPD, Inc.
Keywords: compar proc validat sashelp vtable output proc compare sashelp.vtable
Pages: 4 Size: 19 Kb 
tweet!  Create Directory on Windows Without the Fleeting DOS Window
  Hsiwei Yu, PTS Inc; Gary Huang
Keywords: PIPE FILENAME DOS COMMAND
Pages: 2 Size: 81 Kb 
tweet!  Proc Report and ODS
  Cindy Stroupe, Inveresk Research
Keywords: proc report ods style options
Pages: 4 Size: 96 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 

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

Coder's Corner
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!  A SAS® Macro for Evaluating Whether All, Any, or None of the Variables in a List Have Been Marked - Application for Clinical Data Validation
  Art Collins, REGISTRAT, Inc., Lexington, KY
Keywords: SAS Macro Facility Validation Edits
Pages: 2 Size: 16 Kb 
tweet!  A Wildcard Character for Variable Lists
  Malachy J. Foley, University of North Carolina at Chapel Hill, NC
Pages: 4 Size: 20 Kb 
tweet!  Automate and Customize Printing of SAS Output in UNIX
  Cailiang Mao, Quintiles, Inc. Kansas City, MO
Keywords: SAS Output printing UNIX libname pipe
Pages: 2 Size: 25 Kb 
tweet!  P-Value Calculation Made Easy with the SAS® Call Execute Routine
  Huanhong Xia, AstraZeneca, Wayne, PA 19087; Richard Birkenmaier, AstraZeneca, Wayne, PA 19087
Pages: 4 Size: 18 Kb 
tweet!  The Efficiency of Proc SQL in Place of Traditional Procedures for Large Data Sets
  Cindy Stroupe, ClinTrials Research, Inc., Cary, NC
Keywords: SQL
Pages: 4 Size: 15 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!  Using Special Characters and Formats with SAS®
  Quan Ren, Kendle International Inc. Cincinnati, OH
Keywords: SAS Character Format Byte DDE Word Superscript
Pages: 4 Size: 27 Kb 

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

Coder's Corner
Best Paper
tweet!  Calculating a Nonparametric Estimate and Confidence Interval Using SAS® Software
  Chris Decker
Pages: 3 Size: 22 Kb 
tweet!  Producing Special Characters in SAS® Output in RTF
  Cindy Song
Pages: 2 Size: 46 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!  Reading Multiple and Row Oriented External Files
  Fan Xu
Pages: 4 Size: 54 Kb 
tweet!  POINT: A Useful Way to Get around Your Data
  Greg Silva
Pages: 4 Size: 25 Kb 

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

Coders Corner
tweet!  Printing a Random Sample of a Large Data Sets
  Hany Aboutaleb, Pfizer Inc., NYC NY
Keywords: Printing Random Sample
Pages: 4 Size: 19 Kb 
tweet!  Deciphering the _TYPE_ Variable in MEANS and SUMMARY Output Data Sets
  Arthur L. Carpenter, California Occidental Consultants
Keywords: TYPE
Pages: 3 Size: 15 Kb 
tweet!  The Impact and Detection of Duplicate Records
  Alice M. Cheng, Pfizer, Inc., New York, New York
Keywords: Data
Pages: 11 Size: 69 Kb 
Create a Dot Plot Using PROC GPLOT by Simple Manipulation of the Data
  Lori Griffin, Hoechst Marion Roussel, Inc.
tweet!  Comparing Clinical Trials Data Using Population Trees
  Lisa M. Hlina, Quintiles, Inc., Research Triangle Park, NC
Keywords: Comparing
Pages: 7 Size: 1127 Kb 
tweet!  Uses of PROC SQL as a Reporting Tool and For Joining Data
  John Hotaling, Quintiles, Inc., Boston, MA
Keywords: Magic SQL
Pages: 3 Size: 26 Kb 
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!  Advanced Techniques for Creating Format with Variables Values
  Erika Liu, Allergan, Irvine, California
Keywords: Advanced LIU Erika
Pages: 3 Size: 11 Kb 
tweet!  Graphically Enhancing the Visual Presentation and Analysis of Univariate Data using SAS Software
  James R. O'Hearn, Pfizer Inc., New York, NY
Keywords: Graph O'Hearn
Pages: 5 Size: 87 Kb 
tweet!  Interpretation of statistical analysis for repeated measures
  Armand Rostami, Pfizer Inc., New York, NY
Keywords: Inteerpretion Rostami
Pages: 3 Size: 39 Kb 
Generating Multiple SQL Modules from a Single SAS Program
  Diana L. Williams, ClinTrials Research, Inc.; Drew K. Edwards, Research Triangle Park, NC
Keywords: SQL

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

Coders' Corner
tweet!  Printing with SAS 6.10 and 6.11
  Hany Aboutaleb, Pfizer Inc. New York, NY
Pages: 4 Size: 210 Kb 
tweet!  More About Missing Character Data
  Hany Aboutaleb, Pfizer Inc. New York, NY
Pages: 2 Size: 117 Kb 
tweet!  Better Titles: Using The #BYVAR and #BYVAL Title Options
  Arthur L. Carpenter
Pages: 3 Size: 163 Kb 
tweet!  Playing With Macros: Take The Work Out Of Learning To Do Macros
  Arthur L. Carpenter
Keywords: macro
Pages: 6 Size: 272 Kb 
tweet!  Year 2000 Hex Storage
  Kirk Paul Lafler, Millennium Technologies Institute, Inc.; Sunil Kumar Gupta, Millennium Technologies Institute, Inc.; Charles Edwin Shipp, Millennium Technologies Institute, Inc.
Pages: 3 Size: 213 Kb 
tweet!  PROC TRANSPOSE As A Useful Intermediary Step In Generating Tables And Listings
  Tony T. Salehi, Chastain Research Group, Inc., South San Francisco, CA
Pages: 11 Size: 426 Kb 
tweet!  Accessing Multiple Versions of a Database with One Set of Programs
  Spring Tseng, Genetics Institute, Cambridge, Massachusetts; Kirsten MacDonald, Genetics Institute, Cambridge, Massachusetts
Pages: 3 Size: 171 Kb 
tweet!  Some Less Known but Powerful Proc SQL Features
  Jun Zhao, Boehringer Ingelheim Pharmaceuticals, Inc. Ridgefield, CT
Keywords: SQL
Pages: 4 Size: 181 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 
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.