BookmarkSubscribeRSS Feed
iank131
Quartz | Level 8

Hi,

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.

Thanks

Ian.

4 REPLIES 4
Rick_SAS
SAS Super FREQ

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.

Rick_SAS
SAS Super FREQ

Sorry. My mind was read "graphics" but your words said "tables." Smiley Sad

Jay54
Meteorite | Level 14

Can you clarify whether you are referring to the tabular output from various stat procedures or statistics tables inside the graphs.

lvm
Rhodochrosite | Level 12 lvm
Rhodochrosite | Level 12

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:

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

Other helpful paper:

http://www.nesug.org/proceedings/nesug03/ad/ad001.pdf

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 2373 views
  • 0 likes
  • 4 in conversation