Washington, DC SAS Users Group

Program Materials

2011 Fourth Quarter Meeting

• Andrew Karp, Sierra Information Services
  PROC MEANS: The Basics & Beyond
  • View the slides

2011 Third Quarter Meeting

• Kirk Paul Lafler, Software Intelligence Corporation
  What's Hot, What's Not: Skills for SAS^® Professionals
  • Read the paper
• Kirk Paul Lafler, Software Intelligence Corporation
  Exploring Powerful Features in PROC SQL^®
  • Read the paper

2011 Second Quarter Meeting

• Allison Booth, SAS Institute
  The REPORT Procedure: Getting Started with the Basics
  • See the paper
• Allison Booth, SAS Institute
  Evolve from a Carpenter’s Apprentice to a Master Woodworker: Creating a Plan for Your Reports and Avoiding Common Pitfalls in REPORT Procedure Coding
  • See the paper
• Allison also passed along some additional valuable links for PROC REPORT and ODS. She wrote:
  • This is a PROC REPORT Tips and Tricks paper from the 2007 SAS Global Forum.
  • This is a PROC REPORT Tips and Tricks paper updated for SAS 9.2 from the 2011 SAS Global Forum.
  • This is an ODS style element for PROC REPORT and PROC TABULATE paper.
  • For ODS users, here is a great starting point for SAS Notes and Concepts for ODS.

2010 Fourth Quarter Meeting

• Andrew Karp, Sierra Information
  My Friend the SAS^® Format
  • See the presentation slides
• Andrew Karp, Sierra Information
  SAS^® Formats: Beyond the Basics
  • See the presentation slides

2010 Third Quarter Meeting

• Cynthia Zender, SAS Institute
  Getting Started with ODS
  • See the presentation slides
• Cynthia Zender, SAS Institute
  The ODS Graphics Facility
  • See the presentation slides
• Cynthia Zender, SAS Institute
  ODS Options and SAS^® Stored Processes
  • Read the paper
  • See the presentation slides

2010 Second Quarter Meeting

• Kirk Paul Lafler, Software Intelligence Corporation
  DATA Step and PROC SQL Programming Techniques
  • Read the paper
  • View the presentation slides
• Kirk Paul Lafler, Software Intelligence Corporation
  Building Effective SAS^® Indexes using Short and Distinct Keys, Covered Queries and Clustered Indexes
  • Read the paper
  • View the presentation slides
• Kirk Paul Lafler, Software Intelligence Corporation
  Hard-to-find and Powerful PROC SQL^® Features
  • Read the paper
  • View the presentation slides

2010 First Quarter Meeting

• Bruce Gilsen, Federal Reserve Board
  SAS Code and Macros: How They Interact
  • Read the paper
  • See the presentation slides (revised 3 March 2010 and posted here 14 March 2010)
• Ed Heaton, Data & Analytic Solutions, Inc., and Sarah Woodruff, Westat
  Implementing User-Friendly Macro Systems
  • Read the paper

2009 Fourth Quarter Meeting

• Andrew Karp, Sierra Information Services
  Exploiting the Excellent ExcelXP Tagset: SAS to Excel in a Snap!
  • Handout(s)
• Andrew Karp, Sierra Information Services
  Time Series Magic: Using PROC EXPAND with Time Series Data
  • Handout(s)

2009 Second Quarter Meeting

• Bruce Gilsen, Federal Reserve Board
  This is the Modern World: Simple, Overlooked SAS^® Enhancements

  After the June 2nd presentation to DCSUG, Bruce revised both the paper and the slides to incorporate suggestions from the audience. These are the revised materials.

  • Read the paper
  • Read the presentation slides
• Stephanie Thompson, Rochester Institute of Technology
  Four Thousand Reports Three Ways
  • File package (.ZIP) including the paper, slides, code, and sample output

2008 Fourth Quarter Meeting

• Bob Rodriguez, SAS
  Getting Started with ODS Statistical Graphics in SAS^® 9.2
  • Read the paper
• Bob Rodriguez, SAS
  An Introduction to SAS Stat Studio
  • Read Rick Wicklin's paper
• Bob Rodriguez, SAS
  Overview of Bayesian Computing in SAS/STAT^® 9.2
  • See the documentation

2008 Second Quarter Meeting

• Anastasiya Osborne, Farm Service Agency (USDA)
  Tricks to Quickly Analyze and Graphically Represent Numeric Data
  • View slides online
  • Read paper
• Michael Raithel, Westat
  Supporting SAS in a Research Organization
  • Read paper

2008 First Quarter Meeting

• Doug McAllaster, Office of the Assistant Secretary of Defense (Health Affairs)
  PROC FORMAT: Basics, "Power" Practices, and a WHERE Warning
  • View slides (PDF)
