Home
Contact
SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PharmaSUG China papers
SAS:PhUSE papers
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

Titles
Loading
SAS SUGI proceedings: Coders' Corner (SUGI 31 and later), 714 papers

SAS Global Forum 2012   April 22-25, 2012 - Orlando, Florida

Coders' Corner

tweet!  One Flip, Two Flip, Fat File Flat File
Ethan Miller 
Pages: 6 Size: 50 Kb 
tweet!  Sometimes One Needs an Option with Unusual Dates
Arthur S. Tabachneck  Matthew J. Kastin  Xia K. Shan 
Pages: 14 Size: 373 Kb 

    resource Additional resource: sasCommunity.org

tweet!  Intelligent PROC SORT NODUPKEY
Andrea Wainwright-Zimmerman 
Pages: 5 Size: 152 Kb 
tweet!  Log Checks Made Easy
Yogesh Pande 
Pages: 4 Size: 241 Kb 
tweet!  It's Now Your Project—Clean It Up and Make It Shine
Leonard Polak 
Pages: 10 Size: 117 Kb 
tweet!  Magic Spells with SAS®
Christopher J. Bost 
Pages: 5 Size: 43 Kb 
tweet!  Beep, Beep, Beep, Back It Up! A Foolproof Approach to Archiving with No Copying
Kristen Reece Harrington 
Pages: 3 Size: 66 Kb 
tweet!  Working the System: Our Best SAS® Options
Patrick Thornton  Iuliana Barbalau 
Keywords: OPTIONS REPLACE MERGENOBY= MSGLEVEL= VALIDVARNAME NODATE NONUMBER ORIENTATION= FORMDLIM= PDFSECURITY= FMTSEARCH= MPRINT MLOGIC MPRINT SYMBOLGEN
Pages: 10 Size: 158 Kb 
tweet!  Yes, We Can... Save SAS® Formats
John F. Ladds 
Pages: 6 Size: 193 Kb 
tweet!  Best Practices: Clean House to Avoid Hangovers
Mary F. Rosenbloom  Kirk Paul Lafler 
Keywords: SAS programming style documentation code-level documentation PROC DATASETS PROC OPTSAVE PROC OPTLOAD Rosenbloom Kirk Paul Lafler Lafler
Pages: 7 Size: 415 Kb 
tweet!  Generation Why: How Generation Data Sets Can Help
Lisa Eckler 
Pages: 7 Size: 67 Kb 
tweet!  The DOW Loop: A Smarter Approach to Your Existing Code
Fuad J. Foty 
Pages: 12 Size: 71 Kb 
tweet!  Ethnicity and Race: When Your Output Isn't What You Expected
Philamer M. Atienza 
Pages: 5 Size: 115 Kb 
tweet!  Increase your OUTPUT with PROC MEANS and PROC FREQ
Julie M. Kezik  Melissa E. Hill 
Pages: 7 Size: 446 Kb 
tweet!  A SAS® Macro to Zip and Unzip Files in MS Windows without Additional External Data Archiving Software
Kai Koo 
Keywords: macro
Pages: 5 Size: 113 Kb 
tweet!  Inventory Your Files Using SAS®
Brian Varney 
Pages: 5 Size: 65 Kb 
tweet!  Locally Visible, Remote Data and Format
Hsiwei Yu  Kamau Njuguna 
Pages: 3 Size: 48 Kb 
tweet!  Standardized Macro Programs for Macro Variable Manipulation
Chris Swenson 
Keywords: macro
Pages: 7 Size: 132 Kb 
tweet!  How to Use SAS/CONNECT® to Get Your Mainframe to Behave Like a Modern Computer in Your New Business Intelligence Platform
John Hennessey 
Pages: 4 Size: 191 Kb 
tweet!  A Macro to Summarize and Generate a Report of Variables on a SAS® Data Set
Greg Grandits  Greg Thompson 
Keywords: macro
Pages: 4 Size: 35 Kb 
tweet!  Deciphering PROC COMPARE Codes: The Use of the bAND Function
Joseph W. Hinson  Margaret M. Coughlin 
Pages: 9 Size: 210 Kb 
tweet!  Assigning a User-Defined Macro to a Function Key
Mary F. Rosenbloom  Kirk Paul Lafler 
Keywords: SAS, Macro, user-defined macro, Function Key, macro call, validation, verification, V&V, duplicates, Rosenbloom, Mary Rosenbloom, Lafler, Kirk Paul Lafler, clearing the results viewer, SAS 9.3, ODS ...
Pages: 10 Size: 364 Kb 
tweet!  Using Pre-Formatted Microsoft Excel Templates with SAS®
George G. Mendoza  Subhashree Singh 
Pages: 13 Size: 368 Kb 
tweet!  Create Multi-Sheet Excel Workbook for Large Data Sets by SAS® and VBA
Chao Huang 
Pages: 6 Size: 924 Kb 
tweet!  Excel Tool for Coding
Ronald Palanca 
Pages: 4 Size: 161 Kb 
tweet!  PROC REPORT: Dynamic Column Headings
Jason Levy 
Pages: 2 Size: 91 Kb 
tweet!  Splitting Data Sets on Unique Values: a Macro That Does It All
Hans Sempel 
Keywords: macro
Pages: 5 Size: 69 Kb 
tweet!  Techniques for Generating Dynamic Code from SAS® DICTIONARY Data
Jingxian Zhang 
Pages: 7 Size: 139 Kb 
tweet!  ODS Report Writing Interface Makes Our Reporting Simple and Better
Sijian Zhang 
Pages: 10 Size: 634 Kb 
tweet!  Finding Your Way Around a SAS® Generated Report
William C. Murphy 
Pages: 5 Size: 54 Kb 
tweet!  Let the DATA Step Drive the Report Assembly Line
Sijian Zhang 
Pages: 6 Size: 252 Kb 
tweet!  Uploading Your IPEDS Data Electronically Using SAS®
James D. Hume 
Pages: 6 Size: 377 Kb 
tweet!  A Simple Way of Importing from a REST Web Service into SAS® in Three Lines of Code
Philip James Busby 
Keywords: internet
Pages: 5 Size: 183 Kb 
tweet!  Using SAS® and ZIP Codes to Create a Nationwide First Responders Directory
Andrew Hummel 
Pages: 4 Size: 139 Kb 
tweet!  Using DDE and VBA Techniques to Import Data from Microsoft Word Tables in Programming Specification Files into SAS
Mei Li  Zemin Zeng 
Pages: 9 Size: 179 Kb 
tweet!  Sending E-mails in Your Sleep
Andrew Hummel 
Pages: 5 Size: 291 Kb 
tweet!  A Perfect Case of Capturing Data from Related Web Pages
Jinson Erinjeri 
Keywords: internet
Pages: 6 Size: 434 Kb 
tweet!  Customizing ODS Graphical Output for SAS/STAT® Procedures
Yang Xiao  Xiangxiang Meng 
Pages: 9 Size: 225 Kb 
tweet!  Convert Your Old Plots and Charts to New SG Plots and Charts: Here's How
Gabe Cano 
Pages: 13 Size: 432 Kb 
tweet!  %SPARKY: A SAS® Macro for Creating Excel Sparklines
Ted Conway 
Keywords: macro
Pages: 8 Size: 1076 Kb 

    resource Additional resource: sasCommunity.org

tweet!  Adding Count as a Data Label in a Scatter Plot
Suneetha Puttabasavaiah 
Pages: 4 Size: 79 Kb 
tweet!  Have Your Web Reports Remember the Filters of Your Users
Frank Poppe  Andres Van Antwerpen 
Keywords: internet
Pages: 6 Size: 330 Kb 
tweet!  Black Box PROCs: PROC LOGISTIC Discovered
Isabel H. Perry 
Pages: 7 Size: 364 Kb 
tweet!  Optimized 1:N Case-Control Match Using SAS
Zhiwei Wang 
Pages: 5 Size: 115 Kb 
tweet!  Utilize Dummy Datasets in Clinical Statistical Programming
Amos Shu 
Keywords: clinical
Pages: 5 Size: 135 Kb 
tweet!  Using SAS® to Get a Date: Integrating Google Calendar's API with SAS®
William G. Roehl 
Pages: 9 Size: 262 Kb 
tweet!  Batch Production of Driving Distances and Times Using SAS® and Web Map APIs
Ash Roy  Yingbo Na 
Keywords: internet
Pages: 7 Size: 626 Kb 
tweet!  Multidimensional Scaling on ZIP Codes
Chao Huang  Xiangxiang Meng 
Pages: 7 Size: 704 Kb 
tweet!  Three Simple Steps to Recovering and Inserting Data Using Do Loops, Indexed Macro Variables, and PROC SQL Update Statements
Stacey D. Collins 
Keywords: SQL macro
Pages: 4 Size: 164 Kb 
tweet!  Managing Analytic Processes with Paired SAS® Utility Macros
Zhongwen Huang  John Hou 
Keywords: macro
Pages: 6 Size: 358 Kb 
tweet!  SAS® Output Delivery System ExcelXP Tagset: Customizing Cell Patterns, Borders, and Indention
Deepak G. Asrani 
Keywords: ods
Pages: 13 Size: 492 Kb 
tweet!  Translating Foreign Language in SAS® with Google Translate
Murphy Choy 
Pages: 4 Size: 106 Kb 
tweet!  How to Dynamically Conditionalize a SAS® Data Integration Studio Job
Riku E. Jokinen 
Pages: 4 Size: 189 Kb 
tweet!  An Advanced, Multi-Featured Macro Program for Reviewing Logs
Chris Swenson 
Keywords: macro
Pages: 7 Size: 56 Kb 
tweet!  Using SAS® to Manage SAS® Work Area Usage
Urvir Palan 
Pages: 4 Size: 45 Kb 
tweet!  Analysis of Clickstream Data Using SAS®
Sumit Sukhwani  Goutam Chakraborty  Satish Garla 
Pages: 13 Size: 753 Kb 
tweet!  How to Measure the SAS® BI Audience and Discover Information Needs
Plinio Faria 
Pages: 6 Size: 349 Kb 
tweet!  Mining and Merging DATAMONITOR and WRDS Databases with SAS®
Niam Yaraghi  Rajiv Kishore  Rui Chen 
Pages: 5 Size: 298 Kb 
Best Contributed Paper
tweet!  PROC FORMAT, a Speedy Alternative to Sort/Sort/Merge
Jenine Milum 
Pages: 5 Size: 53 Kb 
tweet!  Using SAS® to Build Web Pages Linking Photographs with Google Maps
Arthur S. Tabachneck  William J. Klein 
Keywords: internet
Pages: 12 Size: 597 Kb 

    resource Additional resource: sasCommunity.org


SAS Global Forum 2011   April 4-7, 2011 - Las Vegas, Nevada

Coders' Corner

tweet!  Learn SAS® in 50 Minutes
Subhashree Singh  Sovraj Singh 
Pages: 13 Size: 145 Kb 
tweet!  Top Ten SAS® Sites for Programmers: A Review
Charles E. Shipp  Kirk P. Lafler 
Keywords: SAS support.sas.com LexJansen.com Google sasCommunity.org SAS-L SAS.com NESUG.org blogs.sas.com SESUG.org SAS Global Forum SGF
Pages: 5 Size: 354 Kb 
tweet!  sasCommunity.org Benefits to JMP® Coders
Charles E. Shipp  Kirk P. Lafler 
Keywords: JMP SAS sasCommunity.org data visualization data discovery Blogger's Corner Sasopedia
Pages: 9 Size: 1121 Kb 
tweet!  Some Tricks to Get the Best Out of SAS® and UNIX
Chienchung Chen 
Pages: 6 Size: 453 Kb 
tweet!  Ten Ways to Improve the Efficiency of Clinical Statistical Programming
Amos Shu 
Keywords: clinical
Pages: 5 Size: 226 Kb 
tweet!  Run Your SAS® Job Faster: Parallel Processing with Desktops on LAN
Sijian Zhang  Robert N. Brown  Yu Zhang 
Pages: 9 Size: 216 Kb 
tweet!  SAS® WOW! How to Streamline Your SAS Programs by Shedding Lines and Adding Substance
Lisa A. Mendez  Lizette Alonzo 
Pages: 9 Size: 349 Kb 
tweet!  Impact Analysis – The Smart Way
George G. Mendoza 
Pages: 6 Size: 45 Kb 
tweet!  Turn Web Source Code into SAS® Data in Two Easy Steps
Ryan Massa-McKinley 
Keywords: internet
Pages: 4 Size: 261 Kb 
tweet!  Using ODS TAGSETS.HTMLPANELS to Create Quick Dashboards
Gabe Cano 
Keywords: html
Pages: 13 Size: 575 Kb 
tweet!  Recreating SAS® Data Sets via SAS Code Generation
Rick Langston 
Pages: 7 Size: 158 Kb 
tweet!  Hands Free Data Transfer Using SAS
Teo Gamishev 
Pages: 5 Size: 28 Kb 
tweet!  Automatically Identify Formatting Problems with Numeric Variables
Wei Xu 
Pages: 3 Size: 116 Kb 
tweet!  You've Got ERROR
Ronald Palanca 
Keywords: Debugging batch programs
Pages: 6 Size: 96 Kb 
tweet!  Nobody Warned Me! Be Careful with SAS@: Invisible Errors
Ieva Brauksa 
Pages: 7 Size: 52 Kb 
tweet!  Storage Space and Processing Time Comparisons between Horizontal and Vertical Longitudinal Data
John Hennessey 
Pages: 10 Size: 242 Kb 
tweet!  Special Missing Values for Character Fields
John F. Ladds 
Pages: 8 Size: 300 Kb 
tweet!  A Better Characterization Routine
Patricia Hettinger 
Pages: 11 Size: 113 Kb 
Best Contributed Paper
tweet!  Creating a Microsoft Excel Report: A Comparison of the Different Techniques
Romain Miralles 
Keywords: sas excel libname dde proc export ods csv html msoffice excelxp
Pages: 12 Size: 88 Kb 
tweet!  Writing SAS® Programs with SAS and Microsoft Excel: Generate Batch SAS Programs Based on SAP Specifications
Laiju Zhang 
Pages: 7 Size: 608 Kb 
tweet!  The Little Engine That Could: Using LIBNAME Engine Options to Enhance Data Transfers Between SAS® and Microsoft Excel Files
William E. Benjamin Jr 
Keywords: Base SAS Excel LIBNAME transfer data
Pages: 10 Size: 1060 Kb 
tweet!  Create a Microsoft Excel Pivot Table Using DDE
Kevin Chung 
Pages: 10 Size: 330 Kb 
tweet!  Detail Forms with SAS® Stored Procedures
David P. Wells 
Pages: 4 Size: 294 Kb 
tweet!  SAS® Program Library: Benefits of Using the Confluence Wiki
Leonard Polak 
Pages: 12 Size: 663 Kb 
tweet!  Building Match Code Using SAS®
David Li 
Pages: 9 Size: 160 Kb 
tweet!  Efficient Merging: Creating Format Libraries to Save CPU Time
Tyler Benz 
Pages: 9 Size: 95 Kb 

    resource Additional resource: sasCommunity.org

