The business of book writing: Developing the concept with Chris Holland and Jack Shostak

Developing a new concept for a book can be daunting, but it can also be very rewarding. Think about The Little SAS Book. I bet Susan Slaughter and Lora Delwiche didn’t know they were stumbling on a huge hit when they created that format.

I love to see authors create something new. So, when Chris Holland and Jack Shostak submitted a proposal for Implementing CDISC Using SAS: An End-to-End Guide, I was intrigued. When I saw the topic was on CDISC, I was thrilled because we’d never published a book on that topic. So to have a new concept for a new topic, we were really breaking new ground.

I wanted to know what it takes to develop a new concept, so I asked Chris and Jack, “How did you decide on the end-to-end concept? And what made it work for this topic?” Here is their answer, in their own words:

“To be honest, Chris was really the prime mover on this idea. SAS is widely used in the pharmaceutical industry and it is pervasive in the clinical trials data management, analysis, and reporting arena. It has also become prominent in CDISC data model production work. Chris had the idea to do an end-to-end book with regards to CDISC and SAS implementation, and I was honored that he would think of me so I took him up on the idea and opportunity. Two years later, here we are. The book covers an array of SAS offerings from JMP Clinical, to SAS Clinical Data Integration, to the SAS Toolkit, and even our old friend BASE SAS,” said Jack.

And Chris responded, “I guess I've been frustrated at times by the lack of CDISC adoption over the years.  You wouldn't know this necessarily from working on CDISC teams because those are, as we statisticians say, biased samples.  Having worked at FDA, I was exposed to data from a lot of different submissions - partly from my own projects but mostly from training work I did helping reviewers with their submissions.  There was really only a small portion of submissions that had CDISC-compliant data.  Though at the same time, I guess I could understand why certain organizations were reluctant to take the CDISC plunge.  The standards were, initially, not very stable and there was no real requirement to abide by them.  

But then, slowly, the stars came into alignment.  The standards stabilized (somewhat), SAS (and JMP) developed CDISC implementation and analysis tools, and my day-job workload lightened a bit.  It just seemed like the right time to try to put something out there that would make it harder for organizations to come up with excuses for not adopting to CDISC standards.  I thought that by going through the process, showing potential users not only what tools exist but also how to use them, and demonstrating some of the benefits that can be reaped after putting in the time to develop CDISC data, we might have a package of information that SAS users in the pharma industry might find useful.

I could not have done it alone though and Jack was the perfect “partner in crime.”  Twenty years ago at my first job out of college Jack was my mentor, a fellow Hokie, and still, to this day, one of the funniest people I've ever had the pleasure to work with.  Having been through the book-writing process before (on more than one occasion), being a long-time CDISC implementer, and having experience with some of SAS' CDISC tools made Jack the ideal accomplice.”

Post a Comment

New programs, new products, new opportunities

