Pre/Post-WUSS Full-Day Classes

Pre/Post full-day classes offer even more opportunity to expand your SAS knowledge. Full-day classes, available on Sunday, Monday and Friday, are $250 each if you register by August 24 and $300 each after August 24. .In some classes, attendees receive a book. In other classes, attendees need to purchase a textbook or bound course notes for an additional fee.

WUSS, Inc. reserves the right to cancel any pre/post conference class(es), and if said occurs, then WUSS' liability is limited to the refund of any registration frees paid for the canceled class(es).

 
Sunday Classes
August 30, 2009

8:30 am - 4:30 pm*

Instructor
From %Macro to %MEND: An Introduction to the SAS Macro Language Art Carpenter
Nitty Gritty of Proc Report Malachy (Mal) Foley
SAS Programming - Beyond the Basics Kirk Paul Lafler
Implementing CDISC SDTM and Define.xml Sy Truong

Monday Classes
August 31, 2009

8:30 am - 4:30 pm*

Instructor
Advanced Techniques in the SAS Macro Language Art Carpenter
Advanced Analytics and Predictive Modeling George Fernandez
Merging, Combining, and Subsetting SAS Data Sets
(Tricks, Traps, and Techniques)
Malachy (Mal) Foley
PROC SQL Programming: The Basics and Beyond Kirk Paul Lafler

Friday
September 4, 2009

8:30 am - 4:30 pm*

Instructor

A Health Outcomes Case Study: Data Management, Summary and Analysis Richard Read Allen
Advanced Reporting and Analysis Techniques: It's Not Just About Procs! Art Carpenter
Building Reusable Macro Tools with the SAS Macro Language Kirk Paul Lafler

*  Lunch is on your own
Note: The use of laptops and all recording devices is not permitted without the instructor's prior approval.

Sunday Full-Day Class Descriptions
 

From %Macro to %MEND: An Introduction to the SAS Macro Language Art Carpenter
Abstract: This one-day course is designed for the SAS programmer who is new to the 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 to store values in it, how the SAS System uses Macro Variables, key Macro Language concepts, important SAS Macro Language Functions, 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 the functionality of the Macro Language to your own programs right away. This session is suited for the SAS user who already has a basic understanding of the Data Step and Procedure Steps, and who is new to the Macro Language facility in SAS System software.  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.

Additional Fee: $40 for “Carpenter's Complete Guide to the SAS Macro Language, 2nd Edition”
Nitty Gritty of Proc Report Malachy (Mal) Foley
Abstract: One of the most powerful PROCs in SAS is PROC REPORT. Just this one procedure does the yeoman's work of PROC PRINT, SORT, FREQ, MEANS, and TABULATE, and PUT-Statement Formatting (DATA _NULL_) combined. This seminar is for anyone interested in getting started with, and using, PROC REPORT. Through examples, it completely examines how to produce listings through the PRINT, SORT and DATA _NULL_ aspects of PROC REPORT. It also provides an understanding of most of the FREQ, MEANS and TABULATE features of PROC REPORT. The course briefly touches ODS, and suggests an alternative way to create DOC files. Come experience what PROC REPORT can do for your SAS programming.

SAS Programming - Beyond the Basics Kirk Paul Lafler
Abstract: SAS users who have acquired basic skills presented in a SAS Software Basics course and want to expand their knowledge in the DATA step as a programming language will want to attend this SAS Programming – Beyond the Basics seminar. Attendees learn complex programming topics and techniques in the areas of data access, data manipulation, data management, data presentation, and much more. Topics include DATA step programming techniques including reading a variety of file formats; using column and line pointers; specifying system and language options; coding loops, ranges, and arrays; performing lookup operations with hash tables; using operators and modifiers; reshaping columns of data; techniques on managing data; custom report writing techniques; specialized ODS techniques for improved output, and testing and debugging techniques.

Implementing CDISC SDTM and Define.xml Sy Truong

Abstract: The regulatory requirements are going to include CDISC in the near future and the benefits are obvious. It is therefore wise and prudent to implement with techniques and processes refined from lessons learned based on real life implementations. CDISC standards have been in development for many years. There have been structural changes to the recommended standards going forward from version 2 to 3. It is still an evolving process but it has reached a point of critical mass that organizations are recognizing the benefits of taking the proposed standard data model out of the theoretical and putting it into real life applications. The complexity of clinical data coupled with technologies involved can make implementation of a new standard challenging. This paper will explore the pitfalls and present methodologies and technologies that would make the transformation of nonstandard data into CDISC efficient and accurate. It is important to have a clear vision of the processes for the project before you start. This provides the ability to resource and plan for all the processes. This is an important step since the projects can push deadlines and break budgets due to the resource intensive nature of this effort. The organization and planning for this undertaking can become an essential first step towards an effective implementation.

Monday Full-Day Class Descriptions

Advanced Techniques in the SAS Macro Language Art Carpenter