• Gary Schlegelmilch, U.S. Citizenship and Immigration Services
  The SAS® Community: How to Be a Part of It!
  • View slides online
• Chris Zogby, Zogby Enterprises, Inc.
  A User-Written DI Studio Transform That Collects Primary Key Values From An Oracle Sequence
  • View slides online

2007 Fourth Quarter Meeting

• Andrew Karp, Sierra Information Services
  Getting the Most from PROC MEANS
  • Download paper (PDF)
• Mike Molter, PPD Inc.
  Tips and Tricks for Creating the Reports Your Clients Need to See
  • View slides (PDF)

Special Evening Meeting, Sept. 2007

• Andrew Karp, Sierra Information Services
  Essential Concepts of the SAS Output Delivery System (ODS)
  • View slides (PDF)
• Susan Tian, Social & Scientific Systems, Inc.
  %DO Loop - a Simple Dynamic Programming Technique and The Power and the Danger of Automatic Retain
  • Download %DO paper (PDF)
  • Download RETAIN paper (PDF)
• Suzanne Dorinski, US Census Bureau
  A Lazy Programmer Case Study: Dynamic Macro Code To Deal With Changing Numbers Of Variables Over Time
  • Download paper (PDF)

2007 Third Quarter Meeting

• Mike Rhoads, Westat
  New Version 9 Tools for Your SAS Toolkit
  • View slides online
• Howard Schreier, Howles Informatics
  Finding Answers in the PROC SQL Documentation
  • Download paper (PDF)
  • View slides online

2007 First Quarter Meeting

• Ed Heaton, Westat
  Top-Down Programming with SAS Macro
  • Download paper (PDF)
  • View slides online

2006 Fourth Quarter Meeting

• Andrew Karp, Sierra Information Services
  Getting Un-Stuck in the Traffic-Lighting
  • Download slides (PDF)
• Chevell Parker, SAS Institute
  Now - That's Your Style!!!!!
  • Download paper

2006 Third Quarter Meeting

• Laurie Hamilton, U.S. Government Accountability Office
  U.S. Census Gazetteer Data and ArcView Geocoding Software for Medicare Fraud Screening
  • Download paper
  • View slides
• Dianne Louise Rhodes, Bureau of Labor Statistics
  Pretty Dates All in a Row
  • Download paper

2006 Second Quarter Meeting

• Bruce Gilsen, Federal Reserve Board
  Tales from the Help Desk 3: More Solutions for Simple SAS® Mistakes
  • Download paper
  • View slides
• Roger Goodwin, U.S. Dept. of Agriculture
  Using PROC TRANSPOSE
  • View slides

2006 First Quarter Meeting

• Howard Schreier, Howles Informatics
  SQL Set Operators: So Handy Venn You Need Them
  • Download paper
  • View slides

2005 Fourth Quarter Meeting

• Vincent DelGobbo, SAS Institute
  Moving Data and Analytical Results between SAS and Microsoft Office
  • Download paper
  • Download archive (ZIP; 4.8 MB), including paper, annotated slides, code, and several earlier papers
• Steve Feder, Federal Reserve Board
  Reporting and Interacting with Excel® spreadsheets with ODS® and DDE
  • Download paper (PDF)
• Andrew Karp, Sierra Information Services
  Getting in to the PICTURE (Format)
  This was a work in progress when presented to DCSUG. However, Andrew makes his papers available on the Sierra web site, so this paper will eventually appear there in finished form.

2005 Third Quarter Meeting

• John Davison, Factotum, Inc.
  Systematic SAS Development, a Disciplined Approach
  • View slides online
  • Download paper (PDF)
• Ronald Fehd, Centers for Disease Control and Prevention,
  A SASautos Companion: Reusing Macros
  • Download paper (PDF)

2005 First Quarter Meeting

• Mike Rhoads, Westat
  Starts and Stops: Processing Episode Data With Beginning and Ending Dates
  • Download slides for printing (PDF; 1+ MB)
  • Download paper (PDF)
• Roger Goodwin, U.S. Department of Agriculture
  PROC SURVEYMEANS
  • View slides online
  • Download paper (PDF)

2004 Fourth Quarter Meeting

• Diane Olson, SAS
  PROC MIGRATE: How to Migrate Your Data and Know You’ve Done It Right
  • View slides online, with speaker notes
  • Get more information on this topic from the Migration Community on the SAS web site
• Chris Zogby, Zogby Enterprises, Inc.
  Query-Based SQL Updates Using Correlated Subqueries
  • View slides online

2004 Third Quarter Meeting

• Bruce Gilsen, Federal Reserve Board
  More Tales from the Help Desk: Solutions for Simple SAS Mistakes
  • Download paper (PDF)
