Narrow miss at PharmaSUG 2015 for bestseller

Bill Benjamin’s bestseller, Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently, was pipped at the post as he narrowly missed the top spot to Implementing CDISC Using SAS: An End-to-End Guide, at last month’s PharmaSUG 2015 meeting in Orlando -- by one sale!

Here's the list of the top 5 bestselling SAS books at PharmaSUG: 

  1. Implementing CDISC Using SAS: An End-to-End Guide, Chris Holland & Jack Shostak
  2. Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently, William Benjamin
  3. Getting Started with the Graph Template Language in SAS: Examples, Tips, and Techniques for Creating Custom Graphs, Sanjay Matange
  4. SAS Programming in the Pharmaceutical Industry, Second Edition, Jack Shostak
  5. ODS Techniques: Tips for Enhancing Your SAS Output, Kevin D. Smith

Congratulations to Jack Shostak for appearing twice in the top five, and topping the sales together with Chris Holland! Mirroring the theme of the conference, the pharma titles did well and we should be seeing some pretty graphs and output if the other bestsellers are anything to go by.

A big thank you to all who came to visit the SAS press booth. We’re glad our exclusive SAS buttons and stickers were such a hit – please wear them with pride all you Data Divas and Data Dudes! We’ll be bringing them again to the Joint Statistics Meeting coming up in Seattle - so if you missed out in Orlando - make sure you get there early!


Inspired to write your own book for SAS? Then please contact us at

Post a Comment

Top 10 bestselling titles at SAS Global Forum 2015


SAS Global Forum bestselling author - William E. Benjamin, Jr.

The final figures are in! This year there was a fierce battle for the top spot of the SAS Global Forum 2015 books bestseller list.

In a nail biting finish, newcomer, Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently, beat off the all-time classic, The Little SAS Book: A Primer, Fifth Edition, and Art Carpenter’s latest,  Carpenter's Guide to Innovative SAS Techniques. On site sales showed a level setting but the off-site orders, using the special conference discount code, came pouring in and tipped the balance heavily in favor of Bill Benjamin’s Exchanging Data title.

Read More »

Post a Comment

3 reasons you need the new edition of PROC TABULATE by Example

PROC_TabulateWhat prompted me to find a co-author and write a new edition of my original book on PROC TABULATE? It’s those inventive developers at SAS. They keep adding new features to make the product even better.  There are too many new features and techniques in the book to name, but these are my top three reasons why you need to check out the new content:

  1. Percentages are now much easier

When I wrote the original book, to use percentages you had to figure out the denominator definitions by yourself. That created an entire chapter of complex explanations.  Now you can use ROWPCTN, ROWPCTSUM, COLPCTN, and COLPCTSUM to do row and column percentages with ease. The new edition shows how you can use these new statistic keywords to create clear and informative tables.

  1. The Output Delivery System (ODS) has matured as a product

There are so many new ways you can use ODS today. In the original book, written based on SAS v7, ODS was in its infancy and users were just beginning to understand its power. Today, with continued development at SAS, and many creative ideas contributed by users online and at conferences, this section is greatly expanded with new ways to make your output more professional and powerful.

  1. New tricks and cheats

No matter how good the developers at SAS, the SAS user community is always one step ahead. The new version of the chapter "PROC TABULATE Tricks: How to Cheat to Create Complex Tables” is full of ways to create customized output using clever workarounds.

Visit the book page for additional information, reviews and a free book excerpt.

Post a Comment

Macro Myth: The closest non-empty symbol table

Robert Virgile

Robert Virgile

This SAS tip is from Robert Virgile and his book “SAS Macro Language Magic: Discovering Advanced Techniques”.

We hope you find this tip useful. You can also read an excerpt from Virgile’s book.

When CALL SYMPUT creates a new macro variable, it places that variable in “the closest non-empty symbol table.”  But what does that mean?  And why does CALL SYMPUT exhibit such unusual behavior?

Read More »

Post a Comment

Get real clinical data

clinicalMany of our authors often ask us where they can find real data that they can use without copyright or other confidentiality issues. Instructors too are always on the look-out for real-life data.

Well, thanks to a new initiative supported by SAS, you can now access data from more than 40 studies and 25,000 patients from clinical trials of prostate cancer, breast cancer, and melanoma treatments. The list of available studies is growing rapidly! See for yourself.

Project Data Sphere, founded by the CEO Roundtable on Cancer, brings together leading pharmaceutical companies to share data and an analytics platform to investigate those data. In support of Project Data Sphere and the research community, SAS hosts the platform and provides access to SAS Drug Development and SAS Visual Analytics at no cost to researchers.  For most studies, data is already available as SAS data sets, consistent with CDISC/SDTM requirements and ready for analysis using the web-enabled analytics platform.  Students, professors, and others in the research community are welcome to join this growing community of clinical trial researchers in the fight against cancer.

So what better time to write a book with all this data to play with! I’m headed to Orlando, May 17- 20, for the annual PharmaSUG conference. I will be at the SAS Publications booth in the demo room and would love to talk to you about your book ideas, whether you want to write your own book, review a book, or suggest a book idea. We are actively looking to expand our offerings to cover a variety of pharmaceutical topics; and so if you have an interesting application or experience in using SAS solutions, then please consider sharing it as a short book.

