WELCOME TO PhilaSUG

Agenda



Click on any hyperlinked topic for an abstract
12:30 - 1:00 Registration
1:00 - 1:10 President's opening remarks
1:10 - 2:00 Statistical Presentations
Using the Power of PROC TABULATE

C. Olivia Rud
Fleet Bank
2:00 - 2:15 Breakout - Refreshments
2:15 - 3:05 Measuring the Success of Your Data Warehouse
Peter R. Welbrock
Strategic Information Systems
3:05 - 3:20 Breakout - Refreshments
3:20 - 3:35 Open Forum, Business Issues
3:35 - 4:25 Your Base SAS® Dollars at Work -
What's New and Useful in Version 7

Chris Olinger
SAS Institute Inc.
4:25 - 4:30 MBCR (Mercifully Brief Closing Remarks)
Light refreshments will be served during breaks

You are invited to join the speakers and the PhilaSUG Executive Committee for dinner at a nearby restaurant at the conclusion of the meeting. The location will be announced at the meeting.


[ R E T U R N   T O   T O P ]
[R E T U R N   T O   P h i l a S U G   H O M E   P A G E ]


Abstracts


Papers

Statistical Presentations
Using the Power of PROC TABULATE

C. Olivia Rud
Fleet Bank

Many business analysts and statisticians are burdened with the task of presenting complex statistical information to a non technical audience. While several tools exist in SAS to analyze data, PROC TABULATE is superior in its ability to display statistical values in a clear and efficient manner.

PROC TABULATE is able to combine the functionality of PROC MEANS and PROC FREQ. Additional power exists in its ability to perform analysis on grouped data. This paper details steps for constructing a table of marketing statistics using a variety of features. Missing values and formats are used to control the table's calculations. Labeling and selected options provide finishing touches for controlling the table's appearance. The result is a clear, informative table which serves as a useful tool for both marketers and business managers.

C. Olivia Rud, VP is a lead analytic consultant for Fleet Bank, Credit Cards. She has 8 years experience in marketing research in the banking, insurance and catalog industries. She has a BA in Mathematics from Gettysburg College and an MS in Decision and Information Systems from Arizona State University. She has presented at several SUGI conferences various regional SAS conferences and other international marketing conferences. She has been a SAS user for 10 years.


[ R E T U R N   T O   T O P ]
[R E T U R N   T O   P h i l a S U G   H O M E   P A G E ]



Measuring the Success of Your Data Warehouse
Peter R. Welbrock
Strategic Information Systems

nterprises and businesses do not need Data Warehouses. What they do need is solutions to problems and answers to questions. If properly designed, the Data Warehouse is an excellent way to satisfy these enterprise needs. There does exist the danger of the Data Warehouse raising more questions than it actually answers. The reason for this is that very few Data Warehouses are designed to respond directly to specific enterprise needs, but are instead ending up as virtual "catch­alls" that store vast amounts of data deemed beneficial to the enterprise. How do we know if the Data Warehouse is a worthwhile investment unless we can directly track the benefits it accrues?

This paper will discuss the importance of directly addressing enterprise needs in the design of the Data Warehouse. It will introduce a three­stage approach to Data Warehouse design that addresses how these specific needs may be attained using the SAS software products.


[ R E T U R N   T O   T O P ]
[R E T U R N   T O   P h i l a S U G   H O M E   P A G E ]



Your Base SAS® Dollars at Work -
What's New and Useful in Version 7

Chris Olinger
SAS Institute Inc.

he BASE procedures group (IPD) at SAS Institute has been hard at work adding new and useful features to the heart of the SAS System. This talk describes this work and uses generic "business oriented" examples to place these features in a context that demonstrates their use in everyday programming.

Covered are:

New SUMMARY/TABULATE options like percentiles, independent ordering of class variables, and the preloading of the class­variable space using formats and/or datasets.

The ODS statement for producing output datasets and HTML output from all SAS procedures, High­Fidelity Printing and more ODS specific additions to PROC REPORT, PROC TABULATE and the SAS/GRAPH Procedures that enhance the web potential of these work­horse tools. Build trees of web pages with graphics, embedded links and cell­specific formatting (like font and color) easily, repeatably from your current batch jobs.

Chris Olinger has worked in the Applications Division at SAS for the last 10 years. He is a primary developer of ODS (the Output Delivery System) and has worked on many procs in Base/SAS Software over the years. He is currently engaged in getting ODS ready to ship with Version 7 of the SAS System.

Chris Olinger

Information Products Department
SAS Institute
(919) 677-8000 x6774


[ R E T U R N   T O   T O P ]
[R E T U R N   T O   P h i l a S U G   H O M E   P A G E ]



Last Update: May 4, 1998