tweet!  Developing User-Defined Functions in SAS®: A Summary and Comparison
Songfeng Wang  Jiajia Zhang 
Pages: 9 Size: 409 Kb 
tweet!  PROC COPY and PROC APPEND: A Developer's Secrets
Diane Olson 
Pages: 6 Size: 194 Kb 
tweet!  Custom Sequence of Rows and Columns in PROC TABULATE
Erik Tilanus 
Keywords: tabulate
Pages: 4 Size: 126 Kb 
tweet!  Using Multi-Label Formats to Create Subtotals in PROC TABULATE
Christina Morris 
Keywords: tabulate
Pages: 4 Size: 57 Kb 
tweet!  Force Missing Rows and Columns with CLASSDATA in PROC TABULATE
Peter Cerussi 
Keywords: tabulate
Pages: 5 Size: 35 Kb 
tweet!  Taking PROC SUMMARY a Step Beyond
Priya Suresh 
Keywords: Proc Summary Pattern Matching
Pages: 7 Size: 103 Kb 
tweet!  “Repo” Your Missing Data Using PROC REPORT
Ethan Miller 
Pages: 5 Size: 49 Kb 
tweet!  ORDER, ORDER PLEASE: SORTING DATA USING PROC REPORT
Lisa Fine 
Pages: 9 Size: 142 Kb 
tweet!  Ready, Set, Retain, and then Maybe Reset
Lisa Fine 
Pages: 11 Size: 165 Kb 
tweet!  To FREQ, Perchance to MEANS
Christopher J. Bost 
Pages: 10 Size: 239 Kb 
tweet!  The Power to Plot: Three Ways to Enhance SG Graphical Output
Xiangxiang Meng 
Pages: 12 Size: 617 Kb 
tweet!  Building Better Macros: Basic Parameter Checking for Avoiding "ID10T" Errors
Matthew T. Karafa 
Keywords: macro
Pages: 4 Size: 126 Kb 
tweet!  Conditional Processing without Macros
John F. Ladds 
Keywords: macro
Pages: 5 Size: 198 Kb 
tweet!  How to Drive Your SAS® Programs on Cruise Control
Teo Gamishev 
Pages: 6 Size: 483 Kb 
tweet!  COMMAND Your Session: SAS® Commands and Command-Style Macros
Nigel B. Neely 
Keywords: macro
Pages: 8 Size: 370 Kb 
tweet!  Create a Main Program to Run Multiple SAS® Programs Utilizing the %INCLUDE Statement
Lisa A. Mendez 
Pages: 4 Size: 152 Kb 
tweet!  How to Manage E-mails from SAS®
Teo Gamishev 
Pages: 5 Size: 29 Kb 
tweet!  E-Mailing from Your SAS® Program to Keep Everyone Informed
Bob Bolen 
Pages: 3 Size: 62 Kb 
tweet!  Five Ways to Speed Up Your Data Loading Using SAS/ACCESS® for Relational Databases
Douglas B. Liming 
Pages: 6 Size: 211 Kb 
tweet!  Who Do You Have? Where Are They?
William C. Murphy 
Pages: 6 Size: 73 Kb 
tweet!  Explicit SQL Pass-Through: Is It Still Useful?
Frank Capobianco 
Keywords: SQL Pass-Through SAS/ACCESS
Pages: 5 Size: 80 Kb 
tweet!  Assembling Data Sets for Use in Geographic Information Systems (GIS): Use of PROC TRANSPOSE in Macros
Saiful Momen 
Keywords: macro
Pages: 8 Size: 170 Kb 
tweet!  This SAS® Program Says to Google, ""What's Up Doc?""
Scott Davis 
Pages: 6 Size: 243 Kb 
tweet!  Creating Proportional Venn Diagrams Using Google and SAS®
Hillary Kruger 
Pages: 6 Size: 336 Kb 

    resource Additional resource: Take Out Video

tweet!  To Hash or Not To Hash! That Is the Question!! When it Comes to SQL!!!
Mustaq Ahmad 
Keywords: SQL
Pages: 12 Size: 279 Kb 
tweet!  Using Hash Tables to Obtain Matched Post-Hoc Control Populations
Jeffrey Reiss  Elayne Reiss 
Pages: 7 Size: 84 Kb 
tweet!  A Side of Hash for You to Dig Into
Shan A. Rasul 
Pages: 7 Size: 223 Kb 
tweet!  %DO Loop: A Simple Dynamic Programming Technique
Yunchao (Susan) Tian 
Pages: 3 Size: 182 Kb 
tweet!  Periodic Graphic Style Summary Report to Multi-sites in.pdf format
Julia Yang 
Pages: 10 Size: 250 Kb 
tweet!  SAS® Flirts with Java: PowerPoint Creation
Laiju Zhang 
Pages: 9 Size: 191 Kb 
tweet!  Creating a Table of Contents for Microsoft Word Using AutoFormat and Cascading Style Sheets
Fareeza Khurshed 
Pages: 7 Size: 49 Kb 
tweet!  When ""Anydate"" Doesn't Mean Any Date: A Macro Solution
Charlotte King  John Fleming 
Keywords: macro
Pages: 7 Size: 75 Kb 
tweet!  Using SAS® to Enter Variables in a DOS Window
Brandon Harvey  Robert D. Parker 
Pages: 7 Size: 84 Kb 
tweet!  Using CALL SYMPUT to Simplify
W. Jodi Auyuen 
Pages: 7 Size: 94 Kb 
tweet!  A SAS® Macro to Consolidate Data from Multiple Cards with Varying Time Validity but Belonging to a Single Account
Sohail Mohammad  Goutam Chakraborty 
Keywords: macro
Pages: 6 Size: 184 Kb 
tweet!  A Macro to Modify Attributes for All Character Variables in SAS® Data Sets
Suresh B. Kadaru 
Keywords: macro
Pages: 6 Size: 423 Kb 
tweet!  There's Nothing Odious about ODS
Aaron J. Rabushka 
Pages: 1 Size: 16 Kb 
tweet!  Plotting an Error and Line Plot and a Bar Graph in a Single Plot with Dual Y-Axis Scales
Sanjiv Ramalingam 
Pages: 6 Size: 195 Kb 
tweet!  SAS Software Development with the V-Model
Andrew Ratcliffe 
Pages: 9 Size: 84 Kb 
tweet!  Using SAS/GRAPH® Annotate to Create Customized Control Charts
Sailesh Vezzu 
Pages: 5 Size: 379 Kb 
tweet!  A Macro for Safely Merging Many Data Sets
Taylor Young 
Keywords: macro
Pages: 5 Size: 49 Kb 
tweet!  Expanding PROC EXPAND
Bruce Gilsen 
Pages: 4 Size: 26 Kb 
tweet!  Macros and Conventional Macro Variables: Effective Tools for Customizing Tabular Output in SAS® ODS
Perry Watts 
Keywords: Macro MVAR Dynamic Variables ODS Fonts
Pages: 6 Size: 110 Kb 

    resource Additional resource: sasCommunity.org

tweet!  The Trilogy on e-Mailing, Part 3: Handling e-Mail Attachments with SAS®
Erik Tilanus 
Pages: 5 Size: 165 Kb 
tweet!  Enough Really Good SAS® Tips to Fill a Book
Arthur S. Tabachneck 
Pages: 7 Size: 369 Kb 

SAS Global Forum 2010   April 11-14, 2010 - Seattle, Washington

Coders' Corner

tweet!  Automagically Copying and Pasting Variable Names
Arthur S. Tabachneck  Randy Herbison  Andrew W. Clapson  John King  Roger J. DeAngelis  Tom Abernathy 
Pages: 7 Size: 155 Kb 
tweet!  So Many Variables, Too Many Labels: Moving Labels from One Variable to Another
John F. Ladds 
Pages: 11 Size: 184 Kb 
tweet!  Automatically Dropping Variables with Only Missing Values
Selvaratnam Sridharma 
Pages: 6 Size: 57 Kb 
tweet!  Bridging the Gap between the Google Analytics API and SAS®
William G. Roehl 
Pages: 13 Size: 91 Kb 
tweet!  Driving Distances and Times Using SAS® and Google Maps
Mike Zdeb 
Pages: 8 Size: 424 Kb 
tweet!  Get to Your Points: Using SAS® to Build Google Maps
Ted Conway 
Pages: 12 Size: 2416 Kb 
tweet!  Your Friendly Neighborhood Webcrawler: A Guide to Crawling the Web with SAS®
Jake Bartlett  Alicia Bieringer  James Cox 
Keywords: internet
Pages: 6 Size: 147 Kb 
tweet!  SAS® One-liners
Stephen Hunt 
Pages: 6 Size: 273 Kb 
tweet!  Reverse-Engineer a Reference Curve: Capturing Tabular Data from Graphical Output
Brian Fairfield-Carter 
Pages: 6 Size: 365 Kb 
tweet!  Two Practical Approaches to Add Special Characters to Axis Labels in SAS/GRAPH® Output in RTF
Amos Shu 
Pages: 4 Size: 242 Kb 
Honorable Mention
tweet!  Creating High-Quality Scatter Plots: An Old Story Told by the New SGSCATTER Procedure
Xiangxiang Meng 
Pages: 9 Size: 417 Kb 
tweet!  Visualizing Key Performance Indicators Using the GKPI Procedure
Brian Varney 
Pages: 9 Size: 226 Kb 
tweet!  Short Course for the Korn Shell "find" Command and Piping the Information into SAS®
John Gober 
Pages: 6 Size: 58 Kb 
tweet!  SMTP Email Access Method: Hints, Tips, and Tricks
Chuck Hunley 
Pages: 8 Size: 351 Kb 
tweet!  Using SAS® to Perform Individual Matching in Design of Case-Control Studies
Greg Grandits  Jacqueline Neuhaus 
Pages: 9 Size: 45 Kb 
tweet!  Challenges in Genomic Data Processing I: Multiple Small Files
Derek Morgan  Bernard O. Omolo 
Pages: 6 Size: 66 Kb 
tweet!  Challenges in Processing Genomic Data II - One BIG File
Derek Morgan 
Pages: 5 Size: 63 Kb 
tweet!  Simple Rules to Remember When Working with Indexes
Kirk P. Lafler 
Keywords: WHERE clause indexes performance
Pages: 5 Size: 321 Kb 
tweet!  Space Management for Text Variables
William C. Murphy 
Pages: 5 Size: 58 Kb 
tweet!  Taming the Herd: Wrangling Unruly Text Files in SAS®
Taylor Young 
Pages: 9 Size: 67 Kb 
tweet!  Using a Few Key Elements of SAS® DATA Step Code and a Couple of Procedures to Optimize the Observation Length of a Data Set
Philip A. Wright 
Pages: 9 Size: 89 Kb 
tweet!  When the List Grows Too Long: A Strategy to Use Freeform User Input in Your SAS® Stored Process Web Applications
Jeffery A. Fallon 
Keywords: internet
Pages: 4 Size: 47 Kb 
tweet!  Using the Descriptor Portion of a SAS® Data File
Dragos D. Capan 
Pages: 6 Size: 177 Kb 
tweet!  Why Aren't You Using MEMLIB?
Erik H. Dilts 
Pages: 3 Size: 38 Kb 
tweet!  Getting Your Metadata Using PROC METADATA
Edwin J. van Stein 
Pages: 7 Size: 88 Kb 

    resource Additional resource: sasCommunity.org

tweet!  Next-Generation DATA _NULL_ Report Writing Using ODS OO Features: A Powerful Tool to Create Custom Tables
Alice Li  Jacob Jen-Hao Cheng 
Pages: 12 Size: 129 Kb 
tweet!  I've Got the Styles You Need
Bob Hull 
Pages: 4 Size: 40 Kb 
tweet!  Generating Complex Reports with DDE and VBA
Chienchung Chen 
Pages: 7 Size: 264 Kb 
tweet!  Automating Report Dates and Formats Using SAS®9 Software
John Simeoni  Dikki Coy 
Pages: 11 Size: 83 Kb 
tweet!  Using SAS® Software and Visual Basic for Application to Dynamically Manipulate SAS List Files
Zemin Zeng  Mei Li 
Pages: 9 Size: 74 Kb 
tweet!  Evolution of Formatting "On the Fly"
Allen Blackburn  Mikhail Gruzdev 
Pages: 8 Size: 57 Kb 
tweet!  Preventive Reporting Is Better with a Multi-label Format
Sunil Gupta  Deepak G. Asrani 
Pages: 7 Size: 254 Kb 
tweet!  Data Simulation for Piloting Clinical Trials Display Programs
Brandon L. Welch  Rita Slater 
Keywords: clinical
Pages: 9 Size: 252 Kb 
tweet!  Using Data Set Labels and Format Descriptions to Simplify Application Debugging
Robert L. Russell 
Pages: 9 Size: 120 Kb 
tweet!  Automated Data Cleaning Linking Data Manager to Study Coordinator: Error Finding by Variable and Error Fixing by Subject
Christine T. Roman  Emma K. Benn  Dale C. Hesdorffer  Anthony Marmarou  Shlomo Shinnar 
Pages: 5 Size: 53 Kb 
tweet!  Using the External Filename to Create File Date Variables
Peter Cerussi 
Pages: 11 Size: 89 Kb 
Best Contributed Paper
tweet!  SAS® Code Validation: L.E.T.O. Method
Aaron J. Augustine 
Pages: 12 Size: 140 Kb 
tweet!  Zip and E-mail Files Using SAS® to Reduce Errors and MAKE Documentation Easy
Ryan E. Whitworth 
Pages: 4 Size: 160 Kb 
tweet!  Tabular Reporting Data Standard
Frederick A. Cieri 
Pages: 9 Size: 75 Kb 

    resource Additional resource: sasCommunity.org

tweet!  Data in Your Inbox? Use It!
Douglas B. Liming 
Pages: 7 Size: 394 Kb 
tweet!  New Dogs and Old Tricks, Part II: Using the SELECT Statement and FLAGS to Streamline Your Code
Stanley Fogleman 
Pages: 4 Size: 54 Kb 
tweet!  Where Does This WHERE Statement Go?
Scott Davis 
Pages: 4 Size: 142 Kb 
tweet!  Some Examples of Simple Perl Regular Expressions in SAS®9
Selvaratnam Sridharma 
Pages: 5 Size: 55 Kb 
tweet!  Make Your SAS® Code Environmentally Aware
Clarke Thacher 
Pages: 7 Size: 451 Kb 
tweet!  Documenting SAS® Macros on a Server
Sumner Williams 
Keywords: macro
Pages: 3 Size: 97 Kb 
tweet!  A Macro to Create a Batch Submit SAS Program
Helen Sun  Cindy Wong 
Keywords: macro
Pages: 5 Size: 299 Kb 
tweet!  Stupid Human Tricks with PROC EXPAND
David Cassell 
Pages: 6 Size: 143 Kb 
tweet!  Building a Decision Tree from Decision Stumps
Murphy Choy  Peter L. Flom 
Pages: 7 Size: 142 Kb 
tweet!  A Program to Automatically Compute Agreement Statistics for an Asymmetric Table
Ying Feng  Vincent Weng 
Pages: 6 Size: 59 Kb 
tweet!  Automatically Run Fisher's Exact Test When the Chi-square Test Might Not Be Valid
Wei Xu 
Pages: 4 Size: 46 Kb 
tweet!  Efficient Statistical Programming? Reducing SAS® Run Time with WHERE Setup
Keiko I. Powers 
Pages: 4 Size: 32 Kb 
tweet!  SAS® State of Mind: A Guide to Learning SAS for the Stata User
Sarah J. Beck 
Pages: 9 Size: 236 Kb 
tweet!  Using PROC CONTENTS Output to Perform Quality Control Checks on SDTM Data Sets
Jennifer M. Srivastava 
Pages: 6 Size: 53 Kb 
tweet!  Yes, PROC SQL Is Great, But I Love DATA Step Programming: What's a SAS® User to Do?
Mira Shapiro 
Keywords: SQL
Pages: 4 Size: 78 Kb 
tweet!  Using the SQL Procedure to Summarize and Transpose Data
Kevin Chung 
Keywords: SQL
Pages: 8 Size: 86 Kb 
tweet!  Transposing Data Using the IDGROUP Option in PROC SUMMARY
John King  Mike Zdeb 
Pages: 6 Size: 33 Kb 
tweet!  Look Before You Leap – A Technique to Simulate a Look-Ahead Function
Leonard E. Landry 
Pages: 5 Size: 60 Kb 
tweet!  Finding Your Subjects in a Haystack: The Many Ways of Implementing Table Look-Ups
Olga Galin  Alla Sapozhnikova 
Pages: 4 Size: 367 Kb 
tweet!  Using SAS® to Report Data in XML Format
Qin Wang 
Keywords: xml
Pages: 7 Size: 127 Kb 
Honorable Mention
tweet!  A SAS® Enterprise Guide® 4.2 and SAS/CONNECT® Mainframe Project That Makes the Mainframe Behave Like a Modern Computer
John Hennessey 
Keywords: enterprise guide
Pages: 10 Size: 160 Kb 
tweet!  Challenge! Reading a Mainframe Hexadecimal-Delimited Flat File in Which Each Line Has a Different Layout
Anjan Matlapudi 
Pages: 7 Size: 58 Kb 
tweet!  Data Masking with Classical Ciphers
Murphy Choy 
Pages: 9 Size: 139 Kb 
tweet!  Faster Results by Multi-threading DATA Steps
Ian J. Ghent 
Pages: 7 Size: 192 Kb 
tweet!  Getting By with a Little Help from My Regular Expressions
Scott Davis 
Pages: 5 Size: 136 Kb 

SAS Global Forum 2009   March 22-25, 2009 - National Harbor, Maryland

Coders' Corner

