SESUG Proceedings 2000

These Proceedings are the official record of the 8th Annual SouthEast SAS Users Group (SESUG) Conference held in Charlotte, NC on October 14 – 17, 2000 at the Adams Mark. Neither SAS Institute Inc. nor SESUG is responsible for the accuracy or originality of this material.

The correct bibliographic citation for this publication is as follows:

SESUG 2000: The Proceedings of the SouthEast SAS Users Group, Charlotte, NC, 2000

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. ® indicates USA registration. Other brand and product names are trademarks of their respective companies.

Copyright © 2000 by the SouthEast SAS Users Group.

Published in the USA

Papers are made available by the Institute for Advanced Analytics as a courtesy to the SESUG community.

Advanced Tutorials

A Join for All Seasons, Caroline Bahler

XML and SAS: An Advanced Tutorial, Greg Barnes Nelson

The Utter “Simplicity?” of the TABULATE Procedure-The Final Chapter?, Dan Bruns

Writing the “Best” Program: The How and When of Efficient Programming, Frank DiIorio

Table Lookup via Direct Addressing: Key-Indexing, Bitmapping, Hashing, Paul M. Dorfman

DATA CLEANING: Preemptive Techniques, Mal Foley

Integrity Constraints and Audit Trails Working Together, Gary Franklin

You CAN Get There from Here (and Back Again): Adding Hot-link Drill-down Capabilities to ODS HTML Output, Ray Pass

Data Mining: An Overview of Methods and Technologies for Increasing Profits in Direct Marketing, C. Olivia Rud

Data Structure Determines Programming Effort, Ian Whitlock

Applications Development

Accessing FPL’s Data Warehouse Using SAS/ACCESS SQL Procedure Pass-Through Facility, Guillermo (Bill) Anton

Using DDE with Microsoft EXCEL and SAS to Collect Data from Hundreds of Users, Russell Denslow and Yan Li

Organizing Ultra-Quick Disk Table Lookup via Hybrid Indexing into a Directly Addressed SAS Data Set, Paul M. Dorfman

Using SAS/AF to Create Applications for Looking Up and Coding Adverse Events and Generic Drug Names in Clinical Trials, Karen B. Fowler and Emily A. Mixon

The Use of SAS in Revenue Management and Related Applications at ANC Rental Corporation, Chi Ip

The Dead Go Live! Injury Mortality Data via an Interactive Web-Application, Stephen P. James

SAS Macros Are the Cure for Quality Control Pains: Implementing a Macro Driven Evaluation of Survey Data for Quality Control, Gary M McQuown

A SAS/AF Application for Linking Demographic & Laboratory Data for Participants in Clinical & Epidemiologic Research Studies, Emily A. Mixon and Karen B. Fowler

Put Your Reports on the Web!!, Jim Nash

I’ll Have the TABULATEs a la ODS Please, With a Table of Contents On the Side, Ray Pass

Workflow on the Web: Using SAS/IntrNet to build an application for Dynamic Web Reporting, Deborah K. Pine and Gregory S. Barnes Nelson

A High-Level Summary Table Generation Language Supplying the Missing Link Between PROC MEANS Using a CLASS Statement and PROC TABULATE, Dorothy Pugh

Walk Our Children to School: An Internet Data Management Application, Carol A. Martell

Beginning Tutorials

Meta Data – Everyone Talks About It, but What Is It?, John E. Bentley

Here’s the Data, Here’s the Report I Want – How Do I Get There?, Debbie Buck

The Power of PROC DATASETS, Lisa M. Davis

You Could Look It Up: An Introduction to SASHELP Dictionary Views, Michael L. Davis

Introduction in Efficient SAS Programming via Incremental Refinement by Example, Paul M. Dorfman

Customize Your SAS Output with the Template Procedure: A Beginning Tutorial, Carol Gosselin and Joy Munk Smith

How to Incorporate Old SAS Data into a new DATA Step, or “What is S-M-U?”, Andrew T. Kuligowski

SAS Software Macros – You’re Only Limited by Your Imagination, Peter Parker

How to Use the Data Step Debugger, S. David Riba

Static SAS Web Publishing (SAS/IntrNet @ Social Work), Roderick A. Rose

SAS as a Utility Language: Using SAS for Solving Little Problems, Gary E. Schlegelmich

Ten Things You Should Know about PROC FORMAT, Jack N. Shoemaker

Maps: Where We Were and Where We Are, Clara L. Waterman

Coder’s Corner

%XTAB2HTM: Macro Using ODS to Convert PROC FREQ Cross-tabulation to HTML with a Table of Contents and Back Buttons, Ron Fehd

The Variable List Wildcard Character, Mal Foley

Mailing List Management, Imelda C. Go

Random Sample Selection, Imelda C. Go

Using SAS to Write SAS – Automate Your Programming Tasks, Pam Reading

Web-Application Bar-Charts without SAS/Graph, Steve James