These activities may have been announced at SAS Global Forum, but they apply to a much broader audience!  And you can take advantage of them today. 

  • New Program:  Publications is pleased to announce that you can now use Training Points to buy books.  Training Points (previously known as EPTO's) is a pre-paid discount program that can save you money on training courses AND books.  See the link for more details or email Book Sales at sasbook@sas.com.
  • New Product: The first eBook only title from SAS Press is now available!  Don Henderson’s SAS Server Pages: Generating Dynamic Content shows SAS developers how to create custom interfaces for Web-based applications.  This enhanced book includes how-to videos and is now available from Apple’s iBookstore and Google Play.
  • New Opportunities:  Now there’s no excuse for putting off that SAS book you’ve always wanted to write!  A newly designed web site and simplified submission process make NOW the best time for you to Publish with SAS.  You’ll find sample book topics, easy submission forms and information about all the resources available to you from SAS to produce the next great SAS book!

Thank you for using SAS. Stay tuned for future posts about our products and services. And, as always, we welcome your feedback.

Post a Comment

SAS Server Pages: Generating Dynamic Content

SAS Server Pages were first introduced in Building Web Applications with SAS/IntrNet: A Guide to the Application Dispatcher using a DATA step to process them. PROC STREAM provides more robust support for SAS Server Pages and significantly expands SAS’ facilities for dynamic content generation.SAS Server Pages

SAS Server Pages are the Lego pieces, Lincoln Logs for the older among us, that can be used by PROC STREAM to build custom reports, user interfaces and more. My new eBook SAS Server Pages: Generating Dynamic Content provides insights and examples on what you, a SAS programmer, can do with PROC STREAM. It is currently available from the Apple Store and Google Play —and we hope to have a Kindle version available later.

For example, in Chapter 2, an overview is provided of what I call the Portal Reporting Framework, an application framework built on the foundation of SAS Server Pages and PROC STREAM. Recognizing that a picture is worth a thousand words, and a video is worth a thousand pictures, the e-Book only format of this book includes a number of embedded videos to show how to use these tools. For example, this is a short demo of the Portal Reporting Framework included in Chapter 2 (the video can also be found on my Author Page). See my blog posting for more details about the Portal Reporting Framework.

Another advantage of the e-book only format of this e-book is that the content can be easily expanded discussed via links to blog entries. In this book there are lots of examples with lots of possible variations of what can be done. They all can’t be described in one book (even if I, the author, or the reviewers, could think of them all). That is why many of the examples in the book have links to lists (using search) of blog entries on my blog Jurassic SAS® in the BI/EBI World, that allow me to expand upon the examples, including feedback from readers.

Now, I know that some of you are thinking, yea, but things change and links sometime break. But again, the e-Book format comes to the rescue. Under the covers in the book the links are actually short URLs. If someone finds that the target of that short URL is no longer available or broken, once known, it can be fixed. And voila, things work without have to deal with errata, updates, and so on.

I hope everyone reading this starts to follow my blog, Jurassic SAS® in the BI/EBI World, where I will continue to discuss what can be done with PROC STREAM and SAS Server Pages.

Post a Comment

Jazzing up the ODS DOCUMENT statement

PROC DOCUMENT by Example Using SASPROC DOCUMENT is one of the niftier tools in SAS. To get the most benefit out of it, you need to create a workflow that makes saving your work to the document effortless. This post discusses some things that can help you get more out of PROC DOCUMENT. It will show you how to direct your work to folders. To see many other ways the ODS DOCUMENT can make your life easier, take a look at my book PROC DOCUMENT by Example Using SAS.

Have you ever had the situation where your work requires you to run several analyses, each different in some minor way? PROC DOCUMENT can make it easy for you to organize such work by directing the output to folders as the SAS code runs.

To make using the document nearly effortless, use an abbreviation, or a shortcut key in your favorite text editor to put the following lines at the beginning of your code and ODS DOCUMENT CLOSE; at the end.

ods document name=_________._________
dir=(path=_____________ label= );
/* your code goes here */
ods document close;

The code for today's example comes from SAS for Mixed Models, Second Edition, by Ramon Littell, George Milliken, Walter Stroup, Russell Wolfinger, and Oliver Schabenberger. It's not necessary to understand the statistics; just that each variation of the procedure is saved to its own folder.

The first code sample illustrates how, if you repeatedly run similar analyses off the same source code, you can still keep your output well organized when you save each run to its on folder in an ODS DOCUMENT.

ods document name=sasuser.mmodel(write)
/* start a document */
dir=(path=\Type3 label='Outputs 2.1 and 2.2,
using the Analysis of Variance Method' );
/* specify a starting folder */

proc mixed data=bond covtest cl method=type3;
class ingot metal;
model pres = metal / ddfm=kr;
random ingot;
run;

/* you can change folders midstream */
ods document dir=(path=\reml label='Output 2.3,
using the REML method' );

proc mixed data=bond method=reml;
class ingot metal;
model pres=metal;
random ingot;
run;
ods document close;

With the work saved, you can print it out again to any destination and in any order - all without re-running the original analysis. Furthermore, with PROC DOCUMENT's WHERE= option on Document Paths, you can swiftly perform analyses that require output from multiple folders. Code sample 2 shows how you might use the document created in Code sample 1.

proc document name=sasuser.mmodel;
obbnote \reml#1\mixed\tests3 'REML Method';
obbnote \type3#1\mixed\tests3 'Analysis of Variance Method';
replay reml; /* only the reml stuff */
replay ^(where=(_name_ = 'Tests3')) / activetitle ;
replay same;
/* Compare */
quit;

The OBBNOTE statements give the output a little extra annotation in addition to SAS Titles. The screen shots show the output of the LIST and the second REPLAY statement. According to SAS for Mixed Models, Second Edition it’s intended that the two Fit Statistics be identical. Adding this habit into your work does two things; it documents your source code and it documents your output at the same time, making it easy to find the most relevant analysis in a pinch.

Post a Comment

The whys and hows of simulating data

Simulating Data with SASWhen I told a friend that the title of my new book is Simulating Data with SAS, she asked, “Why would anyone want to simulate data?”  To her, data are measured or surveyed. Data tell us how big, how often, and how many.  Data indicate people’s opinions about politics and breakfast cereals. Data are real.

So why simulate data? It’s an excellent question, which I address in Chapters 4 and 5 of my book. The short answer is that simulation offers a way to understand how sampling variability affects a statistic. In particular, simulation can tell you how the value of a statistic might change if you were to collect another sample of the same size. Simulation also enables you to understand how statistical techniques perform on data that are skewed or that are contaminated by outliers.

Professional statisticians understand the value of simulating data, so most of my book is concerned with how to simulate data efficiently.  Internet discussion forums are filled with examples of statistical programmers who lament “My simulation is taking too long to run! Can someone please help?” My book describes how to plan a simulation study and includes strategies for efficient and effective simulation.

Advanced practitioners will enjoy the chapters that show how to simulate univariate and multivariate data with specified properties. Do you need to simulate correlated data? I provide techniques for simulating from several important multivariate distributions. Are you designing an experiment and need to determine the sample size that will enable you to detect a specified alternative hypothesis with a required power? There are several examples of this type.  

A reviewer stated, "This book is a powerful learning tool and an indispensable aid to anyone who wants to use simulation methods in SAS.” I hope so. The book includes hundreds of SAS programs and about 80 graphs that visualize the results of computations. There are about 130 exercises.  Every program in the book is available for free from the book’s Web page.

Teachers can use the examples in Simulating Data with SAS to explain sampling variability. Students and researchers can use the strategies to plan simulation studies as part of their research projects. Practicing statisticians can use the techniques to understand the variability of complex statistics for which theoretical results are unavailable. And SAS programmers whose simulations are “taking too long to run” can now consult a reference book that shows how to simulate data efficiently.

Post a Comment

Headed to SAS Global Forum

It’s that time of year again, where I make my plans to head to SAS Global Forum. This year, the meeting is in San Francisco and, since I love this city, it makes me more excited than ever to meet with SAS friends.

This user conference is planned and organized by SAS users, led by the SAS Global Users Group Executive Board, of which I am a member. Most of the Board members are previous chairs of the conference, and all of us are passionate about making this conference the greatest gathering of SAS users anywhere in the world. The Executive Board gets a lot of help with logistics from SAS. In fact, they would tell you that they couldn’t have this conference without the company’s help. Kudos to everyone who has helped to put this conference together.

Here are some of the things you can learn about if you visit the Publications folks in the demo area:

  • how to get started quickly with the new SAS Visual Analytics
  • what’s new in SAS 9.4 and who should plan to migrate to it
  • enhancements to the SAS Programmer’s Bookshelf
  • several additions to the SAS Press library
  • our first eBook with embedded video examples
  • information on how to publish with SAS
  • how to use SAS Training points to purchase books
  • how international users can order books
  • and much, much more.

Of course, that’s just Publications stuff. Imagine the opportunities when you add R&D, Education, Technical Support, and the rest of SAS! If you are going to be there, please stop by the Publications booth in the demo area, or catch me at one of the functions. I’d love to meet you or see you again.

If you are unable to come this year, check out the live streaming of the general sessions and some of the invited papers.

And try to come next year if you can. It’s worth every second.

Post a Comment

SAS author's tip: Inputting data using text value positioning

In the Know...SAS Tips and Techniques From Around the GlobeThis week's SAS tip is from Phil Mason and his ever-helpful book In the Know...SAS Tips and Techniques From Around the Globe, Second Edition. When the book released in 2006, it received a lot of praise from the user community. This quote from SAS user Ron Fehd is a personal favorite: "Phil Mason, one of the SAS user community's famous creative tinkerers--the SAS user version of mild-mannered Clark Kent--has updated his 300-page first edition of SAS Tips and Techniques with the addition of a third more tips in this second edition."

Visit Phil's author page for more information and for bonus content.

The following excerpt is from SAS Press author Phil Mason's book "In the Know...SAS Tips and Techniques From Around the Globe, Second Edition" Copyright © 2006, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. (please note that results may vary depending on your version of SAS software).

 

 

 

Post a Comment

The book writing business: Tricia Aanderud and Angela Hall tackle reviewer comments

Welcome! It’s time for another installment of the Book Writing Business. We’ve talked about the writing aspect and how it can help one’s career. Some people feel overwhelmed at the thought of writing a book. But sometimes the actual writing of the book is the easy part. The tough part comes in the revision process, particularly when you get numerous review comments.

Overall, reviews are designed to point out things you may not have thought of before. Sometimes the reviewer corrects a mistake; more often than not, he or she just presents another way to think of things. But all of those comments can be tough to take, especially when you’ve poured your heart and soul into the book.

Building Business Intelligence Using SASTricia Aanderud and Angela Hall, authors of the popular book, Building Business Intelligence Using SAS, completed their book in record time…11 months! But it wasn’t without a few hitches along the way. They persevered, and produced one outstanding book.

I asked Tricia and Angela, “You received a substantial number of reviewer comments, a number that would throw most people off their game. How did you tackle those comments? And what kind of advice can you offer to others in your situation?” Here is their response:

"On some sections of the book, we got more comments than we expected. Some of the material seemed self-evident and the comments were confusing.  However we turned to Susan Slaughter who reminded us to consider what the crux of the comment might be.  Is it possible the reviewer is confused based on an earlier step? Would some additional details help?  Once we starting talking it through we were able to make changes that benefited the book overall," noted Tricia.

Angela explained, “Anyone who has programmed SAS code for a number of years knows that there are multiple methods to completing a task in SAS. The same is also true in the SAS Business Intelligence solutions. Our reviewers helped by providing other options and this allowed us to decide on modifying our approach to the solution, adding their approach as an alternative, or further explaining within the book why the method we wrote about worked best.”

Post a Comment

SAS author's tip: Creating a cross-tabulation table

SAS Statistics by ExampleThis week's SAS tip is from Ron Cody and his popular book SAS Statistics by Example. Ron is the author of many bestselling SAS books. If you like this week's excerpt, visit his author page for additional bonus content from his books!

The following excerpt is from SAS Press author Ron Cody's  book "SAS Statistics by Example" Copyright © 2011, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. (please note that results may vary depending on your version of SAS software).

 

Post a Comment

Learn how to become a published author at SAS Global Forum

Where do you go when you want to mix and mingle with like-minded folks? Where do you go when you want to share best practices and talk about the latest advances in software? If you’re a SAS user, the answer is SAS Global Forum in San Francisco.

And while in San Francisco, where do you go when you have an idea for a SAS book? Come to the SAS bookstore and share your idea with me (or Julie Platt or Stacey Hamilton, we’ll all be there). I’m hoping to talk to everyone who has an idea for a book. And, I’m making it as easy as possible for us to meet:

  • If you’re presenting, email me the details and I’ll add it to my agenda. I’ll make it to as many presentations as possible.
  • Let me know your availability for a 15 minute chat and we’ll meet up somewhere at the conference.
  • Just stop by the SAS bookstore and ask for me, Julie or Stacey

And the easiest way of all? I’m hosting an informal roundtable discussion on Monday at 6:00pm. Stop by the SAS bookstore during the Monday evening reception and be sure to join the discussion (it’ll only take 30 minutes and you can bring your food and drink with you).

If you want to attend, send me a note. I’ll share some documents with you and we can talk details during the roundtable. Why not get started on the idea now and get your specific questions answered?

Come on SAS users, keep me busy during SAS Global Forum. Let’s see how many proposals we can generate in 3 days!

Post a Comment