tweet!  Creating SAS® Data Sets from HTML Table Definitions
Rick Langston 
Keywords: html
Pages: 9 Size: 36 Kb 
tweet!  Variable Names Don't Begin with the Same Characters? No Problem: How to Create Variable List without Copying, Pasting or Excel Intervention
Xu Zeng 
Pages: 8 Size: 146 Kb 
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: 113 Kb 
tweet!  LAG: The Very Powerful and Easily Misused SAS® Function
Yunchao (Susan) Tian 
Pages: 5 Size: 87 Kb 
tweet!  Using IN:( ) to code Character Comparisons with Criteria Having Different Lengths
Paul Grant 
Pages: 4 Size: 48 Kb 
tweet!  The Pros and Cons of PROC DOCUMENT
Philip R. Holland 
Pages: 2 Size: 97 Kb 
tweet!  Selecting a Stratified Sample with PROC SURVEYSELECT
Diana Suhr 
Pages: 6 Size: 40 Kb 
tweet!  PROC REPORT: Titling It Right, with Footnotes to Boot
William C. Murphy 
Pages: 5 Size: 65 Kb 
tweet!  Learn the Basics of PROC TRANSPOSE
Douglas Zirbel 
Pages: 8 Size: 65 Kb 
tweet!  Let SQL Write SQL Scripts for You – Counts Report
Christine Teng 
Keywords: SQL
Pages: 5 Size: 81 Kb 
tweet!  A Propaedeutics for PROC SQL Joins
Lisa A. Mendez  Toby Dunn 
Keywords: SQL
Pages: 9 Size: 109 Kb 
tweet!  Exploring the Undocumented PROC SQL _METHOD Option
Kirk P. Lafler 
Keywords: SQL
Pages: 2 Size: 38 Kb 
tweet!  PROC FORMAT, A Speedy Alternative to Sort Sort Merge
Jenine Milum 
Pages: 5 Size: 54 Kb 
tweet!  Effectiveness and Cost of SAS® Compression
Hitesh Sharma 
Pages: 9 Size: 329 Kb 
tweet!  %LibDoc: A Library Documentation Macro
Richard Koopmann Jr. 
Keywords: macro
Pages: 6 Size: 37 Kb 
tweet!  Another Way to Make Use of Variable Labels
Stephanie R. Thompson 
Pages: 2 Size: 32 Kb 
tweet!  Backup from the Startup: Keep a Constant Backup of Your SAS® Logs and Listing Output from SAS Display Manager in Microsoft Windows
Paul D. McDonald 
Pages: 5 Size: 82 Kb 
tweet!  “Excel”lent SAS® Formulas: The Creation and Export of Excel Formulas Using SAS
Collin Elliot  Eli Morris 
Pages: 11 Size: 162 Kb 
tweet!  SCL Is Gone: How Do I Get Variables from My Users into SAS® Enterprise Guide®?
Patricia Hettinger 
Keywords: enterprise guide
Pages: 11 Size: 95 Kb 
tweet!  Choosing the Right Technique to Merge Large Data Sets Efficiently
Qingfeng Liang 
Pages: 9 Size: 48 Kb 
tweet!  Let Me Look At It! Graphic Presentation of Any Numeric Variable.
Anastasiya M. Osborne 
Pages: 12 Size: 742 Kb 
tweet!  SAS® Abbreviations Are Your Friends; Use a Template Method to Code!
Elizabeth Ceranowski 
Pages: 11 Size: 621 Kb 
tweet!  The Perils of End-of-File Processing When Subsetting Data
Leonard Landry 
Pages: 7 Size: 66 Kb 
tweet!  Renaming in Batches
Vincent Weng  Ying Feng 
Pages: 7 Size: 55 Kb 
tweet!  Which SASAUTOS Macros Are Available to My SAS® Session?
Harry Droogendyk 
Keywords: macro
Pages: 15 Size: 77 Kb 
tweet!  Creating Code Templates in the SAS Enhanced Editor using Abbreviations and User Defined Keywords
Paul Grant 
Pages: 6 Size: 135 Kb 
tweet!  Time Travel: How to Easily Create, Loop Through and Manipulate Data with Names Containing YYYYMM
Jingjing Shan 
Pages: 14 Size: 152 Kb 
Best Contributed Paper
tweet!  Playing Favorites: How to Manage Date Conflicts When Some Date Ranges Are Preferred Over Others
Eric C. Wong 
Pages: 11 Size: 97 Kb 
tweet!  Keeping Up to Date: Using Build Tools with SAS®
Robert A. Burnham 
Pages: 4 Size: 30 Kb 
tweet!  One-Step Change from Baseline Calculations
Nancy Brucken 
Keywords: DOW DATA step change from baseline
Pages: 4 Size: 38 Kb 
tweet!  Proper Housekeeping: Developing the Perfect “Maid” to Clean Your SAS® Environment
Chuck Bininger 
Pages: 4 Size: 25 Kb 
tweet!  Dynamically Allocating Exported Data Sets by the Combination of Pipes and X Statement
Xin Wei 
Pages: 4 Size: 224 Kb 
tweet!  Implementing Stack and Queue Data Structures with SAS® Hash Objects
Larry Hoyle 
Pages: 10 Size: 90 Kb 
tweet!  Mission Possible: Putting a Table and Multiple Graphs on a Single-Page.pdf with ODS and Basic GOPTIONS
Jennifer S. Harper 
Pages: 7 Size: 87 Kb 
tweet!  Could You Remind Me? Creating Calendar Events from SAS®
Clarke Thacher 
Pages: 7 Size: 131 Kb 
tweet!  PROC GEOCODE: Creating Map Locations from Your Data
Darrell Massengill  Ed Odom 
Pages: 13 Size: 235 Kb 

SAS Global Forum 2008   March 16-19, 2008 - San Antonio, Texas

Coders' Corner

tweet!  Easy as Pie Charts (Any Way You Slice ‘Em)
Jonah Turner 
Keywords: SAS/GRAPH
Pages: 12 Size: 262 Kb 
tweet!  Using Excel XP to Display SDTM Metadata and More
Christine Teng  Shaoan Yu 
Keywords: ExcelXP Tagset SAS Dictionary PROC SQL
Pages: 8 Size: 182 Kb 
tweet!  How To Generate 2-, 3-, and 4-Way Venn Diagrams with Drill-Down Functionality within Four Minutes!
Kriss Harris 
Keywords: Venn diagram venn drill down drill
Pages: 10 Size: 236 Kb 
tweet!  Creating Flowcharts Using the Annotate Facility
Priya Saradha  Gurubaran Veeravel 
Keywords: Flowchart Annotate GRAPH
Pages: 6 Size: 104 Kb 
tweet!  Talkin' 'Bout Code Generation: Getting Animated with SAS® and Excel
Ted Conway 
Keywords: excel charts animation vista
Pages: 10 Size: 606 Kb 
tweet!  Mapping without GMAP: An Innovative Use of the SAS/GRAPH® Annotate Facility
Pete Lund 
Pages: 11 Size: 425 Kb 
tweet!  Standard Graph Templates
Philip R. Holland 
Pages: 8 Size: 195 Kb 
Best Contributed Paper
tweet!  A Step-by-Step Introduction to PROC REPORT
David R. Lewandowski 
Pages: 6 Size: 44 Kb 
tweet!  The Look: Conforms to Section 508, Looks Like PROC TABULATE
Blake Sanders  Mikhail Gruzdev 
Keywords: tabulate
Pages: 10 Size: 55 Kb 
tweet!  Many-to-Many Merges in the DATA Step
Edward Heaton 
Keywords: HASH object MERGE many-to-many DATA step
Pages: 9 Size: 302 Kb 
tweet!  Tools of Miscalculation: Managing Missing Values with SAS®
William Murphy 
Keywords: Database management Database cleaning CATS DATA step N function arrays
Pages: 4 Size: 57 Kb 
tweet!  Guidelines for Organizing SAS® Project Files
Nathaniel Derby 
Keywords: organization project files
Pages: 4 Size: 240 Kb 
tweet!  Existential Moments in Database Programming: SAS® PROC SQL EXISTS and NOT EXISTS Quantifiers, and More
Sigurd Hermansen  Stanley E. Legum 
Keywords: UPDATE query predicate logic logical conditions SQL
Pages: 6 Size: 75 Kb 
tweet!  When PROC APPEND May Make More Sense Than the DATA Step
David Carr 
Keywords: SAS PROC APPEND DATA STEP SET Statement SAS Macro
Pages: 6 Size: 165 Kb 
tweet!  ODS and Output Data Sets: What You Need to Know
Myra Oltsik 
Pages: 13 Size: 289 Kb 
tweet!  Any Way You Want It: Getting the Right Types of Observations out of PROC SUMMARY or MEANS
Christianna Williams 
Pages: 8 Size: 81 Kb 
tweet!  Labor-Saving SQL Constructs
Brian Fairfield-Carter  David Carr 
Keywords: SQL
Pages: 10 Size: 231 Kb 
tweet!  It's a Bird, It's a Plane, It's SQL Transpose!
Ted Conway 
Keywords: sql transpose database
Pages: 5 Size: 489 Kb 
tweet!  Dynamic Decimal Precision and Alignment in Clinical Trial Laboratory Summary Tables and Patient Data Listings
Stephen Hunt  Brian Fairfield-Carter 
Keywords: Precision Alignment Laboratory Results clinical
Pages: 8 Size: 128 Kb 
tweet!  Creating Journal-Style Tables in an Easy Way (with PROC TABULATE, PROC TEMPLATE, PROC FORMAT, and ODS RTF)
Janet M. Grubber  Maren Olsen  Hayden Bosworth 
Keywords: tabulate
Pages: 14 Size: 130 Kb 
tweet!  Check Out These Pipes: Using Microsoft Windows Commands from SAS®
Brian Varney 
Pages: 8 Size: 37 Kb 
tweet!  Easy Rolling Statistics with PROC EXPAND
Premal P. Vora 
Pages: 6 Size: 53 Kb 
tweet!  Concatenating Inputs Using SAS® on the PC
Jim Noe 
Keywords: Base SAS Concatenating Input Files
Pages: 2 Size: 63 Kb 
tweet!  Using Table Lookup Techniques Efficiently
Linda Jolley  Jane Stroupe 
Keywords: array 'table lookups' 'hash objects' format join merge indexes
Pages: 11 Size: 47 Kb 
tweet!  Poor Man's Parallel Processing, Using DATA-Step Views
Erik Tilanus 
Keywords: Performance
Pages: 3 Size: 29 Kb 
tweet!  Exploring the Undocumented PROC SQL _METHOD Option
Kirk P. Lafler 
Keywords: PROC SQL SQL _METHOD query tuning
Pages: 2 Size: 40 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 E. Benjamin Jr 
Keywords: _INFILE_ SHAREBUFFERS Functions Input Output Text
Pages: 10 Size: 711 Kb 
tweet!  SAS® XML Mapper to the Rescue
Carol Martell 
Keywords: XML
Pages: 8 Size: 226 Kb 
tweet!  How to Avoid Overwriting Work Data Sets and Work Formats – An Essential Macro Design Topic
Zizhong (James) Fan 
Keywords: Macro Overwrite Data Set
Pages: 7 Size: 241 Kb 
tweet!  Creating a Stored Macro Facility in Ten Minutes
Erik S. Larsen 
Keywords: macro stored compiled production SCMF
Pages: 3 Size: 37 Kb 
tweet!  Using a SAS® Table to Drive Any Macro
Michael D. Whitaker 
Keywords: Macro Automation
Pages: 12 Size: 94 Kb 
tweet!  The Application of a General List-Processing Macro in Combination Therapy
Zhongwen Huang  William Layton 
Keywords: List macro General list processing macro Combination therapy
Pages: 5 Size: 29 Kb 
tweet!  A Macro Function to Parse Any Variable Lists
Jimmy Zou 
Keywords: macro function parse variable lists Pearl regular expressions
Pages: 9 Size: 75 Kb 
tweet!  Using the SAS® DATA Step and PROC SQL to Create Macro Arrays
Stuart Long  Edward Heaton 
Keywords: Macro Array SQL
Pages: 11 Size: 69 Kb 
tweet!  Simple %str(ER)ROR Checking in Macros
Magnus Mengelbier 
Keywords: macro
Pages: 16 Size: 77 Kb 
tweet!  %HASHMERGE - A Macro to Hash When It Can, Merge When It Can't
Gregg P. Snell 
Keywords: macro
Pages: 12 Size: 192 Kb 
tweet!  Six Cool Things You Can Do in Display Manager
Jenine Milum 
Keywords: graph ods
Pages: 7 Size: 307 Kb 
tweet!  An Introduction to SAS/CONNECT®
James Stokes 
Pages: 4 Size: 38 Kb 
Best Contributed Paper
tweet!  "I Shall RETURN" – Key Feedback in SAS/AF®
Greg McLean 
Keywords: af
Pages: 8 Size: 301 Kb 
tweet!  Using SAS® Enterprise Guide® and SAS/CONNECT® to Make the Mainframe Behave Like a Modern Computer
John Hennessey 
Keywords: enterprise guide
Pages: 6 Size: 39 Kb 
tweet!  Migrating Information in the Amisys Data-Warehouse: Current to Advanced
Anthony E. DeGance 
Keywords: warehouse
Pages: 10 Size: 106 Kb 
tweet!  Stupid Human Tricks with PROC SURVEYSELECT
David Cassell 
Keywords: append model validation
Pages: 5 Size: 26 Kb 
tweet!  Experiences in Testing Host-Dependent Software in a Portable Fashion
Rick Langston 
Keywords: MODULE testing
Pages: 7 Size: 39 Kb 
tweet!  The Perfect Baby Name: One Dad's Quest Using SAS®
Chris Hemedinger 
Keywords: enterprise guide query social security sql
Pages: 7 Size: 183 Kb 

SAS Global Forum 2007   April 16-19, 2007 - Orlando, Florida

Coders' Corner