Abstract: This one day course is designed for students with a good understanding of the DATA and PROC steps and who already understand the basic structure and syntax of the SAS Macro Language.  The course will start with a short review of the macro basics and quickly move on to topics selected to improve your macro language expertise.  Several key macro functions will be introduced, explained and demonstrated.  Course topics include: Macro Language Review; Macro Functions, Using and Creating; Writing Dynamic Code; Controlling Your Environment; Working With SAS Data Sets; SAS Macro Libraries; Miscellaneous Macro Topics.

Additional Fee: $40 for “Carpenter's Complete Guide to the SAS Macro Language, 2nd Edition”

Advanced Analytics and Predictive Modeling George Fernandez
Abstract:  Data exploration and graphical data analysis methods stress visualization to thoroughly study the structure of data and to check the validity of statistical model fit to the data in advanced analytics and predictive modeling. This full-day course covers fundamental concepts for understanding and successfully applying data exploration and graphical data analysis methods in advanced analytics and in predictive modeling by using the powerful userfriendly SAS macro applications. These concepts will be illustrated via user-friendly SAS macro files. The participants will learn advanced analytical methods used in exploratory factor analysis, k-mean cluster analysis, multiple and logistic regression. This workshop is intended for data analysts, predictive modelers, statistical consultants, and bio-statisticians, in advanced training in data exploration and graphical data analysis methods 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 software.

Merging, Combining, and Subsetting SAS Data Sets (Tricks, Traps, and Techniques) Malachy (Mal) Foley
Abstract: This seminar discusses over 30 common errors in merging, combining, or otherwise manipulating data.  All of these errors result in erroneous data. Most of them occur with no SAS message or warning!  In addition to examining errors, this covers a wide range of topics such as interleaving, subsetting, concatenations, the IN= data set option, BY groups, FIRST.variable, program data vectors (PDV), finding duplicate records, collapsing files, overlapping variables, random access, Cartesian products, one-to-one merges, match merges, and fuzzy merges.  The course starts with the basics and continues to build up to complex and tricky examples of data set manipulation. The only prerequisite for the course is a working knowledge of the SAS DATA Step.  Yet, this workshop will give intermediate and advanced programmers a great review and some surprises.  Come see what mysteries lurk in manipulating SAS files!
PROC SQL Programming: The Basics and Beyond Kirk Paul Lafler
Abstract: This course expands your PROC SQL programming skills using numerous examples and techniques of this powerful database language. Topics include strategies for creating and using virtual tables known as views, using case expressions to perform conditional logic and reclassification of data values, database design concepts including basic normalization rules, examples of implementing table integrity constraints, accessing information contained in readonly dictionary tables, interfacing PROC SQL with the Macro facility to create macro variables and macro variable lists, rules associated with index creation and usage, undocumented and hard-to-find PROC SQL features for debugging and performance purposes, complex queries using inner and outer join constructs including set operators, and performance tuning strategies.
Friday Full-Day Class Descriptions
 

A Health Outcomes Case Study: Data Management, Summary and Analysis Richard Read Allen
Abstract: This seminar will present the summary and analysis of a health outcomes study, beginning with reviewing the requested analysis plan from the investigator, to setting up analysis datasets from various sources, to producing summary tables/figures and finishing up with testing some basic hypotheses on the data. Some programming techniques to perform these tasks for these types of studies will be presented, including the basic use of hashes and DOW loops to obtain the desired datasets, tables, figures and analyses. A study of Impact of Benefit Designs on Medicare Part B Plans will be used as an example, but the techniques can be applied to similar research studies. They also can be applied in Phase IV studies.

Advanced Reporting and Analysis Techniques: It's Not Just About Procs! Art Carpenter

Abstract: There are literally hundreds of techniques used on a daily basis by the users of SAS® software as they perform analyses and generate reports. Although often obscure, most of these techniques are relatively easy to learn and generally do not require specialized training before they can be implemented. Unfortunately a majority of these techniques are used by only a very small minority of the analysts and programmers. They are not used more frequently, because a majority of SAS users have simply not been exposed to them. Left to ourselves it is often very difficult to ‘discover’ the intricacies of these techniques and then to sift through them for the nuggets that have immediate value. This one day course presents a series of those nuggets. It covers a broad range of SAS topics that have proved to be useful to the intermediate and advanced SAS programmer that is involved with the analysis and reporting of data. The intended audience is expected to have a firm grounding in Base SAS. For most of the covered topics, the course will introduce useful techniques and options, but will not ‘teach the procedure’.

The course includes options and techniques associated with: MEANS/SUMMARY, User Defined Formats,
REPORT Compute Blocks, The Macro Language, Output Delivery System, ODS, Operating System Interfaces, DATA Step Functions and Options, . . . . much, much more

Building Reusable Macro Tools with the SAS Macro Language Kirk Paul Lafler
Abstract: The SAS® Macro Language is a powerful feature for extending the capabilities of the SAS System. This course presents a collection of techniques for constructing reusable and effective macros tools. Attendees learn how to build functional macros that process statements containing SAS code; learn basic design principles in the development of reusable macro tools; create macros containing keyword and positional parameters; utilize defensive programming techniques; build a library of macro utilities; interface the macro language with the SQL procedure; and develop efficient and portable macro language code.