SESUG2000
Conference Papers

Subsections

General Session

It's A Brand New eWorld!
Jay Stevens, Whitehurst Associates, Inc., Atlanta, GA

Advanced Tutorials

A Join for All Seasons
Caroline Bahler, Meridian Software, Inc., Raleigh, NC

XML and SAS: An Advanced Tutorial
Gregory S. Barnes Nelson, STATPROBE Technologies, Cary, NC

The Utter "Simplicity?" of the TABULATE Procedure - The Final Chapter?
(Abstract Only)
Dan Bruns, Tennessee Valley Authority, Chattanooga, TN

Writing the "Best" Program: The How and When of Efficient Programming
(Abstract Only)
Frank C. DiIorio, AIMS, Co., Durham, NC

Table Lookup via Direct Addressing: Key-Indexing, Bitmapping, Hashing
Paul M. Dorfman, Citibank Universal Card, Jacksonville, FL

DATA CLEANING: Preemptive Techniques
Malachy J. Foley, UNC-Chapel Hill, Chapel Hill, NC

Integrity Constraints and Audit Trails Working Together
Gary Franklin, SAS, Austin, TX
Art Jensen, SAS, Englewood, CO

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

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

Data Structure Determines Programming Effort
Ian Whitlock, Westat, Rockville, MD

Applications Development

Accessing FPL's Data Warehouse Using SAS/ACCESS SQL Procedure Pass-Through Facility
Guillermo (Bill) Anton, Florida Power and Light, Miami, FL

Using DDE with Microsoft Excel and SAS to Collect Data from Hundreds of Users
Russell Denslow, Sodexho Marriott Services, Orlando, FL
Yan Li, Sodexho Marriott Services, Orlando, FL

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

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

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

The Dead Go Live! Injury Mortality Data via a Web-based Application
Steve James, Centers for Disease Control and Prevention, Atlanta, GA

SAS Macros Are the Cure for Quality Control Pains: Implementing A Macro Driven Evaluation of Survey Data for Quality Control
Gary M. McQuown, Data and Analytic Solutions, Fairfax, VA

A SAS/AF Application for Linking Demographic & Laboratory Data for Participants in Clinical & Epidemiologic Research Studies
Emily A. Mixon, UAB Department of Pediatrics, Birmingham, AL
Karen B. Fowler, UAB Department of Pediatrics, Birmingham, AL

Put Your Reports on a Web Page
Jim Nash, Bank of America, Jacksonville, FL

I'll Have the TABULATEs a la ODS Please, With a Table of Contents On the Side
Ray Pass, Ray Pass Consulting, Hartsdale, NY

Workflow on the Web: Using SAS/IntrNet to Build an Application for Dymnamic Web Reporting
(Abstract Only)
Deborah K. Pine, STATPROBE Technologies, Cary, NC
Gregory S. Barnes Nelson, STATPROBE Technologies, Cary, NC

A High-Level Summary Table Generation Language Supplying the Missing Link between PROC MEANS using a CLASS Statement and PROC TABULATE
Dorothy Pugh, Independent Consultant, Durham, NC

Walk Our Children to School: An Internet Data Management Application
Carol A. Martell, UNC Highway Safety Research Center, Chapel Hill, NC

Beginning Tutorials

Meta Data - Everyone Talks About It, But What Is It?
John E. Bentley, First Union National Bank, Charlotte, NC

Here's the Data, Here's the Report I Want - How Do I Get There?
(Abstract Only)
Debbie B. Buck, D. B. & P. Associates, Houston, TX

The Power of PROC DATASETS
Lisa M. Davis, Bank of America, Jacksonville, FL

You Could Look It Up: An Introduction to SASHELP Dictionary Views
Michael L. Davis, Bassett Consulting Services, Inc., North Haven, CT

Introduction in Efficient SAS Programming via Incremental Refinement by Example
Paul M. Dorfman, Citibank Universal Card, Jacksonville, FL

Customize Your SAS Output with the Template Procedure: A Beginning Tutorial
Carol Gosselin, North Carolina State University, Raleigh, NC
Joy Munk Smith, North Carolina State University, Raleigh, NC

How to Incorporate Old SAS Data into a New DATA Step, or "What is S-M-U?"
Andrew T. Kuligowski, Nielsen Media Research, Dunedin, FL

SAS Software Macros - You're Only Limited by Your Imagination
Peter Parker, US Dept. of Commerce, Washington, DC

How to Use the Data Step Debugger
S. David Riba, JADE Tech, Inc., Clearwater, FL

Static SAS Web Publishing (SAS/IntrNet @ Social Work)
Roderick A. Rose, Jordan Institute for Families, UNC-Chapel Hill, NC

SAS as a Utility Language: Using SAS for Solving Little Problems
Gary E. Schlegelmilch, US Dept of Commerce, Bureau of the Census, Suitland, MD