tweet!  How to Optimize Existing SAS® Programs Generating Standard Reports
Teo Gamishev 
Keywords: code optimization standard reports optimization
Pages: 7 Size: 46 Kb 
Best Contributed Paper
tweet!  In the Compute Block: Issues Associated with Using and Naming Variables
Art Carpenter 
Keywords: PROC REPORT Compute Block Computed variables Composite names Report items
Pages: 10 Size: 68 Kb 
tweet!  Affordable SAS® Tips
Teo Gamishev 
Keywords: affordable SAS tips custom time periods control the flow of the program custom FORMATS custom INFORMATS
Pages: 5 Size: 37 Kb 
tweet!  Handling Large Stream Files with the @'string' Feature
Rick Langston 
Pages: 4 Size: 26 Kb 
tweet!  Journeyman's Tools: Data Review Macro FREQALL - Using PROC SQL List Processing with Dictionary.Columns to Eliminate Macro DO Loops
Ronald J. Fehd 
Keywords: data review dynamic programming list processing do loop macro SQL
Pages: 10 Size: 137 Kb    Download the LATEX Beamer presentationdownload (.pdf, 129 Kb)
tweet!  Calculating Duration via the Lagged Values of Variables
Pon Su 
Pages: 5 Size: 68 Kb 
tweet!  Using SAS® Macros to Produce Tables for Publication from SAS-Callable SUDAAN
Roger P. Pickering 
Keywords: SAS-Callable SUDAAN SAS Macros Tables
Pages: 10 Size: 82 Kb 
tweet!  Quick Record Lookup without an Index
Paul A. Choate 
Pages: 4 Size: 32 Kb 
tweet!  A SAS® Macro for Automating the Change-In-Estimate Strategy for Assessing Confounding
Julius Atashili  Myduc L. Ta 
Keywords: macro
Pages: 10 Size: 43 Kb 
tweet!  Parameter-Gathering Techniques for Data-Driven Programming
Renato G. Villacorte 
Keywords: ODS OUTPUT SYSEXEC OUTPUT=
Pages: 5 Size: 34 Kb 
tweet!  Hurry! Hurry! Step Right Up! The Magical Compound WHERE Clause Can Eliminate DATA Steps, Reduce Processing Steps, Speed Up Turnaround, and Mystify Your Friends
William E. Benjamin Jr 
Keywords: Where= Dataset Options Procedure Optimize Large Files
Pages: 6 Size: 93 Kb 
tweet!  Hanging On by a STRING? Using Functions to Untie Text Strings
Jeanina Worden 
Keywords: STRING SCAN COMPRESS TRANSLATE
Pages: 7 Size: 58 Kb 
tweet!  A Generic Method of Parallel Processing in Base SAS® 8 and 9
Sassoon Kosian 
Keywords: parallel processing multi-threading shell script multiple CPUs
Pages: 8 Size: 121 Kb 
tweet!  Back Up with Each Submit and Save Your Sanity!
Suzanne M. Humphreys 
Keywords: back up files pipe device filename statement dos commands dm commands
Pages: 5 Size: 32 Kb 
tweet!  Empowering Your SAS® Business Intelligence End Users via a SAS® Stored Process
David Pope 
Keywords: AMO WRS Enterprise Guide
Pages: 8 Size: 268 Kb 
tweet!  Hashing Performance Time with Hash Tables
Elena Muriel 
Pages: 10 Size: 642 Kb 
tweet!  An Approach for a Scalable, Platform-Independent, Automated Solution Using SAS® IOM
Srinivas G. Bhat  Jim Fang  Vijay Venugopal 
Keywords: SAS Call Execute Procedure SAS Macro SAS Connect Excel VBA
Pages: 8 Size: 95 Kb 
tweet!  Graphical Representation of the Mean Measurement over Time
Wei Cheng 
Keywords: Statistical Graphs ODS Graphics Mean Over Time Annotate SAS/GRAPH Plot
Pages: 9 Size: 202 Kb 
tweet!  Dear Miss SASAnswers: A Guide to SAS® Efficiency
Linda T. Jolley  Jane S. Stroupe 
Pages: 8 Size: 42 Kb 
tweet!  Using Arrays to Calculate Medication Utilization
R. Scott Leslie 
Keywords: array
Pages: 5 Size: 109 Kb 
tweet!  Using Dynamic Data Exchange and Table-Driven Programming to Manage Microsoft Excel Files
Xiaoming Liang 
Keywords: dynamic data exchange table driven programming excel manager
Pages: 10 Size: 226 Kb 
tweet!  Group Headers by Template with Optional Columns
Hsiwei Yu  Dong-Min Shen 
Keywords: template group column header
Pages: 3 Size: 33 Kb 
tweet!  Turning the Data Around: PROC TRANSPOSE and Alternative Approaches
Erik W. Tilanus 
Keywords: Rotate data
Pages: 9 Size: 45 Kb 
tweet!  Creating a Local Library
Edward Heaton 
Keywords: %localLib() dCreate() fileExist() pathName() dequote() notDigit()
Pages: 10 Size: 210 Kb 
tweet!  Categorizing Drug Data in a Complex Survey with SAS® PROC FORMAT, INPUT, and PUT Functions
Henry H. Xia 
Pages: 8 Size: 127 Kb 
tweet!  SAS® Tools for Program Automation
Richard F. Pless 
Keywords: Automatic Macro Variables Environmental Variables SAS Help Views
Pages: 12 Size: 59 Kb 
Best Contributed Paper
tweet!  Changing Data Set Variables into Macro Variables
William C. Murphy 
Keywords: Macro CALL SET %SYSFUNC CALL SYMPUT DATA _NULL_ PROC SQL
Pages: 4 Size: 63 Kb 
tweet!  Easy SAS® Session Customization
Peter Crawford 
Pages: 6 Size: 256 Kb 
tweet!  Names, Names, Names - Make Me a List
Ian Whitlock 
Keywords: macro lists utilities toolmaking
Pages: 10 Size: 119 Kb 
tweet!  SAS/CONNECT® to Mainframes and Servers in SAS® Enterprise Guide® 4 Using SAS Code
John C. Hennessey 
Keywords: enterprise guide
Pages: 4 Size: 32 Kb 
tweet!  FUNCTIONSIZE: Process Your External Files
Linda L. Libeg 
Keywords: DOPEN DNUM DREAD DCLOSE
Pages: 4 Size: 56 Kb 
tweet!  Creating Microsoft Excel Pivot Tables from SAS® - (Part 2)
John DeMeo 
Keywords: Excel SAS8.2
Pages: 8 Size: 530 Kb 
tweet!  Seven Steps to Regulatory Publication Style with PROC REPORT
Dennis Gianneschi 
Keywords: proc report regulatory submission RTF WORD RTF post process
Pages: 6 Size: 60 Kb 
tweet!  Saving Trees with Output Delivery System (ODS)
Angelina D. Tan  Nancy Diehl  Jayawant N. Mandrekar 
Keywords: ODS SAS® macro SAS®/Base SAS®/STAT REPORT
Pages: 9 Size: 112 Kb 
tweet!  Data on Demand with SAS® Enterprise Guide®: A Cheap and Easy Approach to Real-Time Database Access
Richard F. Pless 
Keywords: ODBC Enterprise Guide SQL Server
Pages: 11 Size: 1082 Kb 
tweet!  Useful SAS® Macros and Routines
Flora Rodriguez Montano  Miguel Zamudio Montano 
Keywords: SAS MACRO EXCEL
Pages: 8 Size: 187 Kb 
tweet!  Excelling with SAS®
Faron Kincheloe 
Pages: 3 Size: 59 Kb 
tweet!  Automatically Incorporating Repeated Changes in SAS® Programming Codes in Clinical Trial Reporting
James David Barfield  John G. Moore  Jyoti N. Rayamajhi 
Keywords: clinical
Pages: 4 Size: 43 Kb 
tweet!  Simple Rules to Remember When Working with Indexes
Kirk P. Lafler 
Keywords: WHERE-clause index
Pages: 5 Size: 370 Kb 
tweet!  Customizing Your SAS® Initialization
George J. Hurley 
Pages: 9 Size: 520 Kb 
tweet!  Using Invisible Characters in SAS® Programming - Hidden Dragons, Episode II
Shi-Tao Yeh 
Keywords: Alt255 Alt-255 Invisible Character text aligning text formatting Java hint text box SAS output
Pages: 9 Size: 244 Kb 
tweet!  March Sanity - A SAS® Application for Administering an NCAA Tournament Pool
Michael P. Walkup  Timothy E. Craven  Gregory B. Russell 
Keywords: Import Export CSV Macros Excel gaming
Pages: 7 Size: 198 Kb 
tweet!  SAS® Macro Version Control
Jim Groeneveld 
Keywords: SAS macro version control
Pages: 4 Size: 38 Kb 
tweet!  DO Which? Loop, UNTIL, or WHILE? A Review of DATA Step and Macro Algorithms
Ronald J. Fehd 
Keywords: loop until while repeat macro
Pages: 8 Size: 119 Kb 
tweet!  Creating a Format from Raw Data or a SAS® Data Set
Wendi L. Wright 
Keywords: FORMAT CNTLIN CNTLOUT
Pages: 7 Size: 491 Kb 
tweet!  Checking for Duplicates
Wendi L. Wright 
Keywords: SORT NODUP NODUPKEY
Pages: 5 Size: 495 Kb 
tweet!  Using the DATASETS Procedure - Part II
David Fickbohm 
Pages: 10 Size: 106 Kb 
tweet!  PROC SQL - The Dark Side of SAS®?
Kirsty R. Lauderdale 
Keywords: SET MERGE IF OUTER JOIN FULL JOIN INNER JOIN RIGHT JOIN LEFT JOIN CASE and INTO SQL
Pages: 5 Size: 200 Kb 
tweet!  Calculating Statistics Using PROC MEANS versus PROC SQL
Jyotheeswara N. Yellanki 
Keywords: FREQ VAR WAYS WEIGHT GROUP BY ORDER BY DISTINCT SQL
Pages: 8 Size: 130 Kb 

SUGI 31   March 26-29, 2006 - San Francisco, California

Coders' Corner

tweet!  De-Mystifying the SAS® LIBNAME Engine in Microsoft Excel: A Practical Guide
Paul A. Choate  Carol A. Martell 
Keywords: Excel Libname Engine Table Update Workbook Export Import
Pages: 8 Size: 213 Kb 
tweet!  MISSING! - Understanding and Making the Most of Missing Data
Suzanne M. Humphreys 
Keywords: survey data questionnaire data MODIFY
Pages: 9 Size: 41 Kb 
Honorable Mention
tweet!  Literally Minded - The Use of SAS® Literals and Why They Are Still Relevant!
Stanley E. Fogleman 
Keywords: BASE data step
Pages: 4 Size: 40 Kb 
tweet!  Improve Your Dating: The INTNX Function Alignment Value SAMEDAY
Bruce F. Gilsen 
Keywords: (1) SAS date value (2) Date (3) Date alignment (4) Date value SAS
Pages: 2 Size: 27 Kb 
Best Contributed Paper
tweet!  Squeezing Information out of Data
William C. Murphy 
Keywords: COMPRESS DATA Step efficiency data cleaning VIEWTABLE
Pages: 4 Size: 64 Kb 
tweet!  Gracefully Terminate a DATA Step If the Input Data File Is Not Available
Erik W. Tilanus 
Keywords: Reading external data
Pages: 4 Size: 49 Kb 
tweet!  The SORT Procedure: Beyond the Basics
Britta KelseyBassett 
Keywords: noduprecs nodupkey drop keep rename where firstobs obs descending
Pages: 6 Size: 122 Kb 
tweet!  Project Duplication: Eradication Techniques
Monal Kohli 
Pages: 9 Size: 264 Kb 
tweet!  Using the DATASETS Procedure
David Fickbohm 
Keywords: proc datasets
Pages: 5 Size: 42 Kb 
tweet!  Documentation-Driven Techniques for Building SAS® Data Warehouses
Leonid Batkhan 
Keywords: code macro warehouse
Pages: 10 Size: 79 Kb 
tweet!  Make the Invisible Visible: A Case Study of Importing Multiple Worksheet Files By Using the SAS®9 LIBNAME Engine in Microsoft Excel
Zizhong Fan 
Keywords: SAS/ACCESS Excel
Pages: 7 Size: 343 Kb 
tweet!  Sur La Table: Creating Microsoft Excel PivotTables in a Jiffy from SAS® Data
Ted Conway 
Keywords: macro excel vbs pivot
Pages: 6 Size: 529 Kb 
tweet!  Xamining the X Statement (and Some Other Xciting Code)
George J. Hurley 
Keywords: dm noxwait host command
Pages: 6 Size: 209 Kb 
tweet!  SAS/AF® - Building a Tree View Hierarchy with Drag and Drop
Scott Jackson  Darrell Massengill 
Keywords: SAS/AF TreeView Drag and Drop SCL
Pages: 7 Size: 83 Kb 
tweet!  The Big Introduction from the Smallest Macro
Peter Crawford 
Keywords: macros KISS introduction
Pages: 3 Size: 107 Kb 
tweet!  SAS® Macro Dynamics - From Simple Basics to Powerful Invocations
Rick Andrews 
Keywords: beginner advanvced interative macro
Pages: 6 Size: 58 Kb 
tweet!  Tight Looping with Macro Arrays
Ted Clay 
Keywords: macro language %DO macro array iteration
Pages: 8 Size: 59 Kb    Download the codedownload (.zip, 99 Kb)
tweet!  Processing Large Environmental Data Sets with SAS®: Writing Robust and Dynamic SAS Macro Code
Peter Mooney  Conor McDonagh  Adam C. Winstanley 
Keywords: Dynamic SAS Macro Code Enhancing GOPTIONS Generating WHERE statements
Pages: 7 Size: 268 Kb 
tweet!  %IFN - A Macro Function
Chang Y. Chung  Ian Whitlock 
Keywords: macro function
Pages: 6 Size: 63 Kb 
tweet!  Question: How Do I Find Out What That _TYPE_ Value Is from My MEANS Procedure? Answer: The FINDTYPE Macro!
Dan Bruns 
Keywords: macro
Pages: 4 Size: 66 Kb 
tweet!  The SQL Procedure: When and How to Use It
Ying Feng 
Keywords: PROC SQL DATA Step SAS
Pages: 7 Size: 66 Kb 
tweet!  Using Metadata and Project Data for Data-Driven Programming
Brian K. Varney 
Keywords: Macro SQL Stored Processes Base SAS
Pages: 10 Size: 143 Kb 
tweet!  DIGITS and DATES - The SQL Procedure Goes "Loopy"
Jack Hamilton 
Keywords: SQL DIGITS DATES
Pages: 11 Size: 71 Kb 
tweet!  SAS® Macros for Generating Abridged and Cause-Eliminated Life Tables
Zhao Yang  Xuezheng Sun 
Keywords: SAS MACRO abridged life table cause-eliminated life tables
Pages: 10 Size: 461 Kb 
tweet!  Duration Calculation from a Clinical Programmer's Perspective
Alice M. Cheng 
Keywords: clinical
Pages: 10 Size: 51 Kb 
tweet!  AMMI Macros for Multiplicative Interaction Models
EunJoo Lee  Dallas E. Johnson 
Keywords: Two-way Cross-classified Data Tukey's Model Mandel's Model Macros
Pages: 10 Size: 129 Kb 
tweet!  Dynamic Table Numbering - A Straightforward Approach
Diane C. Hall 
Keywords: none
Pages: 3 Size: 47 Kb 
tweet!  Inline Formatting + Long Character Variables = "I Didn't Know You Could Do That with SAS®"!
Derek Morgan 
Keywords: PROC REPORT ODS PROC TEMPLATE
Pages: 4 Size: 953 Kb 
tweet!  Custom Template for Reporting Interim Analyses Using PROC REPORT and Output Delivery System (ODS )
Hanaa M. Girgis 
Keywords: ODS PROC REPORT RTF PDF HTML EXCEL.
Pages: 6 Size: 113 Kb 
tweet!  The TEMPLATE Procedure Styles: Evolution and Revolution
Kevin D. Smith 
Keywords: proc template style styles css cascading style sheet stylesheet stylesheets sheets
Pages: 9 Size: 50 Kb    Download the PROC TEMPLATE Styles Tip Sheetdownload (.pdf, 725 Kb)
tweet!  %DataAutoSum: A SAS® Macro for Automatically Producing a Customized Clinical Data Summary Report
Deqing Pei  Cheng Cheng 
Keywords: macro data quality data summary report clinical
Pages: 8 Size: 229 Kb 
tweet!  The Invisible Character ALT+255 - Hidden Dragon: Hiding and Aligning Text in SAS® Output
Eugene Tsykalov  Shi-Tao Yeh 
Keywords: Alt255 Alt-255 Invisible character Hidden character hidden text ODS PDF Proc Report
Pages: 8 Size: 124 Kb 
tweet!  Making Presentations More Fun with the DATA Step Graphics Interface (DSGI)
Hui-Ping Chen 
Pages: 6 Size: 126 Kb 
tweet!  Perestroika: Restructuring Data for Flexibility
Mikhail Gruzdev  Blake Sanders 
Keywords: excel html rearrange export
Pages: 6 Size: 159 Kb 
tweet!  Getting Something from Nothing: How to Produce a TABULATE Procedure Table with All Zeros
Marie Alexander  Sharon Avrunin-Becker 
Keywords: PRINTMISS tabulate
Pages: 6 Size: 164 Kb 
tweet!  A Better Means - The ODS Data Trap
Myra A. Oltsik  Peter Crawford 
Keywords: ODS Means Macro
Pages: 10 Size: 135 Kb 
Honorable Mention
tweet!  The REPORT Procedure's Temporary Variable: What Is It? Why Do I Care?
Michael J. Molter 
Pages: 5 Size: 68 Kb 
tweet!  XSLT-Friendly XML: Generating Structured XML from SAS® Data
Ted Conway 
Keywords: xml xslt html
Pages: 6 Size: 366 Kb 
tweet!  A Powerful Macro to Control Title Appearance in SAS/GRAPH® Output
Louie Huang 
Keywords: SAS/GRAPH Macro PDF CGM PORC IMPORT PROC SQL
Pages: 8 Size: 225 Kb 
Best Contributed Paper
tweet!  Just Skip It
Helen Carey 
Pages: 8 Size: 113 Kb 
tweet!  Using SAS® Enterprise Guide® to Code When You're Not a Programmer
Britta K. August 
Keywords: enterprise guide
Pages: 6 Size: 335 Kb 
tweet!  SAS Enterprise Guide and SAS/CONNECT Software Peaceful Co-Existence Using SAS Code
John C. Hennessey 
Keywords: Integration Technologies enterprise guide
Pages: 3 Size: 32 Kb 
tweet!  Save Those Eyes: A Quality-Control Utility for Checking RTF Output Immediately and Accurately
Michael Hagendoorn  Jonathan M. Squire  Johnny Tai 
Keywords: RTF validation QC utility
Pages: 10 Size: 111 Kb 
tweet!  Teaching Your RTF Tagset to Do Clever Tricks
Wayne Hester 
Keywords: RTF ODS
Pages: 7 Size: 43 Kb    Download the codedownload (.zip, 11 Kb)

SUGI 30   April 10-13, 2005 - Philadelphia, Pennsylvania

Coders' Corner

