ODS and Office Integration

ODS and Office Integration

‘ODS and Office Integration’  This paper is all about getting your SAS output into the Office application of your choice. It could be Excel or Word or Powerpoint. Or, maybe it’s just about sending your data to someone else.

read more

PROC REPORT, the Right Tool for the Job

PROC REPORT, the Right Tool for the Job

‘PROC REPORT, the Right Tool for the Job’ is a tutorial I gave by Request to the Hawaii SAS users group in 2006. It is proc report in a very compressed nutshell. It is really surprising just how much of Proc Report’s power can be revealed in a couple of hours. If you want a jumpstart on Proc Report, start with these examples! I even through in some tagset modifications for some really nice effects. [paper] Hawaii SAS Users group, 2006. This was a tutorial given especially for the Hawaii SAS user group’s  SAS day. It was really a tutorial and was almost two hours in length.  The examples progressed very logically and slowly revealed what you need to know to start using Proc Report to create amazing reports. Proc Report is amazingly versatile and powerful. Learn how to use it and your reporting life will be much easier. [/paper] ‘PROC REPORT, the Right Tool for the Job’  Covers a lot of ground.  Everything you need to know for basic reporting and then some. Compute blocks, computed columns, column aliases, analysis columns, noprint, style over rides, even computed urls for drill down reports. Then on top of it all using the slider and survey tagsets to create some really nice tables.  You may want to change the colors in the stylesheet from green, yellow and red to something else!  The slides are fairly straight forward, get the example code from my repository for the full story. Everything is available in my GitHub repositories. This paper as with all of my SAS papers is a available from my SAS-Papers github repository.   The example code for this paper can be found in my SAS-Examples github...

read more

The Beginner’s Guide to ODS MARKUP: Don’t Panic!

The Beginner’s Guide to ODS MARKUP: Don’t Panic!

“The Beginners Guide to ODS Markup: Don’t Panic!” is all about finding your way around with ODS Markup and Tagsets. I took a hint from ‘The Hitchhiker’s Guide to the Galaxy’ and wrote ‘Don’t panic’ on the front in nice friendly letters.

read more

SAS Reports of your dreams

SAS Reports of your dreams

‘The SAS reports you’ve always dreamed of’  came about because of all the people I helped and worked with. This paper is about common problems, great solutions, and the beautiful reports people were creating.

read more

ODS Tagset Spelunking and Cartography

ODS Tagset Spelunking and Cartography

‘ODS Tagset Spelunking and Cartography’ came about because I was always getting phone calls and emails from people just wanting to understand how tagsets worked so they could modify them and use them. The event driven model that tagsets used wasn’t easily accessible by many people. This paper was an attempt to shed some light on just how tagsets worked, and how to debug, modify, and otherwise bend them to your will.

read more