Add Common Look and Feel to Your Web Applications Easily, Steve James

Generating a Table of Seeds for Random Number Generator, F. Joseph Kelley

A Macro to Center Text in a DATA _NULL_ Step, Erik S. Larsen

Using Proc Compare for Data Reliability, Sharon Stroud

Macro Design Considerations for a Word Wrapping Macro, Ian Whitlock

A Robust Generalized Axis-scaling SAS Macro, Dorothy E. Pugh

Panel Discussion on Problem Solving, Steve Noga, Frank C. DiIorio, Paul M. Dorfman, Ian Whitlock

Emerging Technologies

Using Data Mining Technology to Identify and Prioritize Emerging Opportunities for Mortgage Lending to Homeownership-Deficient Communities, Clark R. Abrahams, Frank R. Burnett and Jin-Whan Jung

Emerging Technologies Roadmap – A Decision Tree Guide to Understanding SAS Strengths, Greg Barnes Nelson and Eric Brinsfield

Extending the Data Warehouse: An Introduction to OLE DB, S. David Riba

Enterprise Integration Technologies – What is it, and What can it do for me?, Scott Vodicka

Information Visualization

ABC’s of Graphs in Version 8, Caroline Bahler

Dead Graphs – RIP (How Interactive Graphical EDA Techniques Can Markedly Enhance the Analysis/Display of Our Data), Dave DesJardins

Identifying Time Series Models, David A. Dickey

Using JMP version 4 Time Series Features to Analyze Passenger Demand Data and Closing Stock Prices, Bill Gjertsen

Laptop Demo of a “Browseable” Statistical Package, John Iwaniszek and George DeMuth

Data Mining Beyond the Observable: Underlying Construct Analysis (UCA), Alvin L. Killough, Donald W. Drewes and Christopher L. Edwards

A Dynamic Imagemap Generator, Carol A. Martell

Professional Development and User Support

Test Development: Ten Steps to a Valid and Reliable Certification Exam, Linda A. Althouse

Effective SAS User Support: Utilize the Power of the Intranet, Lisa Davis

Teaching SAS Web Publishing in a Web Environment, Roderick Rose and Sally Muller

How to Get the Online Information You Need: An Overview of “What’s Where” for SAS System Help, SAS Online Doc, SAS Online Tutor, and the Web, Judi Rourke-O’Briant

SAS Solutions

Implementing a Balanced Scorecard Solution on Top of SAP, using CFO Vision as an Interface, Christ D’haeveloose

Using SAS/IntrNet to Track the Impact of Welfare Reform in North Carolina, Dean F. Duncan, Kimberly A. Flair, Rosemary D. Hallberg, Sally S. Muller and Hye-Chung (Monica) Kum

Building Systems of Macros: The Print System and The Macro Reporting System (MRS), John Iwaniszek and George DeMuth

Integrating SAS in Corporate IT, John M. LaBore and Thomas H. Burger

Positioning SAS for Corporate Effectiveness, John M. LaBore and Thomas H. Burger

SAS & HEDIS: An Introductory Overview, Christopher J. Plummer

The Power of Hybrid OLAP in a Multidimensional World, Ann Weinberger

Statistics

A SAS Program for the Computation of Seroconversion Rates in a Prospective Study of HIV Discordant Couples in Lusaka, Zambia, Ilene Brill, Maurizio Macaluso, Susan Allen and Jareen K. Meinzen-Derr

SAS IML Code To Calculate an Upper Confidence Limit for Multivariate Statistical Distance, Margaret Connolly

Performing Exact Logistic Regression with the SAS System, Bob Derr

Computing the Approximate and Exact Leaving-One-Out Method in Multiple Group Logistic Discrimination with the SAS System, Mohamed H. Hussein

Macro in Scoring, Jukui Yi

Exploratory Data Analysis using PROC UNIVARIATE, Robert Maitland

Computation of p-values for Multiple Comparisons with a Control in the SAS System, Jean G. Orelien

Can A New Interpretation Of Survival Data Help Patients Successfully Modify Adverse Risk Profiles?, Gregory L. Pearce

Using The SAS System To Examine The Effect Of Augmentation On The Inter-Rater Reliability Of Holistic Ratings, Jim Penny, Robert L. Johnson and Belita Gordon

Using The SAS System To Examine The Reliability Of The Retrospective Measure Of Change, Jim Penny, Jennifer Martineau and Robert L. Johnson

Using the SAS System and QSR NUD*IST for Qualitative Data Analysis (QDA), Robert G. Stewart

Using SAS to Perform Robust I-Sample Analysis of Means Type Randomization Tests for Variances, Peter S. Wludyka

System’s Architecture

Multi-Process Connect; What, When, Where, How, and Why, John E. Bentley

Think Thin 2-D: “Reduced Structure” Database Architecture, Sigurd W. Hermansen

You can do THAT with SAS Software? – Using the Socket Access Method to Unite SAS with the Internet, David L. Ward