SESUG Proceedings 1999
These Proceedings are the official record of the 7th Annual SouthEast SAS Users Group (SESUG) Conference held in Mobile, AL on October 31 – November 3, 1999 at the Adams Mark Hotel. 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 1999: The Proceedings of the SouthEast SAS Users Group, Mobile, AL, 1999
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 © 1999 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.
Applications Development
14 Steps to a Good GUI
John E. Bentley
A SAS 7 System: From CD to GIS MAPS
Samuel D. Calhoun
Comparison of CGI and Java Technology Provided in SAS/IntrNet Software
Barbara Walters, Don Chapman
Effective Strategies for Managing SAS Applications Development
Christopher A. Roper
Empowering Your End-Users’ Reporting Potential from SAS/AF Applications with SAS Enterprise Reporter
Gary Mason
Exporting Oracle Tables into SAS Tables Made Simple with Version 7 of the SAS System
Danny Walker
Householding and Its Relationship to Customer-to-Customer Marketing and Data Mining
Jacob Sacolick
Optimizing Data Extraction from Oracle Tables
Caroline C. Bahler
Using SAS, SAS/ACCESS and SQL Passthrough to Query and Join Oracle Tables
Barbara B. Okerson
Using SAS/AF to Create Applications for the Administrative Aspects of Data Management in Clinical Trials
Emily Mixon, Karen Fowler, Felicita David
Coder’s Corner
A Cross-reference for SAS Data Libraries
John R. Gerlach, Cindy Garra
A Modular SAS Programming to Support ABC Simulation Study
Sejong Bae, Michael Weaver
A SAS Program to Calculate and Plot Widths of (1-a) 100% Confidence Intervals for Binomial Proportions
Maribeth Johnson, Mark Litaker
An OBS Limit with a WHERE Condition
Ian Whitlock
Creating ASCII Fixed Length Record Files from SAS Data Sets
Lawrence Altmayer
Everything In One Record: Creating One-liners with Merges and Retains
Sharon W. Stroud, David P. Biggs
Generating SAS Reports and the Collation Problem
Imelda C. Go
Indexed Datasets 101
John Charles Gober
Let’s Play a Game: A SAS Program for Creating a Word Search Matrix
Robert S. Matthews
Make Your Own Macro Processor
Ian Whitlock
Managing the INTNX Function
Ian Whitlock
Matching Data Using SAS Programming and Human Judgment
Imelda C. Go
Pruning the SASLOG – Digging into the Roots of NOTEs, WARNINGs, and ERRORs
Andrew T. Kuligowski
Removing Macro Variables from the SAS Environment
Frank DiIorio
Shortcuts
Janet E. Stuelpner
The Power of SAS Input Statements
Imelda C. Go
Using SAS/AF to Create Data Entry Screens with Multiple Comment Fields Allowing for Unlimited Amounts of Text in Each Field
Robert S. Matthews
Using SAS ARRAYs: An Introduction to Easy Recodes
Francis J. Kelley
Your Friend the Colon: Some Efficiency Techniques for Comparing or Selecting Character Data
S. David Riba
Emerging Technologies
An Introduction to the Next Big Thing: Parallel Computing
John E. Bentley
SAS Skills in the Next Millennium: A Geek Peek into the (not so distant) Future
Greg S. Barnes Nelson, Jodi Barnes Nelson
Tech Report 2000: Telecommuting with SAS Saves Gas. The SAS Application Developer’s Guide to the Virtual Office
Eric C. Brinsfield, Matt Becker
Information Visualization
Data Summarization Methods in Base SAS Procedures
Lynn Bressler
Statistical Presentations Using the Power of PROC TABULATE
C. Olivia Rud
Using JMP for Technical Analysis of Stocks in Highly Volatile Markets
Bill Gjertsen
SAS Solutions
An Interactive GUI Front-End for a Credit Scoring Modeling System
Jeff Morrison, Futian Shie, Timothy Lee
Building a Customized Data Entry System With SAS/Intrnet
Keith J. Brown
CRM 101: Maximizing Return on Investment with the SAS Solution for CRM
Drury Jenkins
Deploying the SAS/MDDB in a Retail Environment
Ben Cochran
Building a Data Mart on top of SAP R/3-HR
Christ D’haeveloose, Sophie Dabaets
SAS I/T Service Vision: Delta Technology’s Performance Database
Bob Chaney
Tessera Rapid Modeling Environment: Production-Strength Data Mining Solution for Terabyte-Class Relational Data Warehouses
Mike Nichols, John Zhao, John David Campbell
Using SAS Software to Analyze Sybase Performance on the Web
Joseph Mirabal, Zhengyu Wang
Statistics, Data Analysis and Modeling
A Modular SAS Programming to Support ABC Simulation Study
Sejong Bae, Michael Weaver
A SAS Program for the Computation of Cumulative Exposure Estimates for Analysis of Cause-specific Mortality Rates in a Cohort of Synthetic Rubber Workers
Ilene Brill, Maurizio Mancaluso, Robert Matthews, Elizabeth Delzell
Analysis of Longitudinal Data: Comparison between PROC GLM and PROC MIXED
Maribeth Johnson
Forecasting Army Officer Attrition with Logistic Regression Using The SAS System
LTC Doug L. McAllaster
Hot-Deck Imputation: A Simple DATA Step Approach
Lawrence Altmayer
Recent Advances in Categorical Data Analysis
Maura E. Stokes
Statistics without DATA _NULLS_,
Michael C. Palmer, Cecilia A. Hale
Tutorial on Logistic Regression
Maura Stokes
Using the SAS System to Examine the Agreement between Two Programs that Score Surveys Using Samejima’s Graded Response Model
Jim Penny, S. Bartholomew Craig
Using SAS Perform the Analysis of Means for Variances Test
Peter Wludyka, Ph.D.
Utilizing SAS Software in the Evaluation of Virginia Tech’s Academic Eligibility Policy
Kristen H. Bush, Ph.D.
Systems Architecture
Distributing SAS/AF Models with Java Clients
Chris Bailey, Karl Moss
Extending the Data Warehouse: An Introduction to Ole DB
S. David Riba
No Program Is An Island: Passing Parameters to Tasks Launched by Servers and Schedulers
Michael L. Davis, Gregory S. Barnes Nelson
Optimizing SAS Software on Windows NT: A Guide to Performance Tuning Your Applications Server
Peter Parker
SAS Client-Server Development: Through Thick and Thin and Version 8
Eric Brinsfield
What’s New in Versions 7 and 8 for SAS files?
Jane Stroupe
Hiring the Best SAS Programmers
Neil Howard
How to Develop and Maintain a Corporate SAS Users Group
Bryan K. Beverly
Providing Web-Based Support for SAS users at NC State University
Joy Munk Smith, Sandra B. Donaghy
Telecommuting: The Workplace of the 90s
Thalene T. Mallus
Year 2000 Triage for Your SAS Applications
Mike Kalt
Advanced Tutorials
Advanced Manufacturing Applications with SAS
Perry Smith
Adventures in Arrays: A Beginning Tutorial
Jane Stroupe
Array Lookup Techniques: From Key-Indexing to Hashing (Part 2)
Paul M. Dorfman
Building Yield Management – GUI System at Norwegian Cruise Line by Using SAS/EIS and SAS/AF
Sam Sheng
Characteristics of a “Successful” Application
Caroline Bahler
Data Mining: An Overview of Methods and Technologies for Increasing Profits in Direct Marketing
C. Olivia Rud
Fuzzy Merges: Examples and Techniques
Malachy J. Foley
Macro Internals for the User – Developer’s Overview
Susan O’Connor
Mapping: “Would You, Could You …”
Clara Louise Waterman
The Writing for Reading SAS Style Sheet: Tricks, Traps & Tips from SAS-L’s Macro Maven
Ronald Fehd
Those Missing Values in Questionnaires
John R. Gerlach, Cindy Garra
User-Specified Text Flow Inside the Report Procedure
Donald Peterson, John R. Gerlach
Using IBM System/360/370/390 Data Types in a Non-Mainframe Environment
Francis J. Kelley
Beginning Tutorials
Array Lookup Techniques: From Sequential Search to Key-Indexing (Part 1)
Paul M. Dorfman
Do We Know How to Function?
Janet E. Stuelpner
Getting Started with Frame Technology
Christopher A. Roper
Getting Started with Macro
Ian Whitlock
How to Use the Data Step Debugger
S. David Riba
Programming Solutions with SAS Formats and Informats
Imelda C. Go
SAS Components to Help You Survive A Deserted Island
Stephen M. Noga
Seven Steps to SAS/GRAPH Savvy
Neil Howard
So Many PROCs, So Little Time: A Primer of Efficient Report Writing in Base SAS
Deborah Babcock Buck
Summarization – The Keys to Processing
Ron Coleman
The SAS Debugging Primer
Frank C. DiIorio