Colorado Day

1. Colorado Day Thursday, 9/13/07

2. Theresa Stemler – SAS “Funny ^Stuff~ in My Code: Using ODS ESCAPECHAR” Have you ever wanted to insert a superscript or subscript into your SAS output? Or, have you ever needed to make one part of a text string bold or a different color? Do you wonder how to get RTF or PDF output to have Page X of Y page numbering in a footnote? This paper will introduce you to the wonders of ODS ESCAPECHAR. It will show how to define and then use a specific escape character to perform in-line formatting. Highlight #1

3. Highlight #2 • Art Carpenter – California Occidental Consultants • Using SAS since 1976 • Three books: “Carpenter’s Complete Guide to the SAS Macro Language, 2nd Edition”, “Quick Results with SAS/GRAPH® Software”, “Annotate: Simply the Basics” • Presented over four dozen papers and posters which have been presented worldwide including at SUGI, PharmaSUG, and WUSS. • Conference Chair at the SAS User's Group International conference, SUGI. Art is currently an active member of the SUGI Executive Committee.

4. Class Opportunities Tuesday, 9/11 - Basic Macros • For the SAS programmer who is new to the Macro Language. • How the Macro Language works • What the Macro Symbol Table is and how to values stored in it • How the SAS System uses Macro Variables • Key Macro Language concepts • Important SAS Macro Language Functions • How to invoke Macros in your programs • Should have a basic understanding of the Data Step and Procedure Steps • Also suitable for SAS users who want to understand the Macros found in programs they have "inherited" from other programmers.

5. Class Opportunities (cont.) Wednesday, 9/12 - Advanced Techniques in the SAS® Macro Language • Designed for students with a good understanding of the DATA and PROC steps and who already understand the basic structure and syntax of the SAS Macro Language. • Short review of the macro basics and quickly move on topics selected to improve your macro language expertise. • Macro Language Review • Macro Functions, Using and Creating • Writing Dynamic Code • Controlling Your Environment • Working With SAS Data Sets • SAS Macro Libraries • Miscellaneous Macro Topics

6. How the classes work • Add-ons to Colorado Day, so must register for Colorado Day to take classes • Additional $190 for EACH class • Additional $35 “Carpenter’s Complete Guide to the Macro Language, 2nd Edition” book (For those taking either macro class. Note this is 30% below retail.)

7. What do you want to hear about? • List of about 30 available presentations • Proc report • Macros • SAS Graph

8. 50 Tutorial PROC REPORT Basics: Getting Started with the Primary Statements50 Advanced PROC REPORT: Getting Your Tables Connected Using Links50 Advanced PROC REPORT: Doing More in the Compute Block20 Data Presentation In The Compute Block: Issues Associated with Using and Naming Variables50 Tutorial Advanced PROC REPORT: Traffic Lighting - Controlling Cell Attributes With Your Data50 SAS Programmer’s Challenge 03 - Its All about Options (presentation only)50 SAS Programmer’s Challenge 02 (presentation only)50 Technical Techniques SAS Programmer’s Challenge 01 (presentation only)50 Tutorial Extreme Graphics Make Over: Using SAS/GRAPH® to get the Graphical Output You Need20 Data Presentation Is your picture worth a thousand words? Creating Effective Presentations with SAS/GRAPH®20 Data Presentation Is the Legend in your SAS/GRAPH® Output Telling the Right Story?20 Data Presentation Controlling Graph Size: Building Thumbnails and GIF Files Using SAS/GRAPH®50 Tutorial Looking for a Date? A Tutorial on Using SAS® Dates and Times10 Coders Corner Storing and Using a List of Values in a Macro Variable20 Technical Techniques Job Security: Using the SAS® Macro Language to Full Advantage50 Tutorial Using Macro Functions50 Tutorial Five Ways to Create Macro Variables: A Short Introduction to the Macro Language50 Tutorial SAS Macro: Symbols of Frustration? %Let Us Help? A Guide to Debugging Macros.50 Tutorial Building and Using Macro Libraries20 Technical Techniques Make ‘em %LOCAL: Avoiding Macro Variable Collisions50 Tutorial Table Lookups: From IF-THEN to Key-Indexing50 Technical Techniques Programming for Job Security Revisited: Even More Tips and Techniques to Maximize Your Indispensability20 Technical Techniques Taking Control and Keeping It: Creating and Using Conditionally Executable SAS® Code

9. Why should I present? • Opportunity to sharpen your presentation skills • Network with other programmers on your topic • Speakers allowed to waive the conference fee and attend for their $30 dues renewal. • Fame, glory, adoration of your peers

10. One page abstracts should be submitted to Brenda Beaty by email (Brenda.Beaty@UCHSC.edu) and should include presentation title, intended audience (beginner/intermediate/ advanced), length of presentation (15, 30, or 45 minutes), description of the presentation, and requirements for audio-visual equipment. Deadline for abstracts is August 10, 2007 and you will receive an e-mail confirmation of your acceptance. How do I submit?

11. Ideas for topics • Most recent project you ‘got lost’ in • Pick a PROC, any PROC • Something you’re going to have to learn anyway • Something new in SAS 9™

12. “Typical” Topics (WUSS, 2004) Coders Corner The Automatic Detection of Problems in the SAS Log Comparing Two SAS Datasets: Start at the Top Creating HTML Output with Output Delivery System Dynamic Format & %LET Macro to Match Data from External Data Sources Macro Arrays for Programming Fun Making Code Review Painless Storing and Using a List of Values in a Macro Variable Tips for Creating Portable Document Format (PDF) Graphics Output Unix Comes to the Rescue: A Comparison between PC SAS and UNIX SAS UNIX Users: See Output of a PROC CONTENTS or PROC PRINT with a Single Command! Techniques and Methods to Implement Neural Networks in SAS Creating Efficient SQL : Four Steps to a Quick Query

13. “Typical” Topics (WUSS, 2004) Data Analysis and Statistics Beyond Binary Outcomes: PROC LOGISTIC to Model Ordinal and Nominal Dependent Variables The Continuing Quandary of Survey Data Part II: Comparison of SAS Survey Procedures and SUDAAN® Procedures Cut Out the Cut And Paste: SAS Macros For Presenting Statistical Output Package, Archive, Report and Test Statistical Models Using ODS Parameterizing Models to Test the Hypotheses You Want: Coding Indicator Variables and Modified Continuous Variables PROC GENMOD for Analysis of Correlated Outcome Data Using the LOGIT Link Function Using SAS’s Correspondence Analysis Procedure to Classify Homicides A System to Calculate Market Value-at-Risk Using Oracle® and Monte Carlo Simulation in SAS/IML Calculating Exact Power and Sample Size for Hotelling's T-test and Relating Multivariate Procedures A SAS Macro to Calculate Standardized Cronbach’s alpha Using Upper Bound Phi Coefficient for Dichotomous Items Empirical Investigation of Time Series Frequency Conversion with PROC EXPAND Using Classification Tree Outcomes to Enhance Logistic Regression Models

14. “Typical” Topics (WUSS, 2004) Data Presentation Contrasting Programming Techniques for Summarizing Voluminous SAS Output Using the SAS Output Delivery System (ODS) (PROC FREQ as an example) Design Principles for Online Information: Readability, Usability, and Accessibility Getting Un-stuck in Traffic-lighting Is Your Picture Worth a Thousand Words? Master/Detail Reporting in Base SAS Using Microsoft Excel for Data Presentation V8 Is Seen in Rearview Mirror – Generate Statistical Graphics Using ODS in SAS 9 How To Get Ten Pounds Of Data Into A Five Pound Can - Using Flyover Technique in HTML Output Creating Custom Tables Using SAS

15. Logistics • Registration open now – form available at: www.denversug.org – email to me ASAP • $70 Early Registration (before 8/13 – includes conference and $30 annual dues) • $85 Registration (on or after 8/13 – includes conference and $30 annual dues) • DSUG is not set up for credit cards

16. Get involved • Stick around after the meeting • Or let anyone on the Steering Committee know – all of our contact info is on the website • Thanks and see you in September!!!