Proc Report and Proc Tabulate

Posted by www.sas9.blogspot.com on Monday, December 3, 2007

SAS® Reporting 101: REPORT, TABULATE, ODS, and Microsoft Office
Here is a pdf with clear instructions and uses of both.

Battle of the Titans: REPORT vs TABULATE
http://www2.sas.com/proceedings/sugi27/p133-27.pdf

www.laurenhaworth.com/publications/Reporting101.PPT

http://www.laurenhaworth.com/publications/ODSforPRT.pdf


Difference between Proc Report and Proc tabulate:

Proc Tabulate is a possibility to report statistical relations between variables in up to three dimensions (rows, columns, pages). You don't have too many possibilities to influence single cells, rows, columns, pages and not too much on the layout. The things you influence are alsways related to whole dimensions. If you want to have something like calculated columns, e.g. one is the difference of the 3 left of it, not possible. If you want to do it anyway, it's getting difficult. The main goal is to present summarized data-values in cells.

Proc report mainly is a listing procedure. Very strong features to influence the layout, also with ordering and grouping. The simplest form of a REPORT output is not a table, but a list, where the results of statistics is presenten in SUMMARY lines while the other lines contain the details. In addition, you HAVE influence on singel cells, rows, columns. You CAN relate columns and have calculated columns of them which are left of the new one. Cou can have influence on all rows with a DATA-step like programming language and you can influence single cells with that. E.g. a "traffic-lighting" dependant on certain limits is possible.


Proc Tabulate:

http://ssc.utexas.edu/docs/sashelp/sugi/24/Begtutor/p62-24.pdf
http://www2.sas.com/proceedings/sugi27/p060-27.pdf
http://www.albany.edu/~msz03/epi514/papers/anyone.pdf
http://www.laurenhaworth.com/publications/ODSforPRT.pdf
http://www2.sas.com/proceedings/sugi31/113-31.pdf



Proc Report:

http://www2.sas.com/proceedings/sugi31/052-31.pdf
http://www2.sas.com/proceedings/sugi31/116-31.pdf
http://www2.sas.com/proceedings/sugi31/235-31.pdf
http://www2.sas.com/proceedings/sugi30/244-30.pdf
http://www2.sas.com/proceedings/sugi29/088-29.pdf
http://www2.sas.com/proceedings/sugi29/242-29.pdf
http://www2.sas.com/proceedings/sugi28/015-28.pdf

This entry was posted on Monday, December 3, 2007 at 6:25 AM. You can follow any responses to this entry through the RSS 2.0. You can leave a response.

Post a Comment