Category: SAS

Dump wide table to HTML report (SAS)

This SAS macro dumps a data set with many variables to an HTML report in a single line of SAS code. It’s useful on wide data sets (or in database speak, a wide table with many columns), with long character values, or where the customer needs to f…

One big, happy family at SESUG 2010

Randy Guard, Vice President, Sales Development & Product Management at SAS, gave the Opening Session keynote for SESUG on Sunday night. I’d never heard Guard speak before, so I didn’t know what to expect. He was surprisingly funny given h…

“It’s five o’clock somewhere”

Of all of the SESUG 2010 presentation titles, there are few with as much instant appeal as Sarah Woodruff and Toby Dunn’s It’s Five O’clock Somewhere. (Of course, you can’t discount Two Guys on Hash by Paul Dorfman and Peter Eberhardt.) …

Helping EG users to help themselves (and kill rogue SAS sessions)

I was lucky enough to sit though a presentation from CBA at the SAS Fourm in Sydney last month that described a set of tools they had created to manage their SAS enviornment and specifically the SAS processes that were running on their servers. I know of a few other large SAS sites that have […]

Certification Discussion on FaceBook

Hi all. Just a quick note to point out a recent certification discussion on the SAS Training Facebook page. If you haven’t become a fan of SAS Training, maybe now is the time? It’s yet another great community to chat with your fellow SAS users and…

Quebec City Analytics Forum: What A Launch!

I’m sitting here at Lesage airport in beautiful Quebec City, as Lady Gaga’s ‘Pokerface’ – the Muzak version – wafts gently out of the Duty Free store. And as I look around, I see a few others with raised eyebrows as they recognize the tune and the STRA…

Multi-study research on Bovine respiratory disease

Situation:The purpose of this research was to (1) to explore a recent multi-study approach (Arends, et al. 2008) in combining observational survival data instead of traditional meta-analysis, and (2) to develop multivariate random-effects models with o…

Using Proc Glmselect in SAS Shootout@ 2010

Business understanding: A Healthcare company would like to know how the health status and personal information of a patient would influence his/her total health care expense.Data understanding: The target variable is the total health cost (interval). B…