9:00
a.m.
|
Welcome and Introductions
|
TCASUG Board |
9:15
– 10:15 a.m.
|
Getting Started with PROC DOCUMENT
and ODS
Do you ever have to rerun your SAS procedures
just to customize their output? Do you wish you could easily save your
text, tables, and graphs, and later re-render them at your convenience?
With the SAS 9 DOCUMENT procedure, you can! This presentation will show
you how to create an archive (ODS document) of your output with the
ODS DOCUMENT destination. You will learn how to browse and modify an
ODS document, and how to "replay" it to get RTF, HTML, PDF,
or any other ODS output format on demand. The basic commands for manipulating
ODS documents will be described in a step-by-step fashion. In addition
you'll learn how to use an ODS document to customize the ODS table of
contents (TOC). TOC customization is a capability frequently requested
by users. This presentation will benefit ODS users of all experience
levels.
|
David Kelley, Senior Software Manager,
SAS Institute |
10:15
– 11:00 a.m.
|
Romancing Your Data: The Getting
to Know You Phase
Have you ever gained access to an Oracle® database only to find yourself asking these questions?
“What’s in this database?”
“Where do I start?” “What do I actually have access to in the database?”
“What uniquely defines a record in this table?”
“Is this table Indexed, and if so, what is it indexed on?”
“Is this table Partitioned?”
The ability to gather and store large amounts of data has become commonplace, across industries. As these capabilities have grown, so has database complexity. The deluge of corporate acquisitions further complicates things, driving more and more undocumented data sources into the hands of new database users, often without the institutional knowledge to go with them. In these cases, the analyst must typically be his or her own data sleuth, developing the ability to discover the complexity of a database on their own before engaging in serious analytics.
This paper focuses on Oracle® databases and use of SAS/ACCESS® Interface to ORACLE to explore the Oracle Data Dictionary Views containing the database metadata. In particular, we focus on metadata summaries of interest to a user new to the database. The metadata is presented via a series of programs utilizing Base SAS®, specifically The SQL Procedure and The Macro Language. The delivery of output will also include a treatment of SAS® Output Delivery System.
The target audience for this paper includes Statistical Modelers and Business Analysts, or anyone else who uses Oracle databases to solve business problems. Some basic understanding of Base SAS PROC SQL, Macro Language, and the SAS/ACCESS Interface to ORACLE product is helpful, but not required.
|
Carole Jesse, Independent Consultant |
11:00 a.m.
–11:40 p.m.
|
Choosing the Right Tool from Your
SAS® and Microsoft Excel Tool Belt
There are over a dozen ways to bring
your data into Microsoft Excel and to push it out to Excel. Some are
simple wizards, and others are more complex programming techniques.
How do you know which tool is the best for your application? Which will
cause you the least number of headaches? Which will produce the quickest,
most accurate results? Which will best satisfy the end user? We will
give an overview of import and export techniques for Excel and make
recommendations for different application types.
|
Jennifer First, System Seminar Consultants |
11:40
– 1:15 p.m.
|
Lunch - Enjoy any of the many food options available on the University of Minnesota campus. |
|
1:15
– 2:00 p.m.
|
Principal Component Analysis (PCA)
and other Multivariate Statistical Analysis Techniques in SAS
Today's data sets often have dozens,
hundreds, or even thousands of variables. Such high dimensionality poses
many challenges. One of most popular approaches for analyzing such high
dimensional data sets is dimensionality reduction, which represents
the original data set with a smaller number of variables or new variables.
In turn, Principal Component Analysis (PCA) is one of the most well-established
techniques for dimensionality reduction, and is often used for exploratory
data analysis. This tutorial will present the basic idea of PCA and
demonstrate how to use it in SAS. We will also briefly overview some
other multivariate analysis techniques as time allows.
Some knowledge of SAS and basic statistics is the prerequisite for this
course.
|
H. Runesha Birali, MSI, University
of Minnesota
|
2:00
p.m.
|
Break |
|
2:15
– 3:00 p.m.
|
What’s New in ODS in SAS® 9.2
The 9.2 release of SAS® includes new
features of particular interest to Output Delivery System (ODS) and
Base reporting users. These features offer increased control over
the integration, content and presentation of procedure output.
Among the new features covered are:
- Inline formatting for rich
text in titles, footnotes and table cells
- New TrueType fonts for portable
reporting
- ODS RTF tagset for customizable,
vertically measured RTF
- Support for text decoration
(underlining) in RTF, PDF, and HTML
- PROC REPORT SPANROWS option
for repeating variable values across page breaks
The desired outcome is for audience
members to begin thinking about how they will exploit this new functionality
in future applications.
Familiarity with ODS is highly recommended.
|
David Kelley, Senior Software Manager,
SAS Institute |