Ten Things You Should Know about PROC FORMAT
Jack N. Shoemaker, Accordant Health Services, Greensboro, NC

Maps: Where We Were and Where We Are
(Abstract Only)
Clara L. Waterman, FORTIS Information Technologies, Bay Harbor Islands, FL

Coders' Corner

%XTAB2HTM: Macro Using ODS to Convert PROC FREQ Cross-tabulation to HTML with a Table of Contents and Back Buttons
Ronald Fehd, Centers for Disease Control and Prevention, Atlanta, GA

The Variable List Wildcard Character
Malachy J. Foley, UNC-Chapel Hill, Chapel Hill, NC

Mailing List Management
Imelda C. Go, Richland County School District One, Columbia, SC

Random Sample Selection
Imelda C. Go, Richland County School District One, Columbia, SC

Using SAS to Write SAS - Automate Your Programming Tasks
Pam Reading, Rho, Inc., Chapel Hill, NC

Web-Application Bar-Charts without SAS/Graph
Steve James, Centers for Disease Control and Prevention, Atlanta, GA

Add Common Look and Feel to Your Web Application Easily
Steve James, Centers for Disease Control and Prevention, Atlanta, GA

Producing a Table of Seeds for Random Number Generation
F. Joseph Kelley, University of Georgia, Athens, GA

A Macro to Center Text in a DATA _NULL_ Step
Erik S. Larsen, Independent Consultant, Reston, VA

Using Proc Compare for Data Reliability Measurement
Sharon Stroud, Medical Review of North Carolina, Cary, NC

Macro Design Considerations for a Word Wrapping Macro
Ian Whitlock, Westat, Rockville, MD

A Robust Generalized Axis-scaling SAS Macro
Dorothy Pugh, Independent Consultant, Durham, NC

Coders' Corner Panel Discussion on Problem Solving
Moderator: Steve Noga, Rho, Inc., Chapel Hill, NC

Includes...

Deep Blue SAS: One programmer's Approach to Problem-Solving
Frank C. DiIorio,
Advanced Integrated Manufacturing Solutions, Co., Durham, NC

Reporting from the Depths of Florida Sashole
Paul M. Dorfman, Citibank Universal Card, Jacksonville, FL

Coders' Corner Panel Problem
Ian Whitlock, Westat, Rockville, MD

Emerging Technologies

Using Data Mining Technology to Identify and Prioritize Emerging Opportunities for Mortgage Lending to Homeownership-Deficient Communities
Clark R. Abrahams, Bank of America, Charlotte, NC
Frank R. Burnett, Bank of America, Charlotte, NC Jin-Whan Jung, Ph.D., SAS Institute, Inc., Cary, NC

Emerging Technologies Roadmap - A Decision Tree Guide to Understanding SAS Strengths
Gregory S. Barnes Nelson, STATPROBE Technologies, Cary, NC
Eric C. Brinsfield, Meridian Software, Inc., Raleigh, NC

Extending the Data Warehouse: An Introduction to OLE DB
S. David Riba, JADE Tech, Inc., Clearwater, FL

Enterprise Integration Technologies - What is it, and What can it do for me?
Scott Vodicka, SAS, Cary, NC

Information Visualization

ABC's of Graphs in Version 8
Caroline Bahler, Meridian Software, Inc., Raleigh, NC

Dead Graphs - RIP (How Interactive Graphical EDA Techniques Can Markedly Enhance the Analysis/Display of Our Data)
Dave DesJardins, Statistical Research Division,
U.S. Bureau of the Census, Washington, DC

Identifying Time Series Models
(Abstract Only)
David Dickey, North Carolina State University, Raleigh, NC

Using JMP Version 4 Time Series Features to Analyze Passenger Demand Data and Closing Stock Prices
Bill Gjertsen, SAS Institute, Inc., Cary, NC

Producing a Browseable Statistical Package Using SAS
John Iwaniszek, Stat-Tech Services, LLC, Chapel Hill, NC
George DeMuth, Stat-Tech Services, LLC, Chapel Hill, NC Mike DeSpirito, Stat-Tech Services, LLC, Chapel Hill, NC

Underlying Construct Analysis (UCA): Where Individual Systrms End and Human Systems Begin
Alvin Killough, Ph.D., North Carolina Central University, Durham, NC
Don Drewes, Ph.D., North Carolina State University, Raleigh, NC
Christopher L. Edwards, Ph.D., Duke University Medical Center, Durham, NC

A Dynamic Imagemap Generator
Carol A. Martell, UNC Highway Safety Research Center, Chapel Hill, NC

Professional Development & User Support

Test Development: Ten Steps to a Valid and Reliable Certification Exam
Linda A. Althouse, Ph.D., SAS, Cary, NC

Effective SAS User Support: Utilize the Power of the Intranet
Lisa M. Davis, Bank of America, Jacksonville, FL

