Category: SAS

How much time will your process flow take to run?

SAS users, by definition, do not embrace the mysterious. That’s one of the main reasons that they use SAS: to demystify some data or process. And so, when you (as a SAS user) have gone to the trouble of designing a process flow in SAS Enterprise Guide, you like to […]

Building great graphs with Base SAS

~ Contributed by Lelia McConnel, Technical Support Consultant, SAS ~ Base SAS 9.3 has made creating high quality graphics output easier than ever. Did you know that you can create great looking, high resolution graphs with Base SAS? The Customer Suppor…

Example 9.31: Exploring multiple testing procedures

In example 9.30 we explored the effects of adjusting for multiple testing using the Bonferroni and Benjamini-Hochberg (or false discovery rate, FDR) procedures. At the time we claimed that it would probably be inappropriate to extract the adjusted p-v…

SAS Global Forum: Here’s the Wrap Up!

SAS Global Forum 2012 was a success! After a whirlwind week of activities followed by a vacation and week of rest – I’m ready to give you some highlights.  It was a lot of fun! Tip: Click on any picture to enlarge it. Day 1 – Saturday Ready for the Tweet-Up The biggest drama was at the airport – our flight was delayed due to mechanical failure so I decided it might be better to take a later flight. Met @Steve0verton at the airport and @PhilipB who were both headed to Orlando.  As a result of the later flight we were late to the Tweet-Up so we missed the first round of drinks.  It was sunset when we landed and the weather was mild – very nice for Florida. We had a lot of fun.  @WaynetteTubbs hosted the even and she had a trivia contest.  I won a LED key chain and some SAS Post-It notes.  I love Post-It notes. Plus I got to meet Anna Maria who writes the sassy Julia Group blog – she’s such a sweetie.  And Andrea Wainwright Zimmerman told me that she was the academic chair for SESUG in St. Pete, FL next year.  I may have to volunteer […]

New Book: The 50 Keys to Learning SAS Stored Processes

At the SAS® Global Forum 2012 last month I picked up a copy of “The 50 Keys to Learning SAS Stored Processes“, the latest book from the dynamic writing duo, Tricia Aanderud & Angela Hall. As it happens, my partner Michelle also wo…

Record-Setting Attendance for A Record-Appreciating Audience

Of course, I’m not referring to LPs and EPs here… that would be something this former Disc Jockey would certainly gravitate towards but I’m quite sure more of this blogs audience is actually more into data records.   Actually, come to t…

Transform a SAS data set to an Excel pivot table by VBA

Pivot Table in Excel is the popular data report format, which is similar to an OLAP cube that aggregates data at any dimensions. To create a pivot table for a table with lots of columns, it usually takes 100+ drags and clicks to get job done, which is…