SAS SUMMER MEETING
9:00 Introduction and Welcome from TCASUG Board
9:05 An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS; Vince Del Gobbo, SAS Institute
Abstract: Transferring SAS data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This talk provides basic information on how to use Base SAS 9 software to create multi-sheet Excel workbooks (for Excel versions 2002 and later.) You will learn techniques for quickly and easily creating attractive, multi-sheet Excel workbooks that contain your SAS output using ExcelXP tagset. The techniques that are presented in this talk can be used regardless of the platform on which SAS software is installed. You can even use them on a mainframe! Mor in-depth information on this topic will be presented, if time permits.
10:30 Break
10:40 SAS Enterprise Guide: A Revolutionary Tool for All; Jennifer First, System Seminar Consultants
Abstract: Whether you are a novice or a pro with SAS, Enterprise Guide has something for everyone. Your organization can leverage the powerful ETL, analysis and reporting capabilities of SAS with a comfortable GUI. New SAS users can begin working with EG, using wizards to import data, perform analysis and generate reports quickly and easily. Experienced SAS programmers can us EG to increase efficiency, decrease coding errors, and leverage new functionality available to programmers only in EG. All users can focus on the content of the analysis, rather than details of the coding which will increase efficiency, leverage unutilized functionality and streamline processes.
11:30 Lunch (Sponsored by SafeNet Consulting)
12:30 Copy and Append: Developer's Secrets; Diane Olson, SAS Institute
Abstract: This presentation will give you the inside tricks about PROCs COPY and APPEND that the developer is dying to tell you. Want a clone of your data set (attributes and data) written to the same library? You can! Want to copy your data set using data set options? You can! Need a data set converted to a particular data representation and encoding? You can! Make the most of these basic, necessary procedures by applying the tricks you’ll learn.
1:30 Break
1:50 Introduction to Credit Risk Modeling using SAS; Kevin Hougas, U. S. Bank
Abstract: This talk will focus around 3 SAS Procedures (REG, LOGISTIC and ARIMA) used to model Credit Risk at US Bank. Data requirements and preparation are key components, and some results will be presented.
2:30 SAS BI Content Syndication across the Enterprise with the REST Framework; Mike Vanderlinden, Senior Technical Manager, Experis
Abstract: This talk discusses a method to make the SAS BI content available to other parts of your organization through the HTTP protocol. Data, Information Maps, Metadata, Reports, Stored Processes can be made available to any system that can talk HTTP, whether it's a browser on your desktop, a Sharepoint website, a mobile device or anything else including a competitor's portlet. The REST framework is leveraged to provide the ability to reach SAS content with a zero-footprint client, as well as a powerful set of APIs to allow non-SAS developers to create rich interfaces.
3:15 Wrap Up
This event is free. SPACE IS LIMITED. Log in and go to the event page to see the full agenda and sign up for this meeting
| Attachment | Size |
|---|---|
| 01 DelGabbo - Excel.pdf | 698.52 KB |
| 03a Olson - Procs Copy & Append.pdf | 3.24 MB |
| 03b Olson truncate macro.txt | 6.37 KB |
| 04 Hoguas - Credit Risk Procedures.pdf | 77.77 KB |
| 05 Vanderlinden - BI Content Syndication.pdf | 1.66 MB |
