SCSUG 2012 SAS Presenters

Clinical Graphs using SAS 9.2

Do you wish you could create modern clinical graphs using SAS? Have you heard that it is difficult to create such graphs using SAS? If the answer is yes to any of these questions, this course is for you. This half-day course will cover, in detail, how to create the graphs used in Health and Life Sciences industry, including graphs commonly used for analysis of safety data for clinical trials. In this course, we will build many such graphs from scratch using the most appropriate graph tools from the ODS Graphics tool set, including SG Procedures and GTL.

Creating Complex Reports

This 3-4 hour seminar is based on the SAS Global Forum paper of the same name (http://www2.sas.com/proceedings/forum2008/173-2008.pdf ). This seminar is for intermediate SAS programmers. In the seminar, we will investigate how eight (8) complex reports were produced with SAS. All the code that produced the reports will be covered, in detail.  All report output is produced using ODS (rather than LISTING) output. The reports to be covered include three versions of a standard demographic report, producing a color-banded report with PROC TABULATE, producing a report which uses special fonts (Bissantz SparkFonts) to produce a sparkline report, several graph examples and several unique report ordering examples. Procedures/Topics to be covered include: REPORT, TABULATE, FORMAT, MEANS, FREQ, Macro processing and DATA _NULL_ programming (as used to produce the reports). Refer to the SAS Global Forum paper to see the actual reports which will be discussed in detail.    

Making Exploration of Nonlinear Models Fast and Easy Using JMP® 10

Nonlinear models are frequently encountered in applied technological areas such as the semiconductor and pharmaceutical industries. Defect density and pharmacokinetic models are two examples where fitting a straight line to data is inadequate or inappropriate. Exploration of these models is often tedious and time consuming, and model comparison is difficult. Through its Nonlinear platform, JMP 10 introduces a quick and simple way to fit multiple curves and explore competing models, streamlining the discovery process. Two detailed examples are given using data similar to that found in practice.

An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®

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 presentation 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 the ExcelXP tagset.  The techniques can be used regardless of the platform on which SAS software is installed.  You can even use them on a mainframe!  More in-depth information on this topic will be presented if time permits.

Applying Business Analytics to Optimize Clinical Research Operations

SAS is widely accepted as the gold standard for determinig saftely and efficacy for clinical trials, and it provides the primary mechanism for preparing data for traditional clinical research analysis activities. However, most SAS users in the biopharmaceutical industry are unaware of the broad range of SAS analytics that are widely applied in other industries. This paper discussed and describes how SAS business and advanced analytics can be used to design better trials, forecast patient-based activities, and optimize other operational processes. Applying business and advanced analytics to clinical trial operations represents a new and improved approach to reducing the cost and time associated with managing clinical research projects. As a result, the roles of SAS experts in thebiopharmaceutical industry are expanded.

Let Oil and Gas Talk to You: Predicting Production Performance

How do historical production data relate a story about the subsurface oil and gas reservoirs? Business analysts must perform accurate analysis of reservoir behavior using only rate and pressure data as a function of time. This paper introduces methodologies to forecast oil and gas production by exploring implementations of the AUTOREG, ESM, and MODEL procedures in SAS/ETS. The AUTOREG procedure estimates linear regression models when the errors are autocorrected. The ESM procedure generates forecasts by using exponential smoothing models. Examples of the MODEL procedure arising in subsurface production data analysis are discussed. In addressing these examples, thechniques for pattern recognition, implementing TREE, CLUSTER, and SISTANCE procedures in SAS/STAT are highlighted to explicate the importance of oil- and gas-well profiling to characterize the reservoir.

A Different Point of View with ODS PDF 9.3

Getting the Right Report (Again): Your Compatibility Guide for ODS PDF 9.2 ODS PDF in SAS® 9.2 looks and acts different from earlier versions. Why? What changed? How can I maintain the same look that I like? This paper written in collaboration with SAS® Technical Support and R&D will take commonly asked questions submitted to SAS Technical Support about ODS PDF and give you the answers. Once you understand how things work and why things changed, you'll have the tools you need to create that perfect report in SAS 9.2.

Tips, Tricks, and Strategies for Mixed Modeling with SAS/STAT® Procedures

Inherently, mixed modeling with SAS/STAT procedures, such as GLMMIX, MIXED, and NLMIXED is computationally intensive. Therefore, considerable memory and CPU time can be required. The default algorithms in these procedures might fail to converge for some data sets and models. This paper provides recommendations for circumventing memory problems and reducing execution times for your mixed analyses. This paper also shows how the new HPMIXED procedure can be beneficial for certain situations, as with large sparse mixed models. Lastly, the discussion focuses on the best way to interpret and address common notes, warnings, and error messages that can occur with the estimation of mixed models in SAS software.

Structural Equation Modeling Using the CALIS Procedure in SAS/STAT® Software

The CALIS procedure in SAS/STAT software is a general structural equation modeling (SEM) tool. This workshop introduces the general methodology of SEM and applications of PROC CALIS. Background topics such as path analysis, confirmatory factor analysis, measurement error models, and linear structural relations (LISREL) are reviewed. Applications are demonstrated with examples in social, educational, behavioral, and marketing research. More advanced SEM techniques such as the full information maximum likelihood (FIML) method for treating incomplete observations, robust estimation, and diagnostics for outliers and leverage points in the SEM context are also covered. This workshop is designed for statisticians and data analysts who want an overview of SEM applications using the CALIS procedure in SAS/STAT 9.22 and later releases. Attendees should have a basic understanding of regression analysis and experience using the SAS language. Previous exposure to SEM is useful but not required. Attendees will learn how to use PROC CALIS for (1) specifying structural equation models with latent variables, (2) interpreting model fit statistics and estimation results, (3) using the FIML method for treating incomplete observations, (4) and detecting outliers and leverage points.

ODS Document from Scratch

ODS Document From Scratch ODS Document is most likely the most under-utilized feature of ODS. ODS Document gives you the ability to customize the structure of your reports in ways that no other ODS features can. It enables you to store the actual ODS objects created when running a report which you can then later rerun without invoking the procedures from the original report. You aren't limited to simply regenerating the same report; you can change the order in which objects are rendered, the table of contents, the templates used, macro variables, and ODS and system options. Even if you don't consider yourself an ODS wizard, don't be afraid to take a peek at the features of ODS Document in this paper because we'll be taking it from scratch.

SAS ODS and ODS Graphics for z/OS

The System z provides many capabilities which provide real value to mainframe customers. Communicating the valuable information stored within mainframes to an audience now accustomed to high quality reporting is essential. z/OS®  provides a robust platform for data processing and automation and easily produces PDF, Excel, Word, and HTML documents with tables and graphics using standard batch processing and the SAS®  system. Learn about the sometimes overlooked capabilities of the IBM HTTP Server (httpd) combined with the z/OS® Distributed File Service zSeries® File System (zFS) to store and distribute PC Format documents created with SAS® ODS and SAS® ODS Graphics with BASE SAS® on z/OS systems.