topic Re: looking for a Book for Learning Proc Report, Proc Tabulate and ODS in SAS Enterprise Guide

looking for a Book for Learning Proc Report, Proc Tabulate and ODS

hwilson — Wed, 02 May 2018 13:56:50 GMT

Looking for suggestions for a good book to use for a reference and learning Proc Report/Proc Tabluate and ODS. Preferrable looking for something that I can use to help new team members become familiar with these tools in SAs.

Thank you!

Re: looking for a Book for Learning Proc Report, Proc Tabulate and ODS

PaigeMiller — Wed, 02 May 2018 14:30:43 GMT

Your favorite search engine finds many such books.

Re: looking for a Book for Learning Proc Report, Proc Tabulate and ODS

Reeza — Wed, 02 May 2018 15:00:44 GMT

For PROC REPORT I would search LexJansen.com with Cynthia Zender's and/or Art Carpenter name and read some of those papers.

Papers:

http://www2.sas.com/proceedings/forum2008/173-2008.pdf

https://support.sas.com/resources/papers/proceedings17/SAS0431-2017.pdf

http://support.sas.com/resources/papers/proceedings13/366-2013.pdf

Book:

https://www.sas.com/store/books/categories/examples/the-sas-programmer-s-proc-report-handbook-basic-to-advanced-reporting-techniques/prodBK_69155_en.html?storeCode=SAS_US

PROC TABULATE

Papers:

http://www2.sas.com/proceedings/forum2008/173-2008.pdf

http://www2.sas.com/proceedings/sugi30/258-30.pdf

Book:

https://www.sas.com/store/books/categories/examples/proc-tabulate-by-example-second-edition/prodBK_64193_en.html

@hwilson wrote:

Looking for suggestions for a good book to use for a reference and learning Proc Report/Proc Tabluate and ODS. Preferrable looking for something that I can use to help new team members become familiar with these tools in SAs.

Thank you!

Re: looking for a Book for Learning Proc Report, Proc Tabulate and ODS

Cynthia_sas — Wed, 02 May 2018 23:46:48 GMT

Hi:
Thanks @Reeza for including me in Art's company.

In addition to those suggestions, our Report Writing 1 class covers REPORT, TABULATE and ODS: https://support.sas.com/edu/schedules.html?ctry=us&crs=RPT1 and this class https://support.sas.com/edu/schedules.html?ctry=us&crs=SASXL covers using Excel-based ODS destinations and PROC EXPORT to get output into Excel.

Cynthia

Re: looking for a Book for Learning Proc Report, Proc Tabulate and ODS

TomKari — Thu, 03 May 2018 15:18:50 GMT

A couple of years ago, I took on a contract where I was going to have to format a report in excruciating detail, having had little experience doing this previously. I bought Art Carpenter's "Carpenter's Complete Guide to the SAS REPORT Procedure", and I thought it was absolutely wonderful. Hugely assisted me on my project.

Tom

Re: looking for a Book for Learning Proc Report, Proc Tabulate and ODS

Quentin — Thu, 03 May 2018 15:41:23 GMT

Agree with all the suggestions. Since the question mentions ODS, wanted to add my ODS bible has been:

https://www.sas.com/store/books/categories/examples/output-delivery-system-the-basics-and-beyond/prodBK_61686_en.html

Speaking of which, @Cynthia_sas, when I was at SGF I saw the book on display and said to the pubs folks "I love this book, do you know if there is any hope of a second edition?" And they said "That's a great idea. You should ask the authors." So, any hope?

Re: looking for a Book for Learning Proc Report, Proc Tabulate and ODS

Cynthia_sas — Thu, 03 May 2018 16:22:21 GMT

Hi,
Ha! That book was the second edition. Lauren wrote the first edition by herself. As for a 3rd edition, I don't know -- except for new screen shots, ODS PowerPoint and ODS Excel and a few other things, the basic information in that book is still good. It's something to consider.

Cynthia

Re: looking for a Book for Learning Proc Report, Proc Tabulate and ODS

Cynthia_sas — Thu, 03 May 2018 16:30:57 GMT

HI, I agree...Art's book is great! Lisa Fine's book is really good, too for the way she dives into the report construction from beginning to end. And, I am a fan of Jane Eslinger's books, too. Poor PROC TABULATE only has 1 book -- This one is by Lauren and Julie McKnight) and it is good too -- https://www.sas.com/store/books/categories/examples/proc-tabulate-by-example-second-edition/prodBK_64193_en.html (and a bunch of papers on www.lexjansen.com on TABULATE)

cynthia

Re: looking for a Book for Learning Proc Report, Proc Tabulate and ODS

hwilson — Thu, 03 May 2018 18:32:59 GMT

Thank you all so much for the recommendations! I will look into these and see what we can order.