| I. Welcome and Introductions |
5 - 10 mins |
II. Featured Speaker: Stephanie Thompson - SESUG speaker
Topic: Getting Your Data into SAS® |
50 mins |
Speaker Bio
Stephanie Thompson has over fifteen years experience applying statistical and modeling techniques to business problems in various manufacturing, retail, and academic environments using SAS and other programming languages. She has a strong understanding of data structures, analytical tools, and operating environments. She holds a B.S. in Industrial Engineering from Rochester Institute of Technology and an M.B.A. from St. Bonaventure University.
Stephanie is a SAS Certified Base Programmer for SAS9 and has presented at SESUG, SUGI / SAS Global Forum, NESUG, and local users group events. She is a member of the SESUG Executive Council, has co-chaired various academic sections at SESUG, and is the Academic Program Chair for SESUG 2010.
|
Abstract Where is your data stored? Oracle tables SQL Server tables Microsoft Access Microsoft Excel Text file All over the place.
Over the years there has been a proliferation of ERP systems and other ways to collect and store data. Many times you need data from different systems to complete a single analysis. Sometimes getting data out can seem like quite a challenge. Luckily, SAS has the capability to access many different types of data but also different ways to do so. This workshop will cover how to use SAS to access data from a variety of sources through both presentation and live demonstration. Some practical tips on which methods work best or are fastest will also be covered.
The following methods to access data will be covered in the workshop: SAS libname engine PROC SQL ODBC PROC IMPORT (including the Import Wizard)
|
| IV. Break |
10 mins |
V. Featured Speaker: Dwight Mouton - SAS Customer Intelligence
Topic: Integrating SAS Marketing Solutions into your Analytics Processes |
45 mins |
Abstract
Live Demonstration of Customer Intelligence products Campaign Management and Marketing Optimization.
|
II. Featured Speaker: Ron Fehd - CDC
Topic: A two-brief intro to SQL by SAS-L’s macro maven |
20-30 mins |
Abstract
How Proc SQL is used - for those who have questions
|
VI. Featured Speaker: Stephanie Thompson - SESUG speaker
Topic: Graphing the Easy Way with SAS® Enterprise Guide® (or How to Look Good With Less Effort) |
45 mins |
Abstract
Have you ever wanted to make some fancy graphs but were intimidated by coding them from scratch? Let Enterprise Guide® do the hard part for you. This presentation will provide a brief overview of Enterprise Guide then walk you through creating different types of graphs. Bar charts, pie charts, scatter plots and more will be created. Once the graphs are done, I‘ll "borrow" the generated code, put it in another SAS® program, make a few modifications, and then voila - fancy graphs from your program. I will use both the programming interface and Enterprise Guide in this presentation.
|
| VII. Closing |
5 mins |