• Frank DiIorio , CodeCrafters Inc.
  The SAS Debugging Primer
  • Download slides for printing (PDF)
  • Download paper (PDF)
  Frank also welcomes visitors to the CodeCrafters site, where they can find more of his papers and presentations.

2004 First Quarter Meeting

• Michael Davis, Bassett Consulting Services
  You Could Look It Up: An Introduction to SASHELP Dictionary Views
  • Download paper (PDF)
  • Download slides for printing (PDF)
• Marianne Whitlock
  Self-adjusting Date Formats
  • Download slides for printing (PDF)
  • View slides online
• Ian Whitlock
  
  • Missing Secrets
    • Download slides for printing (PDF)
    • View slides online
  • Selected Topics from the DATA Step
    • Download slides for printing (PDF)
    • View slides online

2003 Fourth Quarter Meeting

• Andrew Karp,, Sierra Information Services, Inc.
  A Peek at PROC DOCUMENT
  • Download slides for printing (PDF)
• Bob Rodriguez,, SAS Institute
  Statistical Graphics Using ODS in SAS 9.1
  • Material on the SAS Statistics & Operations Research Community web site

2003 Second Quarter Meeting

• Edward E. Heaton, Westat
  SAS^® System Options Are Your Friends
  • Download paper (PDF; 306 KB) from SUGI 28 Proceedings
• John McCue, Congressional Research Service
  Construction Secrets Learned Building a Government Information Factory (Foundation)
  • View notes
• Howard Schreier, U.S. Department of Commerce
  Ask and Ye Shall Receive: Getting the Most from SAS-L
  • Download slides for printing (PDF)
  • View slides online

2003 First Quarter Meeting

• Roger Goodwin , U.S. Bureau of the Census
  Developing SAS^® Software for Generating a Complete Set of Ratio Edits
  • Download slides for printing
  • Download application package (code and documentation; 567 KB)
• David Chapman, U.S. Bureau of the Census
  Using PROC REPORT To Produce Tables With Cumulative Totals and Row Differences
  • Download paper (PDF; 132 KB) from SUGI 27 Proceedings
  • Download demo code
• Christopher Zogby, Zogby Enterprises, Inc.
  Proc SQL Tips: Conditional Logic, Macro Variables and Subqueries
  • Download slides for printing (PDF)
  • View slides online

2002 Fourth Quarter Meeting

• David Shamlin, SAS
  V9 Nuts & Bolts
  • Download slides for printing (NOTE! - 2.8 MB PDF)
  • View slides online

2002 Third Quarter Meeting

• Peter Knapp, U.S. Department of Commerce
  Debugging 101
  • Download paper (PDF)
  • View slides online
• Ian Whitlock, Westat
  SAS Macro Design Issues
  • Download slides for printing (PDF)
  • View slides online

2002 Second Quarter Meeting

• Ray Pass, Ray Pass Consulting
  PROC REPORT: Doin’ It in Style!
  • Download paper (PDF, 307k)
  • Download package (paper and demo files; ZIP, 296k)
• Ray Pass, Ray Pass Consulting
  PROC TABULATE: Doin’ It in Style!
  • Download paper (PDF, 205k)
  • Download package (paper and demo files; ZIP, 201k)

2002 First Quarter Meeting

• Veronica Y. Rath, INDUS Corporation
  How to Change the Template and Table of Contents for SAS Web Applications
  • Download paper (PDF, 174k)
• Andrew H. Karp, Sierra Information Services, Inc.
  Using MULTILABEL Formats in SAS Version 8
  • Download paper (PDF, 293k)

2001 Third Quarter Meeting

• Ray Pass, Ray Pass Consulting
  I'll Have the TABULATEs a la ODS Please, With a Table of Contents On the Side
  • Download paper (PDF, 311k)

2001 Second Quarter Meeting

• Bruce Gilsen and Scott Hoenig, Federal Reserve Board
  SAS ® User Support: Simple, Effective Web Page Design
  • Download paper (PDF, 195k)

2001 First Quarter Meeting

• Larry Altmayer, U.S. Census Bureau
  CONNECTing with SAS Version 8 : Virtually Transparent to the User
  • View slides online
  • Download slides (PDF, 290k)
• Mike Rhoads, Westat
  Hidden Nuggets in Version 8: New Informats, Formats, and Functions
  • Download paper (PDF)
• Chris Zogby, Zogby Enterprises
  Object Oriented Programming Using SAS/AF Software: An Electronic Mail Class Example
  • View slides online
  • Download slides (PDF, 359k)

2000 Fourth Quarter Meeting

• Andrew H. Karp, Sierra Information Services, Inc.
  Changes and Enhancements to PROCs MEANS/SUMMARY in Version 8 of the SAS ® System
  • Download slides (PDF, 122k)

DCSUG Home