tweet!  Storing and Using a List of Values in a Macro Variable
Art Carpenter 
Keywords: Macro variables %SCAN &&VAR&I PROC SQL INTO CALL SYMPUT
Pages: 6 Size: 130 Kb 
tweet!  Text Utility Macros for Manipulating Lists of Variable Names
Robert J. Morris 
Keywords: macro
Pages: 7 Size: 46 Kb 
tweet!  A Sample Macro for Creating a List on the Fly
Debbie Miller 
Keywords: macro facility
Pages: 4 Size: 29 Kb 
tweet!  What Would I Do without PROC SQL and the Macro Language?
Jeffrey M. Abolafia 
Keywords: Base SAS SQL macro
Pages: 5 Size: 204 Kb 
tweet!  A SAS Macro for Producing Customized Reports
Robert G. Edson  Yajie Wang  Lan Zhao 
Keywords: sugi30 macro
Pages: 10 Size: 50 Kb 
tweet!  Using Variable Values to Change Macro Variables in Loop Processing
Michael G. Eberhart 
Keywords: macro variables CALL routine
Pages: 6 Size: 129 Kb 
tweet!  A Better SYSIN Than SYSIN: Instream Files on Any Platform
Ted Conway 
Keywords: macro
Pages: 5 Size: 128 Kb 
Honorable Mention
tweet!  Automatically Process a Varying Number of New Data Files from a "Data Directory"
Michael A. Raithel 
Keywords: Macro data directory processing data files
Pages: 11 Size: 292 Kb 
tweet!  Reporting Statistical Results with PROC REPORT
Nestor Rohowsky 
Keywords: Descriptive statistics safety efficacy
Pages: 6 Size: 68 Kb 
Best Contributed Paper
tweet!  The Mystery of the PROC SORT Options NODUPRECS and NODUPKEY Revealed
Britta Kelsey 
Pages: 5 Size: 89 Kb 
tweet!  PROC IMPORT with a Twist
Gary M. McQuown 
Keywords: import excel input
Pages: 4 Size: 130 Kb 
tweet!  An Alternative Method of Transposing Data without the TRANSPOSE Procedure
Sunil K. Gupta 
Keywords: PROC SUMMARY
Pages: 6 Size: 107 Kb 
tweet!  A Macro for Importing Multiple Excel Worksheets into SAS Data Sets
Helen C. Sun  Cindy Wong 
Keywords: Data Transfer DDE Excel Import macro
Pages: 9 Size: 48 Kb 
tweet!  Using an Excel Spreadsheet with PC SAS, No Gymnastics Required!
Diane C. Hall 
Keywords: Excel INFILE DDE
Pages: 4 Size: 89 Kb 
tweet!  Make the Invisible Visible: A Case Study of Using ODS Inline Formatting Style
Zizhong Fan 
Keywords: ODS In-Line Formatting ESCAPECHAR
Pages: 7 Size: 149 Kb 
tweet!  Applying Microsoft Word Styles to ODS RTF Output
Lauren Haworth 
Keywords: ODS RTF Word
Pages: 9 Size: 115 Kb 
tweet!  A Microsoft Access GUI for SAS Automation
Rubin Nan  David Mullins 
Keywords: GUI Front-end Interface SAS Automation MS Access Software Integration Visual Basic
Pages: 4 Size: 72 Kb 
tweet!  A Matter of Presentation: Generating PowerPoint Slides from Base SAS Using Dynamic Data Exchange
Koen Vyverman 
Keywords: Base SAS Macro DDE PowerPoint
Pages: 15 Size: 618 Kb 
tweet!  %htmlForm: An HTML Form and SAS/IntrNet Code Generator
Don Boudreaux  Keith Cranford 
Keywords: HTML SAS/IntrNet Forms web
Pages: 10 Size: 126 Kb 
Honorable Mention
tweet!  "That Can't Be SAS!" Starting SAS/AF Applications
Greg J. McLean 
Keywords: GUI af
Pages: 9 Size: 246 Kb 
tweet!  %CYARROW, a New Annotate Macro
Chang Y. Chung  Ya Huang 
Keywords: graph annotate macro
Pages: 10 Size: 50 Kb 
tweet!  Creating Flexible Graphics with the DATA Step Graphics Interface (DSGI)
Hui-Ping Chen 
Keywords: External Text File Printto Gprint Entry-Name Existing Graph Viewport
Pages: 10 Size: 234 Kb 
tweet!  The New World of SAS: Programming with SAS Enterprise Guide
Stephen McDaniel  Chris Hemedinger 
Keywords: Enterprise Guide
Pages: 6 Size: 127 Kb 
tweet!  Text on My Remote Control: An Experiment in Shortest Distance Using SAS Software
Rick Langston 
Keywords: arrays data step iterative
Pages: 6 Size: 85 Kb 
tweet!  Remote Compute Services Simply Stated
James C. Stokes 
Pages: 3 Size: 80 Kb 
tweet!  Creating a Numeric Format to Suppress Small Numbers
Michael G. Eberhart 
Keywords: format macro
Pages: 3 Size: 80 Kb 
Best Contributed Paper
tweet!  PROC FORMAT: A Speedy Alternative to Sort/Merge
Jenine Eason 
Keywords: Proc Format Hashing Merge
Pages: 5 Size: 114 Kb 
tweet!  Pretty Dates All in a Row
Dianne Louise Rhodes 
Keywords: Dates INTCK INTNX
Pages: 5 Size: 126 Kb 
tweet!  Customer Segmentation by Using CALL SYMPUT, Arrays, and DO Loops
Rodger Zhang 
Keywords: Financial Segmentation Customer Product Loan Deposit CALL SYMPUT Array DO loop Transpose
Pages: 7 Size: 47 Kb 
tweet!  Techniques for Effectively Selecting Groups of Variables
Stuart Pollack 
Keywords: array
Pages: 4 Size: 58 Kb 
Honorable Mention
tweet!  In Search of the LOST CARD
Andrew T. Kuligowski 
Keywords: 'LOST CARD' INPUT 'ad hoc'
Pages: 9 Size: 105 Kb 
tweet!  A Clever Demonstration of the SAS SUBSTR Function
David J. Austin 
Keywords: align macro substr function repeat index
Pages: 7 Size: 98 Kb 
tweet!  How Old Am I?
Deb Cassidy 
Keywords: intck
Pages: 3 Size: 75 Kb 
Honorable Mention
tweet!  Slicing and Dicing the SAS Data Set
William C. Murphy 
Keywords: POINT SET DATA step MERGE macro programming
Pages: 5 Size: 46 Kb 
tweet!  A Shift in Time: Using SAS Date Alignment Operators
Andrew H. Karp 
Keywords: date and time fuctions SAS dates PROC EXPAND SAS/ETS
Pages: 2 Size: 30 Kb 
tweet!  Automation of Code Leads to a Vacation for You: Enabling and Disabling Table Constraints in an Oracle Table with SAS X Commands
David Steves  Denise A. Figliozzi 
Keywords: SAS X Commands Base SAS
Pages: 5 Size: 111 Kb 
tweet!  Mainframe SAS for the 21st Century
Kryn Krautheim 
Keywords: OS/390 MVS ODS PDF
Pages: 6 Size: 37 Kb 
tweet!  Some UNIX Tips for SAS Programming
Jianming He 
Keywords: UNIX script SAS
Pages: 4 Size: 126 Kb 
tweet!  The Pegboard Game: An Iterative SAS Program to Solve It
Rick Langston 
Keywords: arrays data step iteration
Pages: 6 Size: 38 Kb 
Best Contributed Paper
tweet!  Journeymen's Tools: The Writing for Reading and Reuse Program Header
Ronald Fehd 
Keywords: comments theory documentation
Pages: 4 Size: 97 Kb 
tweet!  A Hacker's Guide to SAS Environment Customization
Brian P. Fairfield-Carter  Stephen Hunt 
Keywords: Dynamic HTML Code Templates GNU
Pages: 10 Size: 258 Kb 
tweet!  Stranded on a Desert Island with Nothing but TITLE Statements
Rick Mitchell 
Keywords: TITLE REPORT SYMPUT
Pages: 6 Size: 164 Kb 
tweet!  Exploring DICTIONARY Tables and Views
Kirk P. Lafler 
Keywords: Dictionary Tables tables views
Pages: 6 Size: 574 Kb 

SUGI 29   May 9-12, 2004 - Montreal, Canada

Coders' Corner

tweet!  Helpful Undocumented Features in SAS
Wei Cheng 
Keywords: MONOTONIC( ) COLON (:) MODIFIER JOIN METHOD
Pages: 8 Size: 230 Kb 
tweet!  PROC FREQ - What's It Really Good For?
Theresa Gordon  Monique Eleby 
Keywords: proc freq eleby gordon
Pages: 3 Size: 111 Kb 
tweet!  Top Ten Reasons to Use PROC SQL
Weiming Hu 
Keywords: SQL ORACLE
Pages: 6 Size: 221 Kb 
Best Contributed Paper
tweet!  An Introduction to Regular Expressions with Examples from Clinical Data
Richard Pless 
Keywords: REGEX mis-spelling clinical
Pages: 8 Size: 43 Kb 
tweet!  The Very Valuable Variable Value Functions
Howard Schreier 
Keywords: Format formatted value VVALUE VVALUEX
Pages: 5 Size: 109 Kb 
tweet!  A Format to Make the _Type_ Field of PROC MEANS Easier to Interpret
Matt Pettis 
Keywords: Proc Means Type Format Macro
Pages: 5 Size: 68 Kb 
tweet!  Double Your Pleasure, Double Your Words...
David L. Cassell 
Keywords: DOW-loop PRXPARSE PRXMATCH
Pages: 5 Size: 209 Kb 
tweet!  Guidelines on Writing SAS® Macros for Public Use
Frank J. Ivis 
Keywords: macro standards
Pages: 9 Size: 151 Kb 
tweet!  Making Music in SAS: Using Sound to Alert Users of Errors and Data Discrepancies
David A. Fielding 
Keywords: sound sleep select _null_
Pages: 5 Size: 36 Kb 
tweet!  Switch Data Source and Output Destination without Changing Programs
David Shen  Zaizai Lu 
Keywords: Automatic Switch Data Source Output Destination File Management
Pages: 6 Size: 33 Kb 
tweet!  Comparing the Desired Variable Definitions with the Actual Data Sets across Multiple Studies
Shane L.Hornibrook 
Keywords: DDE vcolumn scoring ODS
Pages: 6 Size: 42 Kb 
tweet!  Using SAS Catalogs to Develop and Manage SAS Data Step Programs
David D. Chapman 
Keywords: SAS Catalog Base SAS
Pages: 10 Size: 136 Kb 
tweet!  The Power of CALL SYMPUT - DATA Step Interface by Examples
Yunchao (Susan) Tian 
Keywords: BYTE function format
Pages: 5 Size: 167 Kb 
tweet!  Automatic Logon to Mainframe and Transfer SAS Data Sets
Prasad S. Ravi 
Keywords: Log
Pages: 7 Size: 91 Kb 
Best Contributed Paper
tweet!  Colonoscopy for the SAS® Programmer
William C. Murphy 
Keywords: tips data management
Pages: 4 Size: 54 Kb 
tweet!  Better Clay Builds Better Bricks: Some Simple Suggestions to Writing Professional Macros
Michael P. Bramley 
Keywords: MACRO EFFICIENCY TECHNIQUES TIPS LIBRARY
Pages: 10 Size: 48 Kb 
tweet!  Reading Multiple Complex Report Files
Tugluke Abdurazak 
Keywords: Financial Report Complex Data
Pages: 6 Size: 53 Kb 
tweet!  A Macro for Reading Multiple Text Files
Debbie Miller 
Keywords: macro facility file import Base SAS
Pages: 4 Size: 137 Kb 
tweet!  Complementing SAS with Perl: Updating, Creating, Running and Checking SAS Code
Marcelo Coca-Perraillon  Matthew P. Lambert 
Keywords: Macros Perl
Pages: 8 Size: 41 Kb 
tweet!  Using Text Files to Enhance SAS Code
David J. Austin 
Keywords: ASCII text flat list hierarchical format
Pages: 10 Size: 148 Kb 
tweet!  All The News That's Fit to Aggregate: A SAS Based RSS Newsreader
Ted Conway 
Keywords: base rss newsreader xml
Pages: 4 Size: 255 Kb 
tweet!  A Stand-Alone SAS Annotate System for Figure Generation
Brian P. Fairfield-Carter 
Keywords: Annotate VBScript Windows Scripting Host
Pages: 12 Size: 222 Kb 
tweet!  Dynamic Macro Invocation Utility
Paul D. Sherman 
Keywords: macro parameter positional keyword
Pages: 8 Size: 165 Kb 
Honorable Mention
tweet!  The Role of Consecutive Ampersands in Macro Variable Resolution and the Mathematical Patterns that Follow
Michael J. Molter 
Keywords: macros variables ampersands automation applications techniques
Pages: 8 Size: 80 Kb 
tweet!  Creating Efficient SQL - Union Join without the Union Clause
Paul D. Sherman 
Keywords: RDBMS SQL
Pages: 8 Size: 170 Kb 
Honorable Mention
tweet!  Subsetting SAS Data Set by Using PROC SQL Self-join with Compound Key
Zizhong Fan 
Keywords: SQL self-join
Pages: 4 Size: 255 Kb 
tweet!  Using SAS to Process Data Entered into a Microsoft Access User Interface
Regina Clincy 
Keywords: Automate MS Access Data Entry Application
Pages: 4 Size: 305 Kb 
tweet!  SAS Data Views Simply Stated
James C. Stokes 
Keywords: SAS data set
Pages: 3 Size: 108 Kb 
tweet!  Dating SAS and MS Excel
Erik W. Tilanus 
Keywords: Excel date values time values
Pages: 4 Size: 96 Kb 
tweet!  A SAS Macro to Count Consecutive Days
Pingping Zhang 
Keywords: diary data dates consecutive days macro
Pages: 4 Size: 91 Kb 
tweet!  ARRAY: Construction and Usage of Arrays of Macro Variables
Ronald Fehd 
Keywords: array Array Contents delimiter loop macro ParmBuff scan Qscan symput SysPbuff until SQL
Pages: 6 Size: 101 Kb 
tweet!  Using SAS/AF to Create Data Entry Screens with Multiple Comment Fields Allowing for Unlimited Amounts of Text in Each Field
Robert S. Matthews 
Keywords: SAS/AF comment fields SCL lists
Pages: 5 Size: 229 Kb 
tweet!  Matching Character Variables by Sound: A Closer Look at the SOUNDEX Function and Sounds-Like Operator (=*)
Zizhong Fan 
Keywords: SOUNDEX SOUNDS-LIKE operator
Pages: 4 Size: 172 Kb 
tweet!  Using Edit-Distance Functions to Identify "Similar" E-Mail Addresses
Howard Schreier 
Keywords: Fuzzy match similar
Pages: 8 Size: 197 Kb 
tweet!  Tales From the Help Desk: Solutions for Simple SAS Mistakes
Bruce F. Gilsen 
Keywords: errors fixing errors
Pages: 8 Size: 126 Kb 
Best Contributed Paper
tweet!  Randomly Selecting Observations
Robert Patten 
Keywords: sample random ranuni point
Pages: 9 Size: 167 Kb 
Honorable Mention
tweet!  Quicker Than Merge?
Kirby L. Cossey 
Keywords: Index KEY= Join
Pages: 6 Size: 163 Kb 
tweet!  Subset Raw Data and Zip Them Up
Desheng Xu 
Keywords: _INFILE_ PUT %SYSFUNC CALL SYMPUT
Pages: 3 Size: 58 Kb 
tweet!  Dynamic SAS Programming Techniques, or How NOT to Create Job Security
Steven D. Beakley  Suzanne D. McCoy 
Keywords: dynamic macro dictionary tables
Pages: 10 Size: 63 Kb 
tweet!  Linking Unlinked Data: PROCs SQL and SORT Can Do It
Merle E. Hamburger  Thomas Sukalac 
Keywords: Longitudinal data SQL
Pages: 4 Size: 26 Kb 
tweet!  Directly Using the Lab Ranges Data into SAS Program of Determining Lab Normality
Don(Dongguang) Li 
Keywords: Data _null_ SAS put statement SAS code output Laboratory data
Pages: 3 Size: 30 Kb 
tweet!  Using Templates Created by the SAS/STAT Procedures
Yanhong Huang  Jianming He 
Keywords: Template ODS SAS/STAT Procedures
Pages: 5 Size: 198 Kb 
tweet!  A Practical Approach to Transferring Data from Microsoft Excel® to SAS® in Pharmaceutical Research
Hong Qi 
Keywords: Excel SAS data transfer DDE
Pages: 7 Size: 127 Kb 

SUGI 28   March 30 - April 2, 2003 - Seattle, Washington

Coders' Corner

