Business Intelligence SAS Users Group




Back to main page	If you are planning to attend SUGI 30 in Philadelphia, PA, don't miss the opportunity to learn all about the SAS Business Intelligence products from the experts. The following is a brief overview of SAS Business Intelligence presentations/workshops at the upcoming SUGI conference. Mark your calendars for these great talks.


	Charles Hallahan	USDA	Beginner's Track
	Linda Atkinson	USDA
	Introduction to SAS Enterprise Guide 3.0 for Statistical Analysis
	The workshop begins with a quick tour through the layout and purpose of Enterprise Guide (EG) as a menu-based interface to SAS procedures. Emphasis in this workshop will be on the statistical capabilities of EG. In particular, a set of data will serve as a case study for performing exploratory data analysis, estimating a multiple regression model, and examining graphical diagnostics for the model fit. The workshop will show how code generated by EG can be customized, stored, and rerun, and custom reports saved with the Document Builder.

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

	Thomas Skinner	Intel Solution
	Jerome Esteban	Intel Solution
	Bill MacCormac	Intel Solution
	Deploying Distributed and Grid-enabled Enterprise BI with SAS9
	Intel Solutions Services SAS Practice will discuss the implementation of SAS9 Enterprise Business Intelligence in distributed and grid environments. Key topics in the presentation will include architectural considerations of the SAS9 BI Server, how to implement the SAS9 BI server in a grid and or distributed environment, and instrumentation and monitoring of the status of the SAS9 BI server. Also covered will be key lessons learned from past SAS9 implementations by Intel Solutions Services SAS Practice.

	Mon, Apr 11, Room 110, 11:30AM-12:30 PM

	Chris Hemedinger	SAS Institute
	Efficient Data Access using SAS Enterprise Guide: Best Practices
	SAS Enterprise Guide provides several quick and easy methods to access your data, whether it resides locally on your workstation, on a SAS server, or in a remote database. Each of these methods has pros and cons, not all of them will provide the performance you need for repetitive, production projects. This paper describes the data access mechanism in SAS Enterprise Guide and outlines some best practices for configuring your projects to use the most efficient method of access for you, so you can get on with the business of filtering, analyzing, and reporting on the data contents.

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

	Susan Slaughter	Avocet Solutions	Poster
	Lora Delwiche	UC Davis
	Summary Tables in SAS Enterprise Guide: PROC TABULATE Made Easy
	The TABULATE procedure is a powerful way to create complex and attractive reports in SAS. But getting your report arranged just the way you want it can take extensive trial and error. Summary Tables is an interactive version of PROC TABULATE provided in SAS Enterprise Guide. In Summary Tables you can arrange and rearrange your table to see how it will look before you even submit the code. You can also change data formats, headings, color, and font. In fact, practically any feature that you can set in PROC TABULATE code in SAS, you can change interactively in Summary Tables. Summary Tables is faster, easier, and saves you from having to remember the exact syntax for every option you wish to use. Once you've perfected your table in Enterprise Guide, you can, if you wish, save the code and run it from SAS.

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

	Chris Hemedinger	SAS Institute
	The New World of SAS: Programming with SAS Enterprise Guide
	SAS Enterprise Guide (with its easy-to-use interface) has been a boon to SAS users, especially non-programmers. However, SAS Enterprise Guide provides some powerful new features that are geared toward the SAS programmer, including an integrated process-flow view of your project; the ability to create, publish, and execute stored processes; and an increased flexibility for output format and destination with the SAS Output Delivery System (ODS). This paper provides an overview and detailed examples of how SAS programmers can leverage SAS Enterprise Guide to create, organize, and execute their SAS programs.

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

	Rick Styll	SAS Institute	Intelligent Web Solutions Track
	Mark Granville	SAS Institute
	What's New with V2 Web Report Studio and Information Map Studio
	Web Report Studio and Information Map Studio V1 were introduced with V9. In the past year, based on customer feedback and suggestions, both products have rapidly evolved with the addition of significant additional features and are bringing easy to use, but powerful capabilities to meet SAS customer query and reporting needs. This paper will discuss the features of the new V2 release and preview future plans. Also covered will be integration points with the Business Intelligence Server and how to leverage the complete portfolio of extraordinary data management and advanced reporting tools.

	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
	Via the SAS Report Model, the Output Delivery System is leveraged to produce enable reporting from Enterprise Guide, the Add-In for Microsoft Office, and Web Report Studio. Each of these applications can: Display the report in one contiguous view similar to web browsers. Print the report with page headers and footers, logical page breaks, and tables spanning multiple pages with headers replicating on each page. Refresh the reports by rerunning the SAS code and updating the report. In addition, EG and AMO have the ability to edit these reports created by ODS. These edits include moving and deleting elements, changing styles and properties, and copying and pasting content. After editing the report, it can be saved in the Report Repository where WRS can display, print and refresh the report.

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

	Stephen McDaniel	SAS Institute
	What's New in SAS Enterprise Guide – Your Key to Analytic Business Intelligence
	As the preferred interface to SAS for business analysts, statisticians, and programmers, and a key application in the BI Server suite, SAS Enterprise Guide 3.1 delivers new and exciting capabilities to make you more productive and successful- from programming to analytics to reporting, EG is a critical part of the SAS BI Server!

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

	Jennifer Clegg	SAS Institute	Focus Sessions Track
	Stephen McDaniel	SAS Institute
	Microsoft Office Integration with the SAS BI Server
	This paper will discuss the features of the next release of the SAS Add-In for Microsoft Office and the integration with Microsoft Excel, Microsoft Word, and Microsoft PowerPoint. The topics include accessing SAS data sources, using ad-hoc analytics to further analyze SAS and Excel data, and running stored processes to generate reports. Find out how you can leverage SAS to create and update reports directly from the familiar environment of Office. Also covered will be integration points across the BI Server with Microsoft Office.

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

	Eric Rossland	SAS Institute	Beginner's Track
	Kari Richardson	SAS Institute
	Creating and Using SAS Stored Processes with SAS Enterprise Guide
	This hands-on workshop shows how to use SAS Enterprise Guide to create and use SAS Stored Processes. In particular, you will learn how to (1) create a new project, run an existing stored process, and stream the results back to SAS Enterprise Guide, (2) add an existing SAS program to the project and use it to create, register, and test a new stored process, (3) add a data source to the project, run a task against it, and (4) create, register, and test a new stored process based on that task.

	Tue, Apr 12, Room 103ABC, 03:00-04:20 PM

	Stephen McDaniel	SAS Institute	Focus Sessions Track
	Boost Your Programming Productivity with SAS Enterprise Guide
	SAS Enterprise Guide (with its easy-to-use interface) has been a boon to SAS users, especially non-programmers. However, SAS Enterprise Guide provides some powerful new features that are geared toward the SAS programmer, including an integrated process-flow view of your project; the ability to create, publish, and execute stored processes; and increased flexibility for output format and destination with the SAS Output Delivery System (ODS). This paper provides an overview and detailed examples of how SAS programmers can leverage SAS Enterprise Guide to create, organize, and execute their SAS programs.

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

	Karen Curran	Omnicare	Management Track
	Wed, Apr 13, Room 203, 11:30-11:50 AM
	In 2000, Omnicare Clinical Research was formed through the union of three CROs. At that time, the Biometrics programming groups at each facility used either terminal emulators or SAS for Microsoft Windows. To unify programming activities into one global, validated environment, all programming groups were migrated to one central Unix server. To allow users a choice of programming interfaces, the system was loaded with SAS Integration Technologies with a front end of SAS Enterprise Guide® and VT terminal interfaces. This paper will discuss the advantages and disadvantages of this strategy and the features of using SAS Enterprise Guide individual site licenses for Microsoft Windows.

	Tue, Apr 12, Room 103ABC, 03:00-04:20 PM

	James White	SAS Institute	Beginner's Track
	Bryan Wolfe	SAS Institute
	Stephen McDaniel	SAS Institute
	Stored Process Creation, Testing and Maintenance via SAS Enterprise Guide
	While SAS Stored Processes may be executed within many SAS applications, there is only one SAS product that allows you to fully develop, test and deploy stored processes all from within one application -- SAS Enterprise Guide 3.0. This paper will take you through the entire process of stored process authoring, testing, debugging and deployment in Enterprise Guide. Learn how to avoid common mistakes and create SAS applications that can be surfaced in Enterprise Guide, the SAS Add-In for Microsoft Office, WRS, the Portal, and beyond. Also covered will be how to utilize parameters to allow for run-time customization of stored process execution and how to transform your favorite EG tasks into stored processes.

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

	Jennifer Clegg	SAS Institute	Focus Sessions Track
	I-Kong Fu	SAS Institute
	Microsoft Office Integration with the SAS BI Server
	SAS Add-In for Microsoft Office is a Component Object Model (COM) add-in to Microsoft Excel and Microsoft Word. SAS Add-In for Microsoft Office leverages the SAS BI Server to seamlessly expose the power of SAS data access, reporting, and analytics directly from the familiar environment of Microsoft Office. This paper discusses the capabilities and features of SAS Add-In 1.3 for Microsoft Office.

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

	Marje Fecht	Prowerk Consulting
	Peter Bennett	SAS Institute
	End-to-End Web Reporting Using SAS Enterprise Guide 3.0: Who Does What and When
	SAS 9 and SAS Enterprise Guide 3.0 provide an array of powerful tools for analyzing data and generating the information that organizations demand to address their business needs. However, to exploit the new architecture, more people need to be involved in the development process, which means that a clear understanding of the different roles and responsibilities at each stage of the process is required. This scenario-based tutorial takes you through the different stages of the process (security control via the SAS Management Console, SAS Enterprise Guide report development and deployment, end user access via the SAS Information Delivery Portal, SAS Web Report Studio, and Microsoft Office). The report(s) produced will be simple ones as the emphasis here is on the process and responsibilities involved.

	Wed, Apr 13, Room 201AB, 08:00-08:50 AM

	Chris Hemedinger	SAS Institute
	Alex Dmitrienko	Eli Lilly and Company
	Filling the Gap: Extending the SAS BI Server with Custom Tasks
	SAS Enterprise Guide and the SAS Add-In for Microsoft Office ship with dozens of tasks for data manipulation, analysis, and reporting. But even so, it won't take you long to think of a particular task that is not covered by the product "out of the box". You can always resort to using the code editor to create the results that you want, but what about when you want to create a repeatable task, or a task that you would like to present to an end-user who has little-to-no SAS programming experience? SAS Enterprise Guide and the SAS Add-In for Microsoft Office are extendable with custom tasks, which you can now create by using standard off-the-shelf development tools. This paper provides an overview of the add-in architecture plus an example task that uses Microsoft .NET tools and technology to provide a new feature to the application.

	Wed, Apr 13, Room 107, 09:00-09:50 AM

Copyright © 2005 BISUG. 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. Other brand and product names are trademarks of their respective companies.