What’s so great about SPANROWS?

This post was kindly contributed by The SAS Training Post - go there to comment and to read the full post.

A customer just recently posted this on our Facebook page: “Dear SAS: Thank you for SPANROWS!” That question inspired me to write a quick blog that is not going to refer to Herman Melville or James Joyce in regard to learning SAS! I will return to those blog topics soon. But in the meantime . . . read on!

You may have wondered just what the SPANROWS option was used for and why we were being thanked for the SPANROWS option. Well, wonder no more.

The SPANROWS option is a new feature of PROC REPORT (new in SAS 9.2). But this is a “chicken and egg” explanation. In order to understand how wonderful SPANROWS is, you need to understand a basic difference between PROC REPORT and PROC TABULATE. Compare the two outputs below:





Continue reading “What’s so great about SPANROWS?”

This post was kindly contributed by The SAS Training Post - go there to comment and to read the full post.