tweet!  Space Odyssey: Concatenate Zip Files into One Master File
Ying Long 
Keywords: X command concatenate
Pages: 2 Size: 167 Kb 
Best Contributed Paper
tweet!  The URL-y Show: Using SAS® LE and the URL Access Method to Retrieve Stock Quotes
Ted Conway 
Keywords: url pc base le
Pages: 2 Size: 223 Kb 
tweet!  So Many Files, So Little Time (or Inclination) to Type Their Names: Spreadsheets by the Hundreds
Francis J. Kelley 
Keywords: SAS/Access for PC File Formats FILEVAR= SAS Macro PIPE Access Method Proc IMPORT
Pages: 4 Size: 261 Kb 
tweet!  Splitting a Large SAS® Data Set
Selvaratnam Sridharma 
Keywords: %sysevalf %eval
Pages: 2 Size: 141 Kb 
tweet!  Comparative Efficiency of SQL and Base Code When Reading from Database Tables and Existing Data Sets
Steven Feder 
Keywords: SQL Efficiency Base Benchmark
Pages: 5 Size: 173 Kb 
tweet!  Automatically Combining the Data from a Variety of DBMSs with ODBC and PROC SQL
Han Wu  Jason Au  Craig Toyota 
Keywords: ODBC PROC SQL DBMS
Pages: 3 Size: 194 Kb 
tweet!  Automatic Data File Retrieval from Different Database Engines
Xin Zhang  Chuanchieh Hsu 
Keywords: SAS/ACCESS PROC SQL ODBC macro
Pages: 3 Size: 196 Kb 
tweet!  UNLOADing Data from Informix
John E. Bentley  Bala Peddi 
Keywords: RDBMS Informix Data Warehousing SAS Access
Pages: 6 Size: 178 Kb 
tweet!  Return Code from Macro; Passing Parameter by Reference
Hsiwei Yu  Gary Huang 
Keywords: PROC REPORT macro
Pages: 2 Size: 138 Kb 
tweet!  If Only 'Page 1 of 1000'
Jiang Jin  Ye Jin  Diane Wang 
Keywords: page macro execute iteration table file
Pages: 2 Size: 108 Kb 
tweet!  Don't Dither About Your Data, Let SAS/GRAPH® Trending Box Plots Drive Decision Making
Charlotte F. Carroll 
Keywords: Box and Whisker Plot Box Plot Dither
Pages: 3 Size: 234 Kb 
tweet!  A Handy Use of the %LINE Annotate Macro
Deena D. Rorie  Lynette K. Duncan 
Keywords: Annotate GPLOT MACROS
Pages: 3 Size: 196 Kb 
tweet!  A Drill-Down Diet: An Example of a Dynamic Detail Access on the Web Using SAS/GRAPH® and ODS
Nadia Redmond 
Keywords: SAS/GRAPH ODS PROC GPLOT Drill-Down internet
Pages: 4 Size: 195 Kb 
tweet!  Make Your Life a Little Easier: A Collection of SAS® Macro Utilities
Pete Lund 
Keywords: FTP X command TRANSPORT CONNECT macro
Pages: 10 Size: 230 Kb 
tweet!  More _Infile_ Magic
Peter Crawford 
Keywords: data manipulation _infile_ programming
Pages: 2 Size: 118 Kb 
tweet!  The Power of Recursive SAS® Macros - How Can a Simple Macro Do So Much?
John H. Adams 
Keywords: Recursive macros directory trees
Pages: 5 Size: 173 Kb 
tweet!  Continuous or Not: How One Can Tell
Vatsala V. Karwe 
Keywords: continuous categorical macro
Pages: 2 Size: 149 Kb 
tweet!  Identifying Continuity in Longitudinal Data
Merle E. Hamburger  Thomas Sukalac 
Keywords: Longitudinal continuity repeated observations
Pages: 2 Size: 157 Kb 
tweet!  Determining the Dimensionality of Data: A SAS® Macro for Parallel Analysis
Robert I. Kabacoff 
Keywords: multivariate statistics components factor analysis macro
Pages: 3 Size: 182 Kb 
tweet!  Using a SAS® Macro to Document the Database
William C. Murphy 
Keywords: macro ODS documentation database symput data _null_
Pages: 4 Size: 195 Kb 
Best Contributed Paper
tweet!  An Automated MS Powerpoint Presentation Using SAS®
Rick A. Allen 
Keywords: automation Powerpoint Excel Unix scheduling link
Pages: 6 Size: 196 Kb 
tweet!  A Macro Using SAS® ODS to Summarize Client Information from Multiple Procedures
Stuart D. Long  Rebecca Darden 
Keywords: ODS PROC LOGISTIC MACRO
Pages: 6 Size: 153 Kb 
tweet!  Multiple Graphs on One Page: The Easy Way (PDF) and the Hard Way (RTF)
Kevin P. Delaney 
Keywords: ODS PDF ODS RTF SAS/GRAPH DDE
Pages: 6 Size: 460 Kb 
tweet!  Taking Control of Macro Variables
Dante diTommaso 
Keywords: macro language symbol table global local macro trigger
Pages: 6 Size: 238 Kb 
tweet!  PROC SQL vs. Merge - The Miller Lite Question of 2002 and Beyond
Kevin J. Smith  Muhammad Z. Khan  Yadong Zhang 
Keywords: SQL Merge Benchmark Performance Hashing Efficiency
Pages: 4 Size: 178 Kb 
tweet!  An Efficient Approach to Combine SAS® Data Sets with Voluminous Variables That Need Name and Other Changes
Grace Chiu  Edward Heaton 
Keywords: rename sql append
Pages: 5 Size: 168 Kb 
tweet!  Danger: MERGE Ahead! Warning: BY Variable with Multiple Lengths!
Bob Virgile 
Keywords: merge length of variables
Pages: 6 Size: 188 Kb 
tweet!  The DOW (Not that DOW!!!) and the LOCF in Clinical Trials
Venky Chakravarthy 
Keywords: LOCF PHARMACEUTICAL RETAIN CLINICAL
Pages: 4 Size: 191 Kb 
tweet!  MACRO Function with Error Handling to Automatically Generate Global Macro Date Variables
Anatoly V. Kulinsky 
Keywords: MACRO Date Handling Error Function DataMart
Pages: 5 Size: 194 Kb 
tweet!  Report? Make It Easy - An Example of Creating Dynamic Reports into Excel
Liping Huang 
Keywords: Report ODS Frequency Mean Chisq T-Test
Pages: 6 Size: 259 Kb 
tweet!  Another Shot at the Holy Grail: Using SAS® to Create Highly-Customized Excel Workbooks
Ted Conway 
Keywords: excel vba base
Pages: 3 Size: 257 Kb 
tweet!  Combining Summary Level Data with Individual Records
Frank J. Ivis 
Keywords: summary records SET SQL
Pages: 3 Size: 158 Kb 
tweet!  RETAINing Information to Identify Entity Characteristics
John D. Chapman 
Keywords: RETAIN statement
Pages: 3 Size: 179 Kb 
tweet!  Randomized Rounding
Erik W. Tilanus 
Keywords: Rounding Simulation Integer calculations
Pages: 2 Size: 173 Kb 
tweet!  Logicals from Libraries: Using Storage as a Bridge between Sessions
Gary E. Schlegelmilch 
Keywords: functions
Pages: 3 Size: 121 Kb 
tweet!  %Fun &With %SYSFUNC
Derek Morgan 
Keywords: %SYSFUNC Macro Renaming Variables
Pages: 3 Size: 181 Kb 
tweet!  Creating Display Manager Abbreviations and Keyboard Macros for the Enhanced Editor
Arthur L. Carpenter 
Keywords: keyboard macro Display Manager Abbreviations Enhanced Editor
Pages: 3 Size: 154 Kb 
tweet!  Build a SAS® Development Environment under Windows
Wei Cheng 
Keywords: development environment Windows shortcut context
Pages: 3 Size: 193 Kb 
tweet!  Using SAS® Catalogs to Develop and Manage DATA Step Programs
David D. Chapman 
Keywords: Catalogs
Pages: 4 Size: 195 Kb 
tweet!  Let's Play a Game: A SAS® Program for Creating a Word Search Matrix
Robert S. Matthews 
Keywords: arrays game
Pages: 5 Size: 200 Kb 
tweet!  SAS/CONNECT® : The Ultimate in Distributed Processing
James C. Stokes 
Keywords: SAS/Connect Remote Library Services Remote Compute Services Data Transfer Services
Pages: 2 Size: 165 Kb 
tweet!  Run Time Comparison Macro
Robert R. Patten 
Keywords: Efficiency Macro
Pages: 3 Size: 176 Kb 
tweet!  Parallel Processing on the Cheap: Using Unix Pipes to Run SAS® Programs in Parallel
Ted Conway 
Keywords: parallel unix base script
Pages: 2 Size: 224 Kb 
tweet!  Date Parameters for Interval Reporting
Nina L. Werner 
Keywords: CALL SYMPUT DATE() INTNX PUT macro variable TODAY()
Pages: 2 Size: 130 Kb 
tweet!  Keep Those Formats Rolling: A Macro to Manage the FMTSEARCH= Option
Pete Lund 
Keywords: recode freq acs macro
Pages: 9 Size: 287 Kb 
tweet!  A Simplified and Efficient Way to Map Variables of a Clinical Data Warehouse
Yanyun Shen 
Keywords: data warehouse mapping clinical
Pages: 6 Size: 234 Kb 
tweet!  Renaming All Variables in a SAS® Data Set Using the Information from PROC SQL's Dictionary Tables
Prasad S. Ravi 
Keywords: PROC SQL DICTIONARY TABLES DICTIONARY COLUMNS PROC DATASETS
Pages: 3 Size: 143 Kb 
Best Contributed Paper
tweet!  The BEST. Message in the SAS® Log
Andrew T. Kuligowski 
Keywords: SASLOG Formats BEST. Format
Pages: 3 Size: 235 Kb 

SUGI 27   April 14-17, 2002 - Orlando, Florida

Coders' Corner

tweet!  An Introduction to SAS® PROC SQL
Timothy J. Harrington 
Keywords: SQL Create Join View Dictionary
Pages: 6 Size: 41 Kb 
tweet!  Using the Magical Keyword 'INTO:' in PROC SQL
Thiru Satchi 
Keywords: INTO: host-variable macro arrays SQL
Pages: 7 Size: 146 Kb 
Best Contributed Paper
tweet!  A Visual Introduction to SQL Joins
Kirk P. Lafler 
Keywords: SQL joins Cartesian Product Inner join combining data queries
Pages: 3 Size: 134 Kb 
tweet!  Creating Efficient SQL - Four Steps to a Quick Query
Paul D. Sherman 
Keywords: SQL query pass-through table select
Pages: 5 Size: 156 Kb 
tweet!  A Very Powerful Resource for SAS® Users Worldwide
JoAnn Matthews 
Keywords: SAS-L user support
Pages: 2 Size: 118 Kb 
tweet!  How to Link Records Matching on at Least m Out of n Identifying Keys
Xinyu Ji 
Keywords: Record Linkage CNTLIN repeat case link case
Pages: 5 Size: 116 Kb 
Honorable Mention
tweet!  Fast and Easy Ways to Check Your Work: Using PROC MEANS to Confirm Continuous Variable Categorizations
Rick M. Mitchell 
Keywords: means check categorize
Pages: 2 Size: 88 Kb 
Best Contributed Paper
tweet!  What's Your _TYPE_? How to Find the CLASS You Want in PROC SUMMARY
Frank A. Ferriola Jr. 
Keywords: CLASS statement _TYPE_ PROC SUMMARY
Pages: 4 Size: 162 Kb 
tweet!  Let Summary Sum and Tabulate Format
Marianne L. Whitlock 
Keywords: Tabulate Summary Format Report
Pages: 3 Size: 34 Kb 
tweet!  Taking Advantage of Missing Values in PROC SQL
Ya Huang 
Keywords: Proc SQL Summary function missing value
Pages: 3 Size: 116 Kb 
tweet!  A New Method to Estimate the Size of a SAS® Data Set
Xingshu Zhu  Shuping Zhang 
Keywords: dataset proc contents NDA submission
Pages: 3 Size: 144 Kb 
tweet!  Macro for Restoring SAS® Transport Files
Yefim Gershteyn 
Keywords: Macro Restore Transport Files
Pages: 3 Size: 134 Kb 
tweet!  Using the FILEVAR= Option for Input and Output
Derek Morgan 
Keywords: DATA step ASCII files
Pages: 4 Size: 89 Kb 
tweet!  Splitting a Large SAS® Data Set
John R. Gerlach  Simant Misra 
Keywords: Macro Language
Pages: 2 Size: 116 Kb 
tweet!  Using the Contents of PROC CONTENTS to Perform Multiple Operations Across a SAS® Data Library
Subrahmanyam Pilli  Luai R. Alzoubi  Kent Nassen 
Keywords: Proc Contents memname dataset processing iterative processing symput macro
Pages: 3 Size: 34 Kb 
tweet!  Stop Madly Merging: PROC PRINT to the Rescue!
Catherine A. Lindsey 
Keywords: merging muliple datasets indicator variables
Pages: 2 Size: 23 Kb 
tweet!  Powerful Techniques for Data Processing Using Formats
Timothy M. Muir 
Keywords: cntlin where efficiency formats merge subset
Pages: 4 Size: 24 Kb 
tweet!  Merging Flat Files Directly
Robert R. Patten 
Keywords: flatfile
Pages: 4 Size: 133 Kb 
tweet!  Finally - An Easy Way to Compare Two SAS® Files!
Doug Zirbel 
Keywords: SQL Dictionary
Pages: 5 Size: 90 Kb 
tweet!  Many-to-Many Merging Using the SAS® Macro Facility
Jonathan D. Mahnken 
Keywords: merge many-to-many merge macro
Pages: 6 Size: 117 Kb 
Honorable Mention
tweet!  Secret Tools of the Ad Hoc Programmer
Robert Burnham  Bill Marble  Kathryn Sabadosa 
Keywords: adhoc macro ODS
Pages: 4 Size: 118 Kb 
tweet!  Graphing Them Together: Overlaying Plots with Macros and SAS/GRAPH®
Lawrence Altmayer 
Keywords: Macros SAS/GRAPH symbol statement
Pages: 2 Size: 32 Kb 
tweet!  Your Shingle in SAS/GRAPH®
David H. Johnson 
Keywords: Graph Gif creation GSlide Web icons 3d images Pecten
Pages: 6 Size: 149 Kb 
tweet!  %TREND: A Macro to Produce Maximally Informative Trend Charts with SAS/GRAPH® , SAS® , and ODS for the Web or Hardcopy
LeRoy Bessler  Francesca Pierri 
Keywords: SAS/GRAPH ODS PROC GPLOT Trend Chart Plot Visual Communication macro internet
Pages: 6 Size: 666 Kb 
tweet!  What Does the Style Definition Look Like?
Wei Cheng 
Keywords: ODS style definition HTML PDF RTF
Pages: 5 Size: 132 Kb 
tweet!  A Version Control Kluge for SAS® Programs - Using SAS!
Tim P. Williams 
Keywords: version control code development project management Macro Language programming UltraEdit
Pages: 6 Size: 318 Kb 
tweet!  A Utility Program for Checking SAS® Log Files
Carey G. Smoak 
Keywords: UTILITY LOG FILES
Pages: 2 Size: 33 Kb 
tweet!  A Macro to Help with Accurate Output Documentation
Bruce Spotts 
Keywords: macro titles footnotes documentation
Pages: 2 Size: 100 Kb 
tweet!  Bulletproofing Your SAS® Results
Vanessa C. Hayden 
Keywords: macros data quality accuracy automation
Pages: 6 Size: 136 Kb 
Best Contributed Paper
tweet!  A Quick and Easy Data Dictionary Macro
Pete Lund 
Keywords: data dictionary macro formats
Pages: 6 Size: 149 Kb 
tweet!  Macro Functions: How to Make Them - How to Use Them
Arthur L. Carpenter 
Keywords: macro function %SYSFUNC
Pages: 5 Size: 144 Kb 
tweet!  Have a Strange Date? Create Your Own INFORMAT to Deal with Her
Venky Chakravarthy 
Keywords: Informat Scan
Pages: 5 Size: 177 Kb 
tweet!  A Better Desktop Than Windows: Using Excel to Organize, View, Launch and Document SAS® Programs
Ted Conway 
Keywords: Windows Excel
Pages: 2 Size: 92 Kb 
tweet!  Simplifying SAS® Security
Derek Morgan  Michael Province 
Keywords: Passwords macro security
Pages: 5 Size: 104 Kb 
tweet!  Seeing Red: Tips for Debugging the SAS® DATA Step
Michael J. Yee 
Keywords: data step log column submit debugging syntax
Pages: 4 Size: 179 Kb 
tweet!  Run All Your SAS® Programs in One Program: Automatically
Ling Yun Chen  Steven A. Gilbert 
Keywords: batch automatic .bat
Pages: 2 Size: 86 Kb 
tweet!  No Task Before Its Time: Schedule Your Jobs with Robot Code
Charles vanWynbergen 
Keywords: automate schedule connect robot automation ad hoc
Pages: 6 Size: 172 Kb 
tweet!  Passing Values to a Remote Multi-process SAS/CONNECT® Session
John E. Bentley 
Keywords: MP/CONNECT Macro Variables
Pages: 4 Size: 151 Kb 
tweet!  Guide to Extract/Download Multiple Databases from Mainframe Tapes to PC Using PC SAS®
Fereydoun Foroudian 
Keywords: Download Mainframe Data to PC Upload PC data to Mainframe Run JCL Jobs using SAS PC Create JCL Jobs using SAS PC Mainframe Tape and SAS PC
Pages: 2 Size: 115 Kb 
Best Contributed Paper
tweet!  SAS/CONNECT® Simply Stated
James C. Stokes 
Keywords: SAS/Connect download upload remote processing
Pages: 2 Size: 100 Kb 