Please do stop by the demo room at PharmaSUG 2015 or email me if you'd like to set aside some time to talk.

Post a Comment

Top 3 benefits of writing a SAS book

Many colleagues and customers at SAS Global Forum ask me, why I write books beside having a full-time job as SAS consultant and being lecturer at universities. Valid question.

  1. SUSTAINABILITY. I have been working in so many analysis projects in different domains and industries. Some of them were longer, others were shorter engagements, and I found out that I wanted to create and produce something that lasts for a long period of time and that is connected with my name. A book is definitely a good idea for this.
  2. YOU EDUCATE YOURSELF! Yes, the content of both of my books was known to me before I started writing. They are a collection of experiences from interacting with SAS Users in the field of analytics over many years. But a book forces you to structure the content, divide your ideas into chapters, formulate your experiences and ideas in an explicit way. After completing each book I felt more knowledgeable. And even more important: I was able to formulate my ideas, my knowledge and solutions more explicitly. And I often benefit of this experiences in customer meetings, presentations and discussions.
  3. YOU GET FEEDBACK. There are many rewarding moments when being a SAS Author: You are part of the community of SAS authors, you work together with the team of SAS Press and most important you get feedback from your readers. I receive emails from all over the world from readers who let me know how they used the ideas presented in my books. You are always happy to hear that readers like and use your work. You are also happy to hear if they suggest improvements as this shows that they really got involved with your work.

And the most rewarding moment for an author is to see customers holding his books in their hands.



Post a Comment

SAS Books is heading to PharmaSUG

PharmaSUG_2015_logo_200pxI’m headed to Orlando, May 17- 20, for the annual PharmaSUG conference. PharmaSUG is the Pharmaceutical Industry SAS Users Group, consisting of professionals worldwide in the pharmaceutical and healthcare industries who use SAS software in their work.

I will be at the SAS Publications booth in the demo room and would love to talk to you about your book ideas, whether you want to write your own book, review a book, or suggest a book idea. We are actively looking to expand our offerings to cover a variety of pharmaceutical topics; and so if you have an interesting application or experience in using SAS solutions, then please consider sharing it as a short book.

We will also be offering a special conference discount on books – including the best-selling classics: Analysis of Clinical Trials Using SAS; and; Analysis of Observational Health Care Data Using SAS; and exciting newer titles such as: SAS Programming in the Pharmaceutical Industry, Second Edition; and; Risk-Based Monitoring and Fraud Detection in Clinical Trials Using JMP and SAS.

Please do stop by the demo room at PharmaSUG 2015 or email me if you'd like to set aside some time to talk.

Post a Comment

Doctor, I have this friend who has a pain right about here

We have all heard the old joke about the person who sidles up to a doctor at a party and describes in great detail a medical problem a "friend" is having in order to get free medical advice.  It could just as easily be a person buttonholing an accountant for free tax advice, a lawyer for free legal advice, a personal trainer for free fitness advice, a CEO for free business advice, a chef for free cooking advice, a financial planner for free investment advice, a dietitian for free dietary advice, a college professor for free educational advice, and so on.  But, what about free SAS programming advice?

The good news is that if you have a question about SAS programming, you don't have to sidle up to a SAS expert and ask it in a roundabout way. There are a number of great venues where you can ask SAS technical questions directly and have them answered by SAS experts from the US and from around the world.  And, the only cost to you is the several hundred keystrokes you expend writing a concise description of your problem with supporting information such as:

  • The portion of your SAS program in question
  • A snippet of the log showing an error, if applicable
  • The version of SAS you are using
  • The operating system you are running SAS on

Here are some of the facilities available to help SAS professionals with their programming questions:

  • Support Communities on -- There are very active discussion groups with titles such as Base SAS Procedures, SAS Macro Language and Data Step, ODS and Base Reporting, and many more.  Users post their programming questions and then SAS experts from around the world and from SAS post possible solutions.  Questioners usually get many and varied answers to their questions.  This web-based community even has its own document titled "How to ask a Question in SAS Support Communities?" to help lead you through the process if you are new.  You can access the SAS Support Communities via this link.
  • SAS-L Listserv.  This oldest medium for SAS Q&A is realized as an email listserv.  You subscribe to the SAS-L listserv, and then when people post questions and answers, all subscribers get the messages.  SAS-L has a very loyal base of SAS experts who usually jump on questions immediately with answers from many different angles.  The web site has a good write-up on how to subscribe to SAS-L.
  • LinkedIn SAS Groups.  There are over a dozen SAS discussion groups on LinkedIn.  Some notable ones for Q&A are:  SAS Professional Forum, SAS Programming Tips, and SAS Author: Phillip R Holland.  These discussion groups are conducted much the same way as the previously mentioned Q&A sites, but also include articles of general interest to SAS programmers.  The LinkedIn home page is:
  • Code Clinics.  Most of the SAS Local Users Groups (LUGs) and SAS Regional Users Groups (RUGs) feature a "code clinic" at their meetings.  The code clinics are staffed with SAS programming experts who can help you with programming problems one-on-one.  They are expecting drop-ins, so bring your SAS questions and sidle-away.

