MSUG - Michigan SAS Users
Group
Welcome to MSUG
Michigan SAS Users Group!
We hope you'll approve of the changes that we are making and improvements that are yet to come.
Join us for our NEXT MEETING - a One-Day SAS Conference!
Date: Thursday, May 29, 2008
Time: 8:30 AM – 4:30 PM (registration and hot breakfast begins at 8:00 AM)
Place: VisTaTech Center
Schoolcraft College
18600 Haggerty Rd
Livonia, MI 48152Cost: $85 (on or before May 16), $115 (after May 16). Cost includes a full breakfast and lunch, and if you stay for the closing session, the chance to win some great door prizes, including a free registration to the MidWest SAS Users Group conference this October in Indianapolis!
Agenda: Download a copy of the schedule
Visual Data Discovery- Jon Weisz, SAS/JMP
SAS Visual Data Discovery is designed for people who need interactive data analysis and visualization capabilities, broad data preparation features, and deep analytics. Even nonstatisticians and programmers unfamiliar with SAS can access the power of SAS through the JMP environment. SAS Visual Data Discovery can help organizations enhance analytic effectiveness for faster insights and actions. SAS Visual Data Discovery combines SAS’ top-selling products (Base SAS, SAS/STAT®, SAS/GRAPH® and SAS Enterprise Guide®) with JMP® 7’s interactive interface to provide an easy-to-install, easy-to-use advanced analysis and data visualization package.Design of Experiments with JMP- Jeff Hawes, SAS/JMP
Increasing productivity and improving quality are important goals in any business. The methods for determining how to increase productivity and improve quality are evolving. They have changed from costly and time-consuming trial-and-error searches to the powerful, elegant, and cost-effective statistical methods that JMP provides. JMP's Custom Designer lets you create designs that can’t be matched by any compilation of pre-formulated designs offered by other software vendors. JMP offers novices and DOE experts alike the power to design experiments that meet the most complex conditions.Undocumented and Hard-to-find PROC SQL Features- Kirk Paul Lafler, Software Intelligence Corporation
The SQL Procedure contains many powerful and elegant language features for experienced SQL users. This presentation introduces SQL topics that will help users unlock many hidden features, options, and other hard-to-find gems found in the SQL universe. Topics include CASE logic; the COALESCE and MONOTONIC functions; PROC SQL statement options including the _METHOD and _TREE options; SQL and the Macro Facility; Dictionary tables; and performance tuning techniques.SAS Hacks – Workarounds and Coding Techniques for SAS Users- Kirk Paul Lafler, Software Intelligence Corporation
The concept of a "hack" means a clever solution or workaround that solves a practical problem. Hacks aren’t procedures or simple menu options that can be selected. They are typically classified as industrial-strength, real-world solutions that enable users to customize the way the SAS® software works or processes, the way two different things work together, or solve a practical problem. Topics include customizing accessibility features; changing the current SAS folder; setting default system options; redefining SAS Function Keys; specifying program statements in the SAS Autoexec file; and customizing the SAS Configuration file.Utilizing the SAS Business Intelligence Platform- Brian Varney, COMSYS
Many research environments are rampant with similar tasks being performed over and over again on similar data. Over the past couple of decades, standardization of data storage and reporting has made the time appropriate for taking advantage of business intelligence software against these vast warehouses data. The SAS Business Intelligence platform is a logical path to take because of the easy integration with existing SAS programs and data sources that are already proven and familiar. This will also allow non-traditional SAS users to access the data and reports without the use of traditional SAS tools.New in SAS 9.2: It’s the Little Things that Count- Diane Olson, SAS
It's easy getting the word out about the big things that are added to a release, but the little things often go unsung. These additions to Base SAS can make your coding life a lot easier. Come hear about a new option for data set encryption, linguistic sort additions to the utility procedures, a new statement for indexes, PROC MIGRATE advancements that allow you to migrate your libraries cross-host, and more!Find out What You’re Missing: SAS Enterprise Guide for Programmers- Casey Smith, SAS
If the techniques you have been using to do your job for 20 years are still working, what's your incentive to change? Learn about the productivity gains that you can enjoy when you add SAS Enterprise Guide to your SAS programming toolbox. You will see how to perform old tasks in a new way as well as how to accomplish some tasks that would have been very difficult-if not impossible-without the benefit of an integrated tool like SAS Enterprise Guide. Plus, stay tuned for a candid discussion of SAS features that don't work so well from within SAS Enterprise Guide. The content of this paper is adapted from SAS For Dummies, by Stephen McDaniel and Chris Hemedinger, updated with new programmer-friendly features from SAS Enterprise Guide 4.2.
Training Opportunities
Kirk Paul Lafler will also be offering two 1/2 day training classes on Friday, May 30 at the VisTaTech Center at Schoolcraft College (same location as the conference)- "Transferring Data Between SAS and Excel" (9:00 AM - 12:00 Noon) and "Output Delivery System Techniques" (1:00 PM - 4:00 PM). Kirk is the author of "PROC SQL: Beyond the Basics Using SAS", has won 13 "Best Contributed Paper" awards at SAS Global Forum, SUGI and Regional User Group conferences, and is a frequent invited speaker and training instructor at regional and local user group meetings. Cost for the classes has been reduced to $99 each if registration form is sent/postmarked by May 16 ($125 afterwards), and includes all course materials. Download a registration form. Please contact Kirk Lafler if you have any questions.
Transferring Data Between SAS and Excel
This course focuses on the various techniques and methods associated with transferring data to and from SAS® and Excel®. Topics include the many approaches users have to transfer data directly from SAS to Excel as well as from Excel to SAS. A collection of proven techniques along with code examples are presented to illustrate exporting and importing data with SAS/ACCESS® software, using a LIBNAME statement to transfer data, using the SAS Display Manager System to transfer data to spreadsheet format, with the ODS HTML destination to construct spreadsheet files, and using the ExcelXP destination to create multi-sheet Excel workbooks.Output Delivery System Techniques
This course will help you create “quality” output using powerful Output Delivery System (ODS) statements and options. Topics include coding ODS statements; exploring and managing output destinations; selecting output objects; managing selection and exclusion lists; using the Escape character to enhance output formats; creating output data sets, PDF files, RTF files, spreadsheet files, and HTML output; concatenating procedure output; and building simple drill-down applications and thumbnail charts.
If you are interested in presenting at or hosting an upcoming meeting, please contact MSUG. Thank you!