SUGI 26   April 22-25, 2001 - Long Beach, California

Coders' Corner

tweet!  Data Visualization of Outliers from a Health Research Perspective Using SAS/GRAPH and the Annotate Facility
Nadia Redmond 
Keywords: Outliers Global ANNOTATE PROC GPLOT SAS/GRAPH healthcare
Pages: 5 Size: 138 Kb 
tweet!  Data Analysing in SAS, Graphs Guilding in SigmaPlot, Outputs in PowerPoint
Sherry Q. Zhang 
Keywords: SigmaPlot
Pages: 4 Size: 56 Kb 
tweet!  Reduction of Symbols in Plots and Generation of Accompanying Legend Using Annotate
Dean D. Clous 
Keywords: gplot annotate
Pages: 3 Size: 50 Kb 
tweet!  That Mysterious Colon (:)
Haiping Luo 
Keywords: colon (:) code efficiency
Pages: 5 Size: 131 Kb 
tweet!  Taking Control and Keeping It: Creating and Using Conditionally Executable SAS Code
Justina M. Flavin  Arthur L. Carpenter 
Keywords: conditional execution conditional processing cancel abort endsas errorabend
Pages: 4 Size: 108 Kb 
tweet!  Web-Application Bar Charts without SAS/GRAPH
Steve James 
Keywords: web bar-chart SAS/Graph HTML SAS/IntrNet internet
Pages: 5 Size: 156 Kb 
tweet!  Add a Common Look and Feel to Web Applications Easily
Steve James 
Keywords: web SAS/IntrNet look and feel HTML internet
Pages: 4 Size: 113 Kb 
tweet!  ODS and Browser Interaction Solutions
Steven H. Feder 
Keywords: ods browser
Pages: 3 Size: 93 Kb 
tweet!  SAS and Electronic Mail: Send E-mail Faster, and DEFINITELY More Efficiently
Roy I. Fleischer 
Keywords: Mail
Pages: 5 Size: 154 Kb 
tweet!  Using SAS Explorer to View File Properties and Catalog Contents
Kirk P. Lafler 
Keywords: Explorer Properties Catalog Multi-paned window GUI Interface
Pages: 2 Size: 426 Kb 
tweet!  Efficient Statistical Programming? - Let SAS Do the Work
Keiko I. Powers 
Keywords: efficient programming data analysis
Pages: 4 Size: 90 Kb 
tweet!  Automating the Process of Listing the Most Frequent Values of Thousands of Variables in Large Data Sets
Haiping Luo  Philip E. Friend 
Keywords: list frequent values macro application profiling large datasets
Pages: 5 Size: 113 Kb 
tweet!  Summarizing Data with an Inconsistent Text Key? Here's How!
Sylvia C. Tze 
Keywords: macro substr Proc Summary
Pages: 3 Size: 114 Kb 
tweet!  Summarizing to the One-Record-per-Person using PROC SUMMARY: When to Use CLASS and When to Use BY
Jenny Yu 
Keywords: summary class by
Pages: 4 Size: 124 Kb 
tweet!  SAS Programming Solutions for Summarizing Character Variables
Yefim Gershteyn 
Keywords: PEEK ADDR POKE PEEKC direct-addressing functions PDV
Pages: 4 Size: 164 Kb 
tweet!  SAS Formats: Making the Best of a Bad Situation
Michelle L. Pritchard 
Keywords: formats categorical data SAS/Graph
Pages: 2 Size: 74 Kb 
tweet!  You Can Look It Up: A Robust Macro Using PROC FORMAT with CNTLIN
Myra A. Oltsik 
Keywords: FORMAT CNTLIN MACRO
Pages: 4 Size: 96 Kb 
tweet!  A Macro to Center Text in a DATA _NULL_ Step
Erik S. Larsen 
Keywords: PUT Macro _NULL_
Pages: 3 Size: 114 Kb 
tweet!  Use Call Symput and %SYSFUNC for More Informative Titles and Footnotes
Lynn G. Palmer 
Keywords: CALL SYMPUT %SYSFUNC %QSYSFUNC titles footnotes macro
Pages: 3 Size: 44 Kb 
tweet!  Format Challenges with PROC REPORT
Lisa M. Schneider 
Keywords: PROC REPORT COMPUTE ACROSS
Pages: 6 Size: 49 Kb 
tweet!  The Ultimate SAS Macro (Make SAS Do All the Work! )
Mike D. Tangedal 
Keywords: macro autocall %sysfunc symput ampersands
Pages: 5 Size: 57 Kb 
tweet!  Make Your Life a Little Easier: A Collection of SAS Macro Utilities
Pete Lund 
Keywords: macro %sysfunc utilities
Pages: 10 Size: 150 Kb 
tweet!  Using SAS to Write SAS - Automate Your Programming Tasks
Pamela L. Reading 
Keywords: code generation EXCEL
Pages: 5 Size: 112 Kb 
tweet!  Performing Multiple Statements for Each Record in a SAS Data Set
Edward J. Moore 
Keywords: macros
Pages: 2 Size: 31 Kb 
tweet!  %ToC: A Macro for Generating Table of Contents from SAS Output
Hong Chen 
Keywords: table of contents macro output
Pages: 4 Size: 91 Kb 
tweet!  How Many Observations Are In My Data Set?
Jack Hamilton 
Keywords: observations nobs= ATTRN function
Pages: 6 Size: 86 Kb 
tweet!  Quick Sorting an Array
Paul M. Dorfman 
Keywords: arrays quicksort partition insertion sort %qsort() sorting
Pages: 6 Size: 136 Kb 
tweet!  Side By Side: Comparing Two Data Sets Using SAS Macros
Aileen D. Bennett 
Keywords: macro
Pages: 3 Size: 70 Kb 
tweet!  A SAS Macro to Isolate All Date Values from a Data Library into a SAS Dataset
Michael L. White 
Keywords: SQL Macro SAS dates
Pages: 2 Size: 32 Kb 
tweet!  Quick and Dirty Data Laundering: A Scalable Solution for Range Checking Data
Michael J. Yee 
Keywords: Data Cleaning Range Check Macro Clinical
Pages: 2 Size: 96 Kb 
tweet!  Macros for Euclidean Distances
Robert O. Bernstein 
Keywords: macro euclidean API Education distance
Pages: 5 Size: 26 Kb 
tweet!  Merging Disk Datasets to Large Unsorted Tape Datasets without a Sort Step, Using Indexed SAS Files
William E. Benjamin Jr. 
Keywords: merge index unsorted tape files
Pages: 3 Size: 45 Kb 
tweet!  Merging Small Datasets to Large Unsorted Tape Datasets without a Sort Step, Using SAS Formats
William E. Benjamin Jr. 
Keywords: Functions Formats Merge
Pages: 3 Size: 37 Kb 
tweet!  50 Ways to Merge Your Data - Installment 1 ...
Kristie L. Schuster  Lori L. Sipe 
Keywords: merge
Pages: 5 Size: 94 Kb 
tweet!  Merging Tables in DATA Step vs. PROC SQL: Convenience and Efficiency Issues
Gajanan Bhat  Raj Suligavi 
Keywords: Efficiency SQL Data Step
Pages: 4 Size: 44 Kb 
tweet!  Tips for Using PROC SQL to Extract Information from Medical Claims Data Sets
Clayton Wells 
Keywords: SQL transpose count function
Pages: 4 Size: 121 Kb 
tweet!  Comparing Pairs: The Array's the Thing
Mary MacDougall 
Keywords: arrays DO loop PROC TRANSPOSE
Pages: 3 Size: 98 Kb 
tweet!  Intelligent SAS Log Manager
Paul D. Sherman 
Keywords: log symbolgen mlogic merror macro
Pages: 4 Size: 127 Kb 
tweet!  Advanced SAS String Functions and a Little Recursion Protect Against Run-Time Errors
Amy Swinford 
Keywords: string function rxparse recursion
Pages: 3 Size: 91 Kb 

SUGI 25   April 9-12, 2000 - Indianapolis, Indiana

Coders' Corner

tweet!  Scrolling and Downloading Web Results
Ming C. Lee 
Keywords: Scrolling Downloading Web Internet
Pages: 5 Size: 40 Kb 
tweet!  Creating Adobe Acrobat (PDF) Documents Directly from SAS Software
Paul C. Wehr 
Keywords: PDF Adobe Acrobat Output distribution Information delivery Document management Reporting tools
Pages: 1 Size: 55 Kb 
tweet!  Controlling Print Setup Options from within a Windows SAS Program
Delayne H. Stokke 
Keywords: Print Setup Macros Page Orientation
Pages: 6 Size: 140 Kb 
tweet!  An Automated Method to Create a Descriptive Index For a Directory of SAS Programs
Gary Cunningham 
Keywords: Windows NT pipe index macro
Pages: 5 Size: 153 Kb 
tweet!  The Autocall Macro Facility in the Microsoft Windows Environment
Karl L. Jensen  Matthew L. Greathouse 
Keywords: Autocall Macro Windows
Pages: 2 Size: 93 Kb 
tweet!  SAS' Best Kept Secret: Macro Windows for Applications Development
Kay L. Alden 
Keywords: Macro Windows Applications
Pages: 4 Size: 78 Kb 
tweet!  Using Metadata for Data Driven Programming
Brian K. Varney 
Keywords: dictionary tables macro SQL Version 8
Pages: 4 Size: 60 Kb 
tweet!  Table Lookup on the Fly Using SYMPUT and SYMGET 473
John M. Piet 
Keywords: table lookup SYMPUT SYMGET
Pages: 4 Size: 66 Kb 
tweet!  A Case-Transforming Macro for More Readable Text 477
Sylvia C. Tze 
Keywords: MACRO UPCASE LOWCASE TEXT
Pages: 3 Size: 65 Kb 
Best Contributed Paper
tweet!  A Macro Utility for Generating Formatted Log Comments 480
Pete Lund 
Keywords: macro comments
Pages: 4 Size: 129 Kb 
tweet!  My Favorite Functions: Using the SAS Macro Language to Create User-Written Functions
Pete Lund 
Keywords: macro functions
Pages: 3 Size: 97 Kb 
tweet!  Dynamic Dataset Selection and Project Management using SAS 6.12 and the Windows NT 4.0 File System
Matthew T. Downs  Heidi M. Christ-Schmidt 
Keywords: data management dynamic LIBNAME assignment
Pages: 5 Size: 150 Kb 
tweet!  What We Really Need is a %BY Statement - V2
Ray Pass 
Keywords: macro data-driven
Pages: 2 Size: 47 Kb 
tweet!  What Fiscal Year Is This and When Does It Start and End?
Wayne B. Finley 
Keywords: fiscal year shifted interval Y2K INTNX
Pages: 2 Size: 61 Kb 
tweet!  Generating Dates Automatically
Armando V. Fabia 
Keywords: dates INTNX function SYMPUT routine
Pages: 3 Size: 115 Kb 
tweet!  Use of SPEDIS Function in Finding Specific Values
Yefim Gershteyn 
Keywords: SPEDIS FIND VALUE MISSPELLING
Pages: 3 Size: 132 Kb 
tweet!  Advanced SAS String Functions and a Little Recursion Protect Against Run-Time Errors
Amy Roehrig-Swinford 
Keywords: pattern-matching code-checking recursion rxparse rxsubstr
Pages: 3 Size: 102 Kb 
tweet!  The SAS SUBSTR Function - A Beginner's Tutorial
Paul D. McDonald 
Keywords: SUBSTR Parse Character Variables Functions
Pages: 2 Size: 41 Kb 
tweet!  Hidden Nuggets in Version 8: New Informats, Formats, and Functions
Michael D. Rhoads 
Keywords: formats informats functions dates Version 8
Pages: 2 Size: 49 Kb 
tweet!  Office Pooling with SAS Software
Wayne F. Woo 
Keywords: NCAA tournament learning SAS/AF software office pool
Pages: 4 Size: 140 Kb 
tweet!  Let's Play a Game: A SAS Program for Creating a Word Search Matrix
Robert S. Matthews 
Keywords: arrays game
Pages: 4 Size: 58 Kb 
tweet!  Taking Control and Keeping It: Creating and Using Conditionally Executable SAS Code
Justina M. Flavin  Arthur L. Carpenter 
Keywords: conditional execution conditional processing cancel abort endsas errorabend
Pages: 4 Size: 97 Kb 
tweet!  Placing Dates in Your Titles: Do It Dynamically
Arthur L. Carpenter 
Keywords: DATA _NULL_ macro function %SYSFUNC &SYSDATE automatic macro variable
Pages: 3 Size: 92 Kb 
tweet!  Working Efficiently in a Global Environment: Client/Server Processing with SAS/CONNECT Software
Robert W. Graebner 
Keywords: SAS/CONNECT software Client/Server SAS Server Remote Submission
Pages: 3 Size: 110 Kb 
tweet!  Job Control Language and the SAS System for Beginners
Robert J. Nowosielski 
Keywords: JCL CATALOGED Procedure Job Card DD Name PROC CATALOGED
Pages: 3 Size: 104 Kb 
tweet!  Functioning JCL into a SAS Relational Database Table: Your Portable Tutorial on Character Functions, Plus an MVS Batch Bonus
Douglas Zirbel 
Keywords: SAS base JCL OS/390 functions REPORT Titles
Pages: 6 Size: 140 Kb 
tweet!  Intelligently Launching Excel from SAS Software, using SCL
Christopher A. Roper 
Keywords: Excel SCL DDE
Pages: 4 Size: 92 Kb 
tweet!  Using SAS and DDE to Execute VBA Macros in Excel
Christopher A. Roper 
Keywords: DDE VBA Excel macro
Pages: 4 Size: 100 Kb 
tweet!  Calculating Time Intervals Using RETAIN
Denise Gaskins 
Keywords: RETAIN informat
Pages: 2 Size: 65 Kb 
Honorable Mention
tweet!  Transferring Your Mainframe SAS Programs to Your PC in Three Easy Steps
Michael A. Raithel 
Keywords: mainframe SAS programs desktop binary trasfer reusable programs PROC SOURCE
Pages: 3 Size: 97 Kb 
tweet!  Flexibility in Data Management Through the SAS System
Shawn P. Thomas  Brandon L. Welch  Keely P. Casey 
Keywords: Database Libraries Data Management Statistics
Pages: 6 Size: 133 Kb 
tweet!  Smokin' with UNIX Pipes
Kimberly J. LeBouton  Tom Rice 
Keywords: Filename PIPE Filename UNIX
Pages: 4 Size: 170 Kb 
tweet!  PROC REPORT - Land of the Missing OBS Column
Ray Pass 
Keywords: PROC REPORT
Pages: 2 Size: 93 Kb 
tweet!  Removing Duplicates: PROC SQL Can Help You 'See'
Vicki J. Siemers  Brian F. Nash 
Keywords: Duplicates PROC SQL
Pages: 2 Size: 98 Kb 
tweet!  Make Room for Me
Gregory E. Taylor 
Keywords: Macro PROC SQL Dictionary.Tables Dictionary.Columns Charlib1
Pages: 3 Size: 43 Kb 
tweet!  Merges and Joins
Timothy J. Harrington 
Keywords: merge join key sql
Pages: 6 Size: 100 Kb 
tweet!  How to Customize Axes in PROC GPLOT
Izabella Peszek 
Keywords: GPLOT ANNOTATE AXIS
Pages: 3 Size: 75 Kb 
tweet!  Scaling Mount GCHART: Using a MACRO to Dynamically Reset the Scale
Nina L. Werner 
Keywords: MACRO GCHART SQL MAX SAS/ACCESS to Sybase SAS/CONNECT software
Pages: 5 Size: 170 Kb 
tweet!  A Robust Generalized Axis-scaling Macro
Dorothy E. Pugh 
Keywords: axis-scaling graphing macro
Pages: 5 Size: 151 Kb 

