Learn about SAS Business Intelligence from experts

If you are going to SUGI 30 in Philadelphia, PA,
please be sure to attend SAS Business Intelligence
presentations and workshops. This will be a unique opportunity to learn all about the SAS Business Intelligence products from the experts.

You will find a list of selected SAS Business Intelligence presentations at the upcoming SUGI conference below. For
more information, please visit our SUGI 30 page.

Charles Hallahan (USDA), Linda Atkinson (USDA)
Introduction to SAS Enterprise Guide 3.0 for Statistical Analysis

Mon, Apr 11, Room 103ABC, 11:00AM-12:20 PM

Chris Hemedinger (SAS Institute)
Efficient Data Access using SAS Enterprise Guide: Best Practices

Mon, Apr 11, Room 113A, 02:30-03:20 PM

Susan Slaughter (Avocet Solutions), Lora Delwiche (UC
Davis)
Summary Tables in SAS Enterprise Guide: PROC TABULATE Made Easy [poster]

Mon, Apr 11, Room Bridge Area, 03:00-04:00 PM

Stephen McDaniel (SAS Institute), Chris Hemedinger (SAS Institute)
The New World of SAS: Programming with SAS Enterprise Guide

Mon, Apr 11, Room 108, 04:00-04:20 PM

Rick Styll (SAS Institute), Mark Granville (SAS Institute)
What's New with V2 Web Report Studio and Information Map Studio

Tue, Apr 12, Room 111, 10:00-10:50 AM

Rick Styll (SAS Institute), Mark Granville (SAS Institute)
Sharing Report Content Across the SAS Business Intelligence Server

Tue, Apr 12, Room 107, 11:00-11:50 AM

Stephen McDaniel (SAS Institute), David McNamara
(SAS Institute)
What's New in SAS Enterprise Guide – Your Key to Analytic Business Intelligence

Tue, Apr 12, Room 107, 01:30-02:20 PM

Jennifer Clegg (SAS Institute), Stephen McDaniel (SAS Institute)
Microsoft Office Integration with the SAS BI Server

Tue, Apr 12, Room 104, 01:30-02:20 PM

Chris Hemedinger (SAS Institute)
Boost Your Programming Productivity with SAS Enterprise
Guide

Tue, Apr 12, Room 109, 03:00-03:50 PM

James White (SAS Institute), Bryan Wolfe (SAS Institute), Stephen McDaniel (SAS Institute)
Stored Process Creation, Testing and Maintenance via SAS Enterprise Guide

Tue, Apr 12, Room 107, 03:30-04:20 PM

Jennifer Clegg (SAS Institute), I-Kong Fu (SAS Institute)
Microsoft Office Integration with the SAS BI Server

Tue, Apr 12, Room 201AB, 04:30-05:20 PM

Review of SAS Enterprise Guide training courses

The previous issue of the newsletter featured a review of two Enterprise Guide web-based training courses by Linda Lucek of Northern Illinois University. Linda reviewed Programming Using SAS Enterprise Guide and Querying Data Using SAS Enterprise Guide.

Sunil Gupta of Gupta Programming has kindly agreed to review the other two Enterprise Guide web-based training courses offered by SAS Institute, namely, Performing Statistical Analyses Using SAS Enterprise Guide: Examples and Creating and Customizing Reports Using SAS Enterprise Guide.

Sunil Gupta is the principal consultant and trainer at Gupta Programming. He has been using SAS software for over 12 years, is a SAS Base Certified Professional and was the program chair for the Western Users of SAS Software conference in 1998. He has also been an invited speaker at numerous SUGI conferences. He has over 41 presentations and publications, is the author of Quick Results with the Output Delivery System, and was a SAS Institute Quality Partner for over 5 years. Currently, he is writing a new book, Analysis and Reporting Made Easier Using SAS Learning Edition and is co-authoring another book, Sharpening Your SAS Skills, to help users better understand and analyze the SAS programming language.

Because these courses are self-paced, I was able to review them on my schedule. In addition, because the instructions and steps were easy to follows, the learning process was fun. Whether you are a new or an experienced SAS programmer, you will find both courses very useful to save you time in making the best use of SAS Enterprise Guide. The Creating and Customizing Reports Using SAS Enterprise Guide course shows how you can turn data into information with presentation-quality reports. This course contains 74 pages of content that takes about 2 hours to complete.

The Performing Statistical Analysis Using SAS Enterprise Guide course shows how to better understand your data with statistical analysis. This course contains 59 pages of content and takes about 2 hours to complete.

The Creating and Customizing Reports Using SAS Enterprise Guide course offered step-by-step instructions for creating and customizing a variety of reports. In the beginning, the lessons discuss methods to access data from various raw source files. Next, before reports can be generated, a section discusses the Query Builder and how important it is to prepare the data. The next sections showed how to create lists, frequency, summary and graphs. These are the types of reports required in the real world. In addition, there is one lesson that explains the flexibility in designing summary reports. This feature in SAS Enterprise Guide is very powerful because it offers a great deal of control in the layout of your summary report.

The last sections showed how to customize your results by applying formats, styles, creating different file types such as HTML, PDF and RTF and editing your code. This ability to customize your output is very important. The lessons show how the default settings are used unless you change them to customize your results. Programmers can use SAS Enterprise Guide to start the development process and then edit the SAS code generated to create customized results. Finally, the graphs are easy to produce and can be copied to Microsoft Word.

The Performing Statistical Analysis Using SAS Enterprise Guide course is not only great for statisticians but also for non-statisticians as the lessons explain the statistical test and the results. A variety of analysis is shown in the lessons including: summary statistics, distribution analysis, t-tests, one-way analysis of variance, simple linear regression, two-way analysis of variance, analysis of covariance, control charts for measurement data, and control charts for attribute data. Each data set analyzed has a description of all variables. The screen shots of each step and results are well labeled. In addition, lessons showed how to customize the results with titles and footnotes.

The user can select through a dialog box the statistics to include in the summary statistics report. For each statistical test performed, the task is identified and the variables are assigned to roles. The graphs that are generated from SAS Enterprise Guide convey useful information about the data. As a statistician, you will find that the exercises contain most all of the statistical options for these statistical tests.