SESUG Proceedings 1999

Copyright Information

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