05-23-2013 04:11 AM
My question is not so much about a statistical procedure as producing journal quality statistical tables using SAS output.
I have been using SAS for the past two years and everytime after manipulating my data and getting the results, producing good quality statistical tables is always a challenge. For example, using proc reg or proc GML to produce a journal quality statistical table is quite cumbersome. What I do now is when I get to this last stage of my empirical work, I switch to STATA and with little effort, I can produce a table that I can cut and paste into a word document for my paper.
I have searched on this forum and in the web for articles or discussions about this topic, but I don't seem to find anything. Am I missing something? Is SAS easy to use for producing journal quality statistical tables? Although I use ODS a little bit, I am certainly not an expert. At the moment, all my outputs are either excel or html using ODS, but they take a huge amount of editing to get to journal quality level.
Can someone enlighten me or pass me some links that talk about this issue.
05-23-2013 05:50 AM
A nice overview of ODS graphicsis is in the papers at ODS Graphics and Graphing Technical Papers, with my favorite overview being
Rodriguez, (2011): http://support.sas.com/resources/papers/76822_ODSGraph2011.pdf
Some presentation tips are at http://support.sas.com/resources/papers/proceedings10/237-2010.pdf
You don't specify what your issue is, but I assume that you just want more control over teh output, including the ability to add titles, reference lines, and so forth. There are two apporaches:
1) For minor changes to ODS output from a procedure, use the ODS Graphics Editor (p. 9 of Rodriguez 2011). A step-by-step example is available at Change a plot title by using the ODS Graphics Editor - The DO Loop
2) For more complex designs, I tell the procedure to output the results, and then use SGPLOT or SGPANEL to create the graphic. Most procedures have an OUTPUT statement an OUT= data set, or some other way to output predicted values, residual values, etc. You can also get data directly from ODS graphics that are produced (see How to get data values out of ODS graphics - The DO Loop)
Give it a shot. If you can get part of the way, posting more details to this forum will help answer remaining issues.
05-23-2013 09:09 AM
Using ODS one can create a table with almost any format and style you like. It does take a bit of time to learn the process. Here is a good explanation:
Other helpful paper: