Colorado day
1 / 16

- PowerPoint PPT Presentation

  • Updated On :

Colorado Day. Thursday, 9/13/07. Theresa Stemler – SAS “Funny ^Stuff~ in My Code: Using ODS ESCAPECHAR”

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about '' - loe

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Colorado day

Colorado Day



Highlight 1

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

Highlight 2
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.

Class opportunities
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.

Class opportunities cont
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

How the classes work
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.)

What do you want to hear about
What do you want to hear about?

  • List of about 30 available presentations

  • Proc report

  • Macros

  • SAS Graph

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

Why should i present
Why should I present? Primary Statements

  • 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

How do i submit

One page abstracts should be submitted to Brenda Beaty by email ([email protected]) 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?

Ideas for topics
Ideas for topics email (

  • 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™

Typical topics wuss 2004

“Typical” Topics (WUSS, 2004) email (

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

Typical topics wuss 20041

“Typical” Topics (WUSS, 2004) email (

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

Typical topics wuss 20042

“Typical” Topics (WUSS, 2004) email (

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

Logistics email (

  • Registration open now – form available at: – 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

Get involved
Get involved email (

  • 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!!!