SUGI 24   April 11-14, 1999 - Miami Beach, Florida

Coders' Corner

tweet!  Working with Dates in SAS Software
Christine A. Smiley 
Keywords: SAS dates formats informats date constants character/numeric conversion
Pages: 3 Size: 20 Kb 
tweet!  Use PROC SQL to Collapse Cells - It's Easy
Tamara M. Hagemeier  Yue-Hwa C. Chang 
Keywords: SQL Collapsing Cells
Pages: 4 Size: 40 Kb 
tweet!  The Supplement of the COMPARE Procedure
WeiQin Pan 
Keywords: compare &sysinfo
Pages: 6 Size: 36 Kb 
tweet!  Managing SAS Programs
David L. Ward 
Keywords: program organize document
Pages: 3 Size: 41 Kb 
tweet!  Why Not Use SAS/PRESENTS Software Instead...?
Philip R. Holland 
Keywords: PRESENTS EIS
Pages: 3 Size: 30 Kb 
Best Contributed Paper
tweet!  User-Specified Text Flow Inside the Report Procedure
Donald W. Peterson  John R. Gerlach 
Keywords: FLOW flowvar indent split indentation
Pages: 3 Size: 24 Kb 
tweet!  Font Control with the REPORT Procedure
David R. Trenery 
Keywords: REPORT FSREPORT FONT
Pages: 3 Size: 52 Kb 
tweet!  Jazzing up Your Reports - Some Tricks with PROC REPORT
David R. Trenery 
Keywords: PROC REPORT
Pages: 3 Size: 45 Kb 
tweet!  The Power of PAGEOF (A Valuable Page Numbering Macro)
Diane Nicholson  Kelly Felty 
Keywords: PAGEOF macro
Pages: 4 Size: 25 Kb 
tweet!  Customized Pagination Using %PAGEOFNO Macro
Donald W. Peterson 
Keywords: page number pageofno pagefile macro
Pages: 2 Size: 21 Kb 
tweet!  Using Sockets in SAS Software for Internet Publishing
Hsiwei (Michael) Yu  Chapman P. Gleason 
Keywords: socket tcp/ip Perl filename internet
Pages: 3 Size: 22 Kb 
tweet!  SAS/GRAPH Software via RSUBMIT for Web Browser
Hsiwei (Michael) Yu 
Keywords: IntrNet rsubmit alias greplay graph internet
Pages: 2 Size: 16 Kb 
Honorable Mention
tweet!  Managing Your SAS Web Applications by Using Web Page Counters Created Through SAS/IntrNet Software
Heather M. Tavel 
Keywords: SAS/Intrnet htmSQL Application Dispatcher internet web
Pages: 3 Size: 25 Kb 
tweet!  A Macro Tool to Search and Replace Portions of Text
Jennifer M. Lin 
Keywords: Search and Replace Macro INDEX Function UPCASE Function LENGTH Function SUBSTR Function
Pages: 4 Size: 30 Kb 
tweet!  Two Macros to Compute the Median for a List of Variables
Fan Xu 
Keywords: Median Statistics Transpose Procedure Univariate Procedure Array Macro
Pages: 4 Size: 76 Kb 
tweet!  Mini Macros for Major Management of Longitudinal Data
Philip J. d'Almada 
Keywords: macroprocessing quality management data monitoring longitudinal data
Pages: 2 Size: 21 Kb 
tweet!  A Process for Automatically Retrieving Database using ODBC and SAS/ACCESS SQL Procedure Pass-Through Facility
Leiming Li 
Keywords: ODBC SQL Proc edure Pass-Through Facility SAS/Macro
Pages: 4 Size: 58 Kb 
tweet!  Automated Input Interface for SAS Batch-Mode Processing
S. Patrick Thornton 
Keywords: Macro mainframe batch
Pages: 4 Size: 31 Kb 
tweet!  Using SAS Software Windows to Dynamically Manage Your Routine Programs
Linda Gau 
Keywords: %Window
Pages: 4 Size: 15 Kb 
tweet!  Designing User Interface by Using the Macro Facility
Quan Ren 
Keywords: interface window macro
Pages: 2 Size: 18 Kb 
tweet!  Efficiency Techniques: SQL vs. Retain Variables
Danielle Gao 
Keywords: SQL vs. Traditional Programming
Pages: 3 Size: 27 Kb 
Honorable Mention
tweet!  What Sort of Input Should You Input to a Sort?
Michael A. Raithel 
Keywords: PROC SORT Sorting Efficiency Subsetting Data Step View
Pages: 2 Size: 18 Kb 
Best Contributed Paper
tweet!  A Fast Format Macro - How to Quickly Create a Format by Listing the Endpoints
Christine A. Smiley 
Keywords: proc format macros fmtlib option cntlin option
Pages: 4 Size: 23 Kb 
tweet!  PROC FORMAT Provides Efficient Current Descriptions of Codes in Large Tables
Robert M. Romero 
Keywords: format library description code
Pages: 1 Size: 12 Kb 
tweet!  Shortcuts
Janet E. Stuelpner 
Keywords: Variable Lists Numbered Range Named Range
Pages: 2 Size: 15 Kb 
tweet!  The SDQZ-Pipe Technique: Doing More With Less, Faster and Cheaper Reading UNIX-compressed SAS Data Sets Directly in a Data Step
Randy A. Hirscher 
Keywords: UNIX Named Pipes Compression Utility Macro Sequential Format (SDQ)
Pages: 3 Size: 26 Kb 
tweet!  A Simple SAS/AF Program to Manage SAS/CONNECT Sessions
David D. Chapman 
Keywords: SAS/CONNECT SAS/AF
Pages: 5 Size: 118 Kb 
tweet!  Dynamically Creating a Where Statement
Curtis A. Smith 
Keywords: Macro Where Dynamic
Pages: 3 Size: 79 Kb 
tweet!  Using VIEWTABLE in SAS/AF Applications to View and Edit SAS Tables
Kirk P. Lafler 
Keywords: VIEWTABLE SAS/AF SCL Table View Form View
Pages: 2 Size: 12 Kb 
tweet!  Using SAS/AF Software to Create Data Entry Screens with Multiple Comment Fields Allowing for Unlimited Amounts of Text in Each Field
Robert S. Matthews 
Keywords: SAS/AF Frame SCL
Pages: 4 Size: 249 Kb 
tweet!  Delivering Geographic Information Part II: Just Click My Map Object
Jeanne M. Spicer 
Keywords: Map Class SAS/AF
Pages: 4 Size: 76 Kb 
tweet!  Presenting Multi-Level Information in One Plot by Dynamically Generating the PLOT Statement
Li Yuan  Bill Zhang 
Keywords: SAS Macro proc greplay clinical trial
Pages: 4 Size: 86 Kb 
tweet!  Generate Data Listings for a New Drug Application in 5 Minutes as a Part of Automated Report System
Marina V. Kungurtseva 
Keywords: NDA REPORT DATA LISTINGS MACRO
Pages: 7 Size: 92 Kb 
tweet!  Concomitant Medications: What a Programmer Needs to Know
Irving A. Dark 
Keywords: concomitant medicaiton
Pages: 2 Size: 19 Kb 
tweet!  Language Interpretation of Prescription Label Sigs: Computing Daily Consumptions in Medication Compliance Studies
Patty J. Keys 
Keywords: Language interpretation index function link statement compliance study
Pages: 5 Size: 21 Kb 

SUGI 23   March 22-25, 1998 - Nashville, Tennessee

Coders' Corner

tweet!  Dynamically Build a PROC FORMAT for Subsetting Large Datasets
Warren E. Stinson 
Pages: 1 Size: 11 Kb 
tweet!  Advanced Techniques for Creating Format with Variable Values
Erika Liu 
Pages: 3 Size: 21 Kb 
tweet!  IN & OUT of CNTL with PROC FORMAT
Nancy Patton 
Pages: 2 Size: 17 Kb 
tweet!  Using an Enhanced Numeric INFORMAT to Read a Combination of Character and Numeric Data
Ronald Cody 
Pages: 2 Size: 14 Kb 
tweet!  Creating Numeric Formats Based on Precision, Not Magnitude
John R. Gerlach 
Pages: 3 Size: 190 Kb 
tweet!  It's Only Temporary
Janet Stuelpner  Boris Krol 
Pages: 2 Size: 19 Kb 
tweet!  Simplifying Complex Character Comparisons by Using the IN Operator and the Colon (:) Operator Modifier
Paul Grant 
Pages: 2 Size: 23 Kb 
tweet!  Deciphering the _TYPE_ Variable in MEANS and SUMMARY Output Data Sets
Arthur L. Carpenter 
Pages: 3 Size: 25 Kb 
tweet!  Generating Customized Reports Using the INPUT Statements
Jiyuan Wu 
Pages: 3 Size: 40 Kb 
tweet!  Better Titles: Using The #BYVAR and #BYVAL Options
Arthur L. Carpenter 
Pages: 3 Size: 21 Kb 
tweet!  The 'SKIP' Statement
Paul Grant 
Pages: 7 Size: 28 Kb 
Best Contributed Paper
tweet!  What We Really Need is a %By Statement
Ray Pass 
Pages: 2 Size: 14 Kb 
tweet!  Creating a Flexible Parameter Driven Reporting Program Using Global Variables
Karen Dudley 
Pages: 3 Size: 22 Kb 
tweet!  Automatic Referencing SAS Macro Variables Using Array Processing, CALL SYMPUT Routine and DO Loops
Pei-Chun T. Wan 
Keywords: macro array
Pages: 4 Size: 17 Kb 
tweet!  Update A Two-Dimensional Matrix Using The Macro Facility
Jeff F. Sun 
Keywords: macro
Pages: 3 Size: 38 Kb 
tweet!  Generating SAS Source Code with SAS Macros
Robert Graebner 
Keywords: macro
Pages: 2 Size: 19 Kb 
tweet!  A General Purpose Macro to Obtain a List of Files: Plus Macro Programming Techniques
Mel Widawski 
Keywords: macro
Pages: 3 Size: 51 Kb 
tweet!  Taking the Mystery out of SAS Macro When Using CALL SYMPUT
K. Larry Landers  Monique Bryher 
Keywords: macro
Pages: 6 Size: 96 Kb 

SUGI 22   March 16-19, 1997 - San Diego, California

Coders' Corner

tweet!  CALL EXECUTE - How and Why
Ian Whitlock 
Pages: 5 Size: 348 Kb 
tweet!  Subclassing the FRAME Class to Incorporate Documentation Templates and Standard Widgets
Mark Bodt 
Pages: 6 Size: 829 Kb 
tweet!  Some Practical Ways to Use the New SAS Pattern-Matching Functions
Mike Rhoads 
Pages: 4 Size: 27 Kb 
tweet!  Using FTP, Views, and PROC SUMMARY to Analyse Large Databases
Don Stanley 
Pages: 6 Size: 482 Kb 
tweet!  Generating Data with the SAS Data Set
Andrew J. L. Cary 
Pages: 6 Size: 232 Kb 
tweet!  Resolving and Using &&VAR&I Macro Variables
Arthur L. Carpenter 
Keywords: macro
Pages: 4 Size: 17 Kb 
tweet!  Building and Using Macro Variable Lists
Clark Roberts 
Keywords: macro
Pages: 3 Size: 52 Kb 
tweet!  To Subset or Not to Subset
Janet Stuelpner 
Pages: 3 Size: 181 Kb 
tweet!  %ARRAY: Construction and Usage of Arrays of Macro Variables
Ronald Fehd 
Keywords: macro array
Pages: 4 Size: 53 Kb 
tweet!  Skipping, The Easy Way
Janet Stuelpner 
Pages: 2 Size: 138 Kb 
tweet!  Macro and Sample Source Code to Wrap Character Variable Text Conditionally on Two Lines Within Data Null-generated Report Column(s).
Robert Andresen 
Keywords: macro
Pages: 3 Size: 176 Kb 
tweet!  Generic Methodology in Report Building by Using SAS Macros
Irene Zhao 
Keywords: macro
Pages: 5 Size: 283 Kb 
Best Contributed Paper
tweet!  A Macro for Efficient and Flexible Data Smoothing
John Cucka 
Keywords: macro
Pages: 4 Size: 22 Kb 
tweet!  Magic with CALL EXECUTE
Bob Virgile 
Pages: 2 Size: 8 Kb 
tweet!  Techniques for Removing Columns from a SAS Data Set Based on the Contents of the Columns
Clark Roberts 
Pages: 1 Size: 6 Kb 
tweet!  NO MORE MERGE - Alternative Table Lookup Techniques.
Dana Rafiee 
Pages: 6 Size: 272 Kb 
Honorable Mention
tweet!  All the Data That Fits, We Print
Janet Stuelpner  Elizabeth Kaptsanov 
Pages: 3 Size: 157 Kb 
tweet!  Creating Hot-Keys for Data Entry in FSEDIT
Alexa Parliyan 
Pages: 2 Size: 121 Kb 
Honorable Mention
tweet!  Customizing Toolbars
Deb Cassidy 
Pages: 4 Size: 378 Kb 
tweet!  Using SAS Software to Compare Strings of VOLSERS in a JCL Job and a TSO CLIST
Randall M. Nichols 
Pages: 6 Size: 18 Kb 
tweet!  Creating TX and ELIG Formats with Control Data Sets Using the FORMAT Procedure
Frank Liu 
Pages: 2 Size: 109 Kb 
tweet!  An Alternative Method of Transposing Data Without the TRANSPOSE Procedure
Sunil Kumar Gupta 
Pages: 3 Size: 185 Kb 
tweet!  Power Transformations Using SAS/IML Software
Ioannis C. Dimakos 
Pages: 4 Size: 63 Kb 
tweet!  "How Does Your Data Compare?" SAS's COMPARE Procedure
Jenna Heyen 
Pages: 4 Size: 330 Kb 
tweet!  A Grid Overlay to Make SAS/GRAPH Layout Easy.
Ahsan Ullah 
Pages: 3 Size: 33 Kb 
tweet!  Organizing Your SAS Graphs
Steven E. Elkin 
Pages: 2 Size: 154 Kb 
tweet!  Effects of the KEEP, DROP and RENAME Statements and Corresponding Data Set Options
John R Whittington 
Pages: 4 Size: 57 Kb 
tweet!  What Does RETAIN Really Do?
John R Whittington 
Pages: 4 Size: 59 Kb 

SUGI 21   March 10-13, 1996 - Chicago, Illinois

Coders' Corner

tweet!  How to Handle a Hot Date (Fancy and Not So Fancy Date Manipulation with SAS Software)
David Beam 
Pages: 3 Size: 205 Kb 
tweet!  Macros for Calculating Block and Rolling Averages
Randy C. Finch 
Keywords: macro
Pages: 2 Size: 136 Kb 
tweet!  A Simple Way to Create a Clinical Trial Study Data Dictionary
Frank Liu 
Keywords: clinical
Pages: 3 Size: 146 Kb 
tweet!  Program Flow Control in Looping Code Structures
John Whittington 
Pages: 3 Size: 210 Kb 
tweet!  Using Dynamic Data Exchange (DDE) to Pass Data to and from Microsoft Excel Spreadsheets from within the SAS System
Mark Bodt 
Pages: 2 Size: 89 Kb 
tweet!  Enumeration Technique for Efficient Clinical Laboratory Reports
Matthew J. Becker 
Keywords: clinical
Pages: 3 Size: 153 Kb 
tweet!  Using Dynamic Data Exchange (DDE) to Pass Data to Microsoft Word Documents from within the SAS System
Mark Bodt 
Pages: 2 Size: 133 Kb 
tweet!  Using the REPORT Procedure in a Batch Environment: Dealing with Format Limitations and RAM Requirements
Michael Marzano 
Pages: 3 Size: 170 Kb 
tweet!  Using a SAS Data Set to Expand the Program Data Vector
Ian Whitlock 
Pages: 2 Size: 99 Kb 
tweet!  A Macro to Word Wrap Long Text Strings into a SAS Array
Ian Whitlock 
Keywords: macro array
tweet!  More Informative Scatter Plots -Adding a Third Dimension with Bubbles
Frank Kucera 
Pages: 2 Size: 110 Kb 
tweet!  Two Ways Non-Experts Can Profitably Use PROC REPORT
Michael D. Rhoads 
Pages: 3 Size: 215 Kb 
tweet!  Some Not Widely Known or Sometimes Poorly Understood Features of Base SAS Software
John Whittington 
Pages: 3 Size: 195 Kb 
Powered by SAS®.
SUGI and SAS Global Forum Proceedings are copyrighted to SAS Institute Inc. All rights are reserved.
Any unauthorized reproductions are prohibited.
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-2016 Lex Jansen. All rights reserved.