The Little SAS Book 6.0: The best-selling SAS book gets even better


Six editions is a lot! If you had told us back when we wrote the first edition of The Little SAS Book that someday we would write a sixth, we would have wondered how we could possibly find that much to say. After all, it is supposed to be The Little SAS Book, isn’t it? But the developers at SAS are constantly hard at work inventing new and better ways of analyzing and visualizing data. And some of those ways turn out to be so fundamental that they belong even in a little book about SAS.

Interface independence

One of the biggest changes to SAS software in recent years is the proliferation of interfaces. SAS programmers have more choices than ever before. Previous editions contained some sections specific to the SAS windowing environment (also called Display Manager). We wrote this edition for all SAS programmers whether you use SAS Studio, SAS Enterprise Guide, the SAS windowing environment, or run in batch. That sounds easy, but it wasn’t. There are differences in how SAS behaves with different interfaces, and these differences can be very fundamental. In particular, the system option that sets the rules for names of variables varies depending on how you run SAS. So old sections had to be rewritten, and we added a whole new section showing how to use variable names containing blanks and special characters.

New ways to read and write Microsoft Excel files

Previous editions already covered how to read and write Microsoft Excel files, but SAS developers have created new ways that are even better. This edition contains new sections about the XLSX LIBNAME engine and the ODS EXCEL destination.


From the very first edition, The Little SAS Book always covered PROC SQL. But it was in an appendix, and over time we noticed that most people ignore appendices. So for this edition, we removed the appendix and added new sections on using PROC SQL to:

• Subset your data
• Join data sets
• Add summary statistics to a data set
• Create macro variables with the INTO clause

For people who are new to SQL, these sections provide a good introduction; for people who already know SQL, they provide a model of how to leverage SQL in your SAS programs.

Updates and additions throughout the book

Almost every section in this edition has been changed in some way. We added new options, made sure everything is up-to-date, and ran every example in every SAS interface noting any differences. For example, PROC SGPLOT has some new options, the default ODS style for PDF has changed, and the LISTING destination behaves differently in different interfaces. Here’s a short list, in no particular order, of new or expanded topics in the sixth edition:

• More examples with permanent SAS data sets, CSV files, or tab-delimited files
• More log notes throughout the book showing what to look for
• LIKE or sounds-like (=*) operators in WHERE statements
• Grouping data with a user-defined format and the PUT function
• Iterative DO groups
• DO WHILE and DO UNTIL statements
• %DO statements

Even though we have added a lot to this edition, it is still a little book. In fact, this edition is shorter than the last—by 12 pages! We think this is the best edition yet. For a sneak preview check out the free book excerpt. You can also learn more about SAS Press, check out the up-and-coming titles, and to exclusive discounts -- make sure to subscribe to the newsletter.


About Author

Susan Slaughter


Susan Slaughter (left) is best known as one of the authors of The Little SAS Book. Her newest book, written with Rebecca Ottesen and Lora Delwiche, is Exercises and Projects for The Little SAS Book Fifth Edition. Susan discovered SAS software in graduate school over 30 years ago. Since then she has used SAS in a variety of business and academic settings. She has presented over 90 papers at local, regional, and international SAS user group conferences, and currently works as a consultant through her company, Avocet Solutions.


  1. I don't know how to find the file' using the sas studio interface :supplement to The Little SAS Book",someone could help me .... thanks!!!!

  2. Hello ! Sounds like a really great book as I have been using SAS for three years now and would need further improvements in the way I'm coding .

    Where can I purchase the book ?

  3. Michael Adams on

    Just purchased this as an e-book for Kindle. The book truncates the right side of the book! Never had this problem before. I am unable to read need portions of it... Please help...

    • Hi, Sorry to hear that. All our e-books pass the Kindle (mobi) verifier so I am not sure how we can help with how it is displaying on your Kindle. We have noticed that some of the older Kindles sometimes have issues now our books are designed to work on the newer models. If you would like to contact we can send you a web pdf.

  4. SAS how can I get better as SAS so that I can improve the chances of getting hire.

    Any suggestions?

    SAS As a tool to do the job as a credit risk analyst.

    Any advice please?

    • I think The Little SAS Book is an excellent start. For more advanced topics I would suggest the SAS Certification Prep Guide as well as the second edition of my Learning SAS by Example. If you want discuss this in more detail, please send me an email.

  5. Thank you, Susan, for keeping us up-to-date. The Little SAS Book is one of my favorite SAS books (it's like a SAS pocket book) and I am looking forward to get hold of the new edition. Or addition? 🙂

Leave A Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to Top