We publish a lot of books by SAS experts at SAS Press, but how does someone become an expert in the first place? Becoming certified is one step, but who develops the certifications in the first place? Those are the true experts. They have to have a deep understanding of
Tag: PROC REPORT
Not too long ago I had a report generation request from an Alaska state agency. The request had some very specific requirements that detailed the use of user defined colors (by name), data driven control of the report, and Excel delivery using ODS and PROC REPORT. Along the way I had
Did you inherit code that was written eons ago? Do you find old programs to copy the PROC REPORT code and then simply change the variable names for your new program? Have you wondered what all of those options do? Do you ever send output to the Listing destination (the
Like every SAS procedure, PROC REPORT generates error messages that are specific to that procedure. Some of these errors are easier to understand and work around than others. In this blog post, I show six of the trickiest errors, explain what might be causing the error, and give advice for
I’m a SAS user in the Pharmaceutical industry. I switched to the Pharmaceutical industry (from Marketing Research) four years ago and had a lot to learn! I started my new endeavor by purchasing some excellent SAS books, joining my local SAS user group, attending conferences (Michigan SAS User Group, PharmaSUG,
Dear Miss SAS Answers, In PROC REPORT can I use one calculated (computed) variable in the calculation of another computed variable? In the example below, I’m trying to use the value of the Bonus column to calculate the Total column: compute Bonus; Bonus =sal.sum*0.05; endcomp; compute Total; total=sum(sal.sum, Bonus.sum); endcomp;
Ron Cody and his supremely helpful book Learning SAS by Example close out our weekly SAS Author's Tip of 2011. Ron Cody is a household name in the SAS user community. And he deserves the moniker on his license plate of "SASMAN". Just mentioning Ron's name at user conferences incites awe. Sometimes
At least, that's according to my colleague, Rick Wicklin. In a recent blog post, Rick points out that estimating popularity based on results of Google searches is a bad idea. Well, that just disqualified my claim that PROC REPORT is more popular than PROC TABULATE, as measured via a GoogleFight.
The question came up on the SAS Enterprise Guide discussion forum: which do you prefer, List Report Wizard (PROC REPORT) or Summary Tables (PROC TABULATE)? And as with most SAS-related questions, the proper response is: "it depends." If you put these two PROCs in the ring with a Google Fight,
The SAS support site has a new example of how to create a Top N report using SAS. The Top N report is pervasive in our society. From the Billboard Top 100 to the New York Times Best Sellers list to the Forbes list of the 100 Richest Americans, the