|
Monday
Full Class Descriptions
|
| Using
SAS/GRAPH® Software |
|
This
seminar is designed for students who are familiar with the DATA and
PROC steps of base SAS and who want to learn how to use SAS/GRAPH software
to produce presentation quality graphs. The course will discuss various
aspects of the construction of graphs and will include discussion of
plotting and graphing procedures. Text statements and options used
to enhance the appearance of the graphs will be presented.
Presentation topics will include the use of graphics options, text
manipulations, the production of scatter plots and charts using AXIS,
PATTERN, and SYMBOL
statements. The attendee will learn graphics customization techniques,
the basics of the ANNOTATE facility, as well as how to replay and redisplay
graphs. The course contains examples of the creation of “drill-down” and
other forms of graphics that can be published to the web using tools
that interface with the Output Delivery System. Students will receive
course notes. |
Version
9 Changes & Enhancements:
The Details (Hands-On Class) |
|
| The
primary goal of Version 9 is to provide support for a new level of
computing with faster execution of applications, centralized access
of data and support of the latest computing technology. This course
is designed to show all of the changes and enhancements available in
Version 9 of SAS Software. We will discuss as many issues as possible,
from the installation of SAS to the finer aspects of operating and
programming under the new release. Students will have the opportunity
to try these new Version 9 features using computers provided in class.
Previous knowledge of SAS is required. Students will receive course
notes. |
Tuesday
Full-Day Class Descriptions
|
| Data
Manipulation Using the Data Step (Hands-On Class) |
|
| This
course is designed for SAS programmers who want a more in-depth understanding
of the DATA step. It also provides the tools for programmers to perform
various data transformations and summarizations, and read several types
of data sources. This course focuses on how to manage SAS data, work
with different data types, manipulate data, and create various reports.
Students will have the opportunity to apply these data management techniques
using computers provided in class. Upon completion of this course,
you should be able to read, create, and combine SAS data sets; summarize,
manipulate, and transform data; process data iteratively; create and
use arrays; understand how the DATA step processes work; and create
exception reports. Students will receive course notes. Prerequisite:
Base SAS programming experience. |
| From
%MACRO to %MEND: An Introduction to the SAS Macro Language |
|
This
course is designed for the SAS programmer who is new to the SAS Macro
Language. We will start at the basics and cover the fundamentals necessary
to start applying SAS macros in your programs. By the end of the day
you will understand how the Macro Language works, what the Macro Symbol
Table is and how values are stored in it, how the SAS System uses macro
variables, key macro language concepts, and how to invoke macros in
your programs. The example macros shown in the course materials demonstrate
the power and flexibility of this part of the SAS System and will enable
you to apply its functionalities to your own programs right away.
This seminar is suited for the SAS user who already has a basic understanding
of the DATA step and PROC steps, and who is new to the SAS System Macro
Language facility. It is a beginning-level course that assumes no prior
understanding of the SAS Macro Language. It is also suitable for SAS
users who want to understand the macros found in programs they have “inherited” from
other programmers. Each student will receive a copy of Carpenter's
Complete Guide to the SAS Macro Language, 2nd Edition as well as electronic access
to the tools, code, and examples contained within the book. |
Output
Delivery System
(The Basics and a Bit More) |
|
|
Do you
want to become proficient using ODS to improve the appearance of
your SAS output but don’t know where to start? Then this course
is for you. The course covers ODS styles and destinations and leads
the student through the steps needed to enhance the appearance of
their SAS output. Students also learn to use PROC TEMPLATE to create
and modify styles and table templates, which can be used to modify
the output produced by SAS procedures. The ODS ESCAPECHAR option
which allows for inline formatting in titles, footnotes, and data
values, is also explained. Students will receive a copy of Lauren
Haworth’s book, Output Delivery System: The Basics, an ODS
Quick Tips Guide prepared by Pete Lund, and additional PROC TEMPLATE
documentation.
|
Statistical
Data Mining Using SAS MACRO Applications -
Unsupervised and Supervised Learning Methods
|
|
Data
mining is a collection of analytical techniques used to uncover new
trends and patterns in massive databases. These data mining techniques
stress visualization to thoroughly study the structure of data and
to check the validity of statistical model fit to the data and lead
to proactive decision making. This full-day course covers fundamental
concepts for understanding and successfully applying statistical data
mining methods by using powerful SAS data mining applications. These
concepts will be illustrated via user-friendly downloadable SAS macro-call
files. The participants will learn: unsupervised learning methods including
exploratory factor analysis and k-mean cluster analysis, and supervised
learning methods including multiple and logistic regression, discriminant
analysis, and decision tree method using CHAID (Chi-squared automatic
interaction detection).
This workshop is intended for data analysts, predictive modelers, statistical
consultants, and bio-statisticians, who need to learn statistical data
mining techniques for increasing the effectiveness, efficiency, and productivity
of research and development. Participants are required to have an understanding
in basic statistical methods and an introductory working knowledge in
SAS systems. Students will receive Data Mining using SAS Applications and a printout of the slides. |
Saturday
Full-Day Class Descriptions |
| Advanced
Topics in the SAS Macro Language |
|
This
course is designed for students with a good understanding of DATA and
PROC steps and who already understand the basic structure and syntax
of the SAS Macro Language. The course starts with a short review of
the macro basics and quickly moves on to topics selected to improve
your macro language expertise.
We cover the use of macro libraries, several key macro functions, the
concepts needed in the dynamic programming environment, and the resolution
of macro variables in a variety of situations. The student is introduced
to the specification of macro variables through the use of the DATA and
SQL steps. Macro quoting functions and how to use them is also discussed.
The student learns how to use the macro language to obtain information
about SAS operating environments and how to apply and use this information
in SAS programs. All of the concepts of the course are explained through
the use of practical real-world examples. Each student will receive a
copy of Carpenter's Complete Guide to the SAS Macro Language, 2nd Edition
as well as electronic access to the tools, code, and examples contained
within the book. |
| Creating
Linked Web Pages with ODS |
|
| While
ODS is the best thing since - well - since SAS, there are some hidden
capabilities that need to be surfaced. Learn how ODS will automatically
create linkable, drilldown graphs and reports. This course will use
base SAS and SAS/GRAPH to show you how to automate the creation of
static reports that can be used on an intranet or even just located
on a network - no web server required! Learn the basics of ODS: how
to create HTML pages, using frames to display an index and table of
contents. Then watch as a complex web of static pages is gradually
built. A complete, reusable system is given so you can take it back
and begin as soon as possible. Beginners as well as advanced users
will see how to work “under the covers” of SAS to find
the data needed to create such a system. Macros, reporting and graphing
procedures are shown in this course to build an impressive system of
linked pages. Move that monthly report from boxes of paper or tons
of e-mails, to the web and bring it to life with graphs and all the
other features the web offers! Students will receive course notes.
Basic DATA step coding and basic understanding of ODS are required
for this course while basic knowledge of SAS macros is highly desirable. |
| SAS
and SQL |
|
| This
course covers both SQL as a language and its implementation in SAS
via PROC SQL. Topics include creating tables and views, inner and outer
joins and unions. Also included are subsetting data with WHERE and
HAVING statements and aggregating and summarizing data. Examples of
using PROC SQL to interface with other DBMS, directly and via ODBC,
will be covered as well. Comparisons of the efficiency of PROC SQL
and other methods of manipulating data in SAS, via procedures or data
step, will be given. At the end of the course, students will have an
understanding as to which scenarios may be appropriate for SQL processing
and the tools to write queries of medium complexity. Students will
receive bound course notes which contain an annotated version of the
course presentation. |
