Denver SAS® Users Group

Next Meeting: Colorado Day

Friday, October 6th, 8:30am - 4:00 pm

Coohills, 1400 Wewatta St, Denver, CO 80202

Cost = $75


Click Here to Register for this Event

Presentations will include:

New for SAS® 9.4: Including Text and Graphics in Your Microsoft Excel Workbooks, Part 2 (PDF) – Vince DelGobbo, SAS
A new ODS destination for creating Microsoft Excel workbooks is available starting in the third maintenance release for SAS® 9.4. This destination creates native Microsoft Excel XLSX files, supports graphic images, and offers other advantages over the older ExcelXP tagset. In this presentation you will learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS® output. The techniques can be used regardless of the platform on which SAS software is installed. You can even use them on a mainframe! Creating and delivering your workbooks on-demand and in real time using SAS server technology is discussed. Although the title is similar to previous presentations by this author, this presentation contains new and revised material not previously presented. Using earlier versions of SAS to create multi-sheet workbooks is also discussed.

Step Up Your Statistical Practice With Today’s SAS/STAT® Software – Phil Gibbs, SAS
Has the rapid pace of SAS/STAT® releases left you unaware of powerful enhancements that could make a difference in your work? Are you still using PROC REG rather than PROC GLMSELECT to build regression models? Do you understand how the GENMOD procedure compares with the newer GEE and HPGENSELECT procedures? Have you grasped the distinction between PROC PHREG and PROC ICPHREG? This paper will increase your awareness of modern alternatives to well-established tools in SAS/STAT® by using succinct, high-level comparisons rather than detailed descriptions to explain the relative benefits of procedures and methods. The paper focuses on alternatives in the areas of regression modeling, mixed models, generalized linear models, and survival analysis. When you see the advantages of these newer tools, you will want to put them into practice. This paper points you to helpful resources for getting started.

Tips and Strategies for Mixed Modeling With SAS/STAT® Procedures – Phil Gibbs, SAS
Inherently, mixed modeling with SAS/STAT® procedures (such as GLIMMIX, 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 encore presentation of a paper from SAS® Global Forum 2012 provides recommendations for circumventing memory problems and reducing execution times for your mixed modeling 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.

Using SAS GTL to Visualize Your Data When There Is Too Much of It to Visualize - Nate Derby, Stakana Analytics
Developing a good graph with ODS statistical graphics becomes a challenge when input data map to crowded displays with overlapping points or lines. Such is the case with the Framingham Heart Study of 5209 subjects captured in the sashelp.heart data set, a series of 100 booking curves for the airline industry, and interleaving series plots that capture closing stock values over a twenty year period for three giants in the computer industry. In the paper, transparency, layering, data point rounding, and color coding are evaluated for their effectiveness to add visual clarity to graphics output. Version 9.2 compatible Graph Template Language (GTL) plotting statements referenced in the paper include HISTOGRAM, SCATTERPLOT, BOXPLOT, SERIESPLOT and BANDPLOT plus layouts OVERLAY, GRIDDED, DATAPANEL and LATTICE that produce single or multiple-panel graphs.

Report Building: SAS and Microsoft Word VBA Made Easy - Scott E. D. Kreider, MS, Rocky Mountain Poison and Drug Center (RMPDC)
Description: A series of synergistic, easy-to-use SAS and Microsoft Word VBA macros have been created to seamlessly work together to produce a nearly delivery-ready statistical report by incorporating style guide elements in order to reduce manual editing of reports and to reduce review time necessary for delivering a report. The dual-use of SAS and Microsoft Word VBA is not a new topic, however generating reports within SAS can be clunky and somewhat convoluted at times. These intuitive, easy-to-use, integrative SAS and VBA macros involve incorporating proper style guide editing using style tags, dynamic section, table, and figure numbering, and more. The underlying code is also easily updateable to allow for varying style guide characteristics.


Check us out and join our Group on LinkedIn:

The Denver SAS User group is open to all SAS users.  Please join us at one of our meetings to see if we can be helpful to you

DSUG is looking for sponsors! Click here to open the Call for Sponsors document.