Teaching SAS Web Publishing in a Web Environment
Roderick A. Rose, Jordan Institute for Families, UNC-Chapel Hill, NC
Sally S. Muller, Jordan Institute for Families, UNC-Chapel Hill, NC

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 (presenter), SAS, Cary, NC
Jim Ashton, SAS, Cary, NC Sean Gargan, SAS, Cary, NC Dee Stribling, SAS, Cary, NC

SAS Solutions

Implementing a Balanced Scorecard Solution on Top of SAP, using CFO Vision as an Interface
Christ D'haeveloose (presenter), SoliQ, Inc., Cary, NC
Ida Carpelle, SOLID Partners, S.A., Brussels, Belgium
Sophie De Baets, SOLID Partners, S.A., Brussels, Belgium

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

Building Systems of Macros: The Print System and The Macro Reporting System (MRS)
John Iwaniszek, Stat-Tech Services, LLC, Chapel Hill, NC
George DeMuth, Stat-Tech Services, LLC, Chapel Hill, NC

Integrating SAS in Corporate IT
John M. LaBore, Eli Lilly and Company, Indianapolis, IN
Thomas H. Burger, Eli Lilly and Company, Indianapolis, IN

Positioning SAS for Corporate Effectiveness
John M. LaBore, Eli Lilly and Company, Indianapolis, IN
Thomas H. Burger, Eli Lilly and Company, Indianapolis, IN

Delivering South Carolina Health and Demographic Information via the Web using SAS/IntrNet? Software
Heather Mann, State of South Carolina Budget and Control Board, Columbia, SC
Neel Batey, Technology Solutions, Inc. Paul Butler, Technology Solution, Inc.
Beth Corely, State of South Carolina Budget and Control Board, Columbia, SC
Pete Bailey, State of South Carolina Budget and Control Board, Columbia, SC

SAS & HEDIS: An Introductory Overview
Christopher J. Plummer, Keystone Health Plan Central, Camp Hill, PA

The Power of Hybrid OLAP in a Multidimensional World
Ann Weinberger, SAS Institute Inc., Cary, NC
Matthias Ender, SAS Institute, Inc., Cary, NC

Statistics

A SAS Program for the Computation of Seroconversion Rates in a Prospective Study of HIV Discordant Couples in Lusaka, Zambia
Ilene K. Brill, University of Alabama - Birmingham, Birmingham, AL
Maurizio Macaluso, University of Alabama - Birmingham, Birmingham, AL
Jareen Meinzen-Derr, Center for Pediatric Research, Norfolk, VA
Susan Allen, University of Alabama - Birmingham, Birmingham, AL

SAS IML Code to Calculate an Upper Confidence Limit for Multivariate Statistical Distance
Margaret Connolly, Wyeth Lederle Vaccines, Pearl River, NY

Performing Exact Logistic Regression with the SAS System
Robert E. Derr, SAS, Cary, NC

Computing the Approximate and Exact Leaving-One-Out Method in
Multiple Group Logistic Discrimination with the SAS System
Mohamed Hussein, University of Georgia, Athens, GA

Macro in Scoring
Jukui Yi, First Union National Bank, Charlotte, NC

Exploratory Data Analysis using PROC UNIVARIATE
Robert E. Maitland, Jr., Bank of America, Jacksonville, FL

Computation of pvalues for Multiple Comparisons with a Control in the SAS System
Jean G. Orelien, Analytical Sciences, Inc., Durham, NC

Can a New Interpretation of Survival Data Help Patients Successfully Modify Adverse Risk Profiles?
Gregory L. Pearce, The Cleveland Clinic Foundation and GLP Consulting, Asheville, NC

Using the SAS System to Examine the Effect of Augmentation on the Inter-Rater Reliability of Holistic Ratings
Jim Penny, Center for Creative Leadership, Greensboro, NC
Robert L. Johnson, University of South Carolina, Columbia, SC
Belita Gordon, University of Georgia, Athens, GA

Using the SAS System to Examine the Reliability of the Retrospective Measure of Change
Jim Penny, Center for Creative Leadership, Greensboro, NC
Robert L. Johnson, University of South Carolina, Columbia, SC
Jennifer W. Martineau, Center for Creative Leadership, Greensboro, NC

Using the SAS System and QSR NUD*IST for Qualitative Data Analysis (QDA)
Robert G. Stewart, East Tennessee State University, Johnson City, TN

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

Systems Architecture

Multi-Process Connect: What, When, Where, How, and Why
(Abstract Only)
John E. Bentley, First Union National Bank, Charlotte, NC

Think Thin 2-D: "Reduced Structure" Database Architecture
Sigurd W. Hermansen, Westat, Rockville, MD

You Can do THAT with SAS Software? - Using the Socket Access Method to Unite SAS with the Internet
David L. Ward, DZS Software Solutions, Inc., Bound Brook, NJ