The SAS Output Delivery System and reporting techniques

Controlling ODS Excel Contents and Proc ANOVA

Reply
New Contributor
Posts: 2

Controlling ODS Excel Contents and Proc ANOVA

[ Edited ]

I'm preparing a fairly complex report that will be run to analyze multiple groups at certain points during the year. Most of the report relies on Proc Tabulate statements, but part of the report relies on Proc Anova. This report does use the contents='yes' option (and sheet_interval='proc)  to produce a table of contents, but I've hit a snag.

 

I have been (happily) able to control how the Proc Tabulate output displays using odsproclabel = "X" and contents="", with the end result looking like this:

 

Table 1

      Description of Table 1

Table 2

      Description of Table 2

 

When I get to the section that relies on Proc Anova, I get 18 rows that I don't need, describing every detail of Proc Anova. I've tried ods noptitle and ods noproctitle... but neither had an effect. I have not figured out a way of cleaning up this section of the Table of Contents:

 

image.png

Basically, I want to suppress all Table of Content entries from 'Data' to 'Pairs'. I still want to keep the output, but want a much more simplified TOC entry (similar to what is achievable in Proc Tabulate using "Contents=". This is what my code for the ANOVA currently looks like:

 

ods excel options (sheet_interval='bygroup');
PROC SORT
	DATA=WORK.ALL_GPA_NUMERIC(KEEP=term_gpa_num Group TERM_REPORTING)
	OUT=WORK.TMP0TempTableInput;
	BY TERM_REPORTING;
RUN;

TITLE;
TITLE1 "One-Way Analysis of Variance";
TITLE2 "Term by Term GPA by Group";

PROC ANOVA DATA=WORK.TMP0TempTableInput; ods noptitle; ods proclabel="Table 11a Term by Term GPA ANOVA Report"; 
	BY TERM_REPORTING;
	CLASS Group;
	MODEL term_gpa_num = Group ;
 	MEANS Group / TUKEY ALPHA=0.05;

RUN; QUIT;

Any ideas?

 

I'm running Base SAS 9.4_M3 and SAS STAT 14.1, both through SAS EG 7.15. 

Super User
Posts: 20,730

Re: Controlling ODS Excel Contents and Proc ANOVA

Posted in reply to davesailer

Do you not want the output or not want the entry in the Table of Content?

New Contributor
Posts: 2

Re: Controlling ODS Excel Contents and Proc ANOVA

I'm only looking to suppress the entry in the Table of Contents. 

Ask a Question
Discussion stats
  • 2 replies
  • 203 views
  • 2 likes
  • 2 in conversation