There are doubtlessly other web sites and other facilities out there in the big wide world where SAS users will be glad to pitch in and help answer your questions. But, the list above is a good starting point.

Hey, as long as I have you here; I have this friend who is interested in competing in his first triathlon; you wouldn't happen to know anything about training for one would you?

Post a Comment

Meet SAS Press authors at SAS Global Forum

BOoksThis year SAS Global Forum attendees have the chance to have lunch with SAS authors and find out what it takes to write a book.

When: Tuesday, April 28, 12 - 12:50 p.m.

Where: Ballroom D2.

Lunch is provided!  We’ll talk a little about what it’s like to write a book and then open the floor for questions. And, those who attend the lunch will have a chance to win a copy of a book of their choice from the SAS Bookstore.

We are continuing to expand the SAS Press program - so if you're interested in writing a SAS book, or know someone who should write a book for SAS then please pop over to the SAS Press booth in the Quad and let us know -- or send us your author recommendations to

And don’t forget the SAS Author Roundup Tuesday at lunch! We look forward to seeing you in Dallas!

Post a Comment

Keep your hands off of my SAS data sets

I am all about sharing.  Knock on my door and I will gladly lend you a stick of margarine, a cup of sugar, an egg or two, some flour, a corkscrew, or a beer.  Not a problem to borrow a tie, one of my extra belts, a white shirt (if it fits), a scarf, or a pair of gloves.  Sure, I will gladly lend you one the books in my home library, a couple of my music CD's, or one of my movie DVDs.  I am reasonably sure that most of these items will either be returned to me in due time, or reciprocated, or paid forward.  But, keep your hands off of my SAS data sets!

I would bet that final sentiment regarding SAS data sets is pretty prevalent in organizations where SAS programmers work with shared storage resources.  Whether you are storing your SAS data sets in server directories or on network directories, you do not want to have them deleted, resorted, updated, or otherwise overwritten by other programmers on your team.  At least, not without your permission.

Fortunately, most organizations create security permissions that largely safeguard against unauthorized access of data.  They implement security packages--either native to the OS or purchased from vendors--to ensure that data is accessed only by those with the need to know.  Groups of programmers are given access to specific directories and other staff, with the exception of systems administrators, cannot get into them or see them at all.  Despite all of this protection, data integrity issues can come from programmers within your own group; programmers who have access to the same directories that you do; programmers who have the same access rights that you do.

Unfortunately, there is no foolproof way for you to keep your teammates from crunching your SAS data sets.  But, here are a few protection measures that you can put into place to help safeguard your SAS data sets:

  • SAS Data Set Passwords.  SAS allows you to specify ALTER, READ, and WRITE passwords.  Users must know the password in order to process password-protected data sets with SAS.  So, you can specify passwords for your do-not-disturb SAS data sets, wait for your co-workers to complain, and determine if they really do need access to those data sets.
  • ACCESS=READONLY Libname Option.  This option specifies that no data sets in the library can be updated and no new files can be written to the library.  This option can be effectively deployed in a shared group file.  If your colleagues grumble, tell them to copy the data sets in question to one of their libraries and process them there.  Caution them to be mindful of version control issues.
  • SAS Views.  Create views of your SAS data sets via the DATA step or PROC SQL and allow your colleagues to use the views instead of the actual data sets.  The beauty of this approach is that you can have your valued data sets in one directory and the views in another.  Point your coworkers at the views directory and do not tell them the whereabouts of the permanent data sets.
  • Generation Groups.  You can specify for SAS to keep several generations of your SAS data sets available.  Consequently, when one of them is modified, you will still have the older version available.
  • SAS Audit Logs.  SAS Audit Logs can be used to determine who updated SAS data sets after the fact. They don't stop your colleagues from actually updating SAS data sets, but you can use them to determine the who, what, and when so that you can storm into the right office for an explanation.
  • LOCK Statement.  You could use the LOCK statement to lock your SAS data sets so that no other SAS program can read or write to the file.  This is a bit extreme and would require that your SAS program with the LOCK statements be running for the duration of when you wanted to safeguard your SAS data sets.  This option can be effectively deployed in a shared group file.
  • Zip Files.  You could simply zip your SAS data sets up into zip files, delete the permanent SAS data sets, and restore the data sets from the zip files when you need them.  This is another extreme measure, but if your data sets get clobbered on a regular basis, you may find it more appealing than having them constantly restored.

Obviously, the best solution for keeping your important SAS data sets from being updated by your teammates is good communications between all involved, and a shared set of best practices for accessing and modifying SAS data sets.  But, when that is not available, you may have to reach for some of the ideas I have posted here.

Oh, and about that book that you borrowed from my SAS bookshelf library a couple of months ago... can I get it back?

Best of luck in all your SAS endeavors!

Have a great work-week!

Post a Comment