Ods excel options (sheet_interval='bygroup') ĭATA=WORK.ALL_GPA_NUMERIC(KEEP=term_gpa_num Group TERM_REPORTING)

This is what my code for the ANOVA currently looks like: 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='. I have not figured out a way of cleaning up this section of the Table of Contents:īasically, I want to suppress all Table of Content entries from 'Data' to 'Pairs'. I've tried ods noptitle and ods noproctitle. 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 have been (happily) able to control how the Proc Tabulate output displays using odsproclabel = 'X' and contents='', with the end result looking like this: This report does use the contents='yes' option (and sheet_interval='proc) to produce a table of contents, but I've hit a snag. Most of the report relies on Proc Tabulate statements, but part of the report relies on Proc Anova.

I'm preparing a fairly complex report that will be run to analyze multiple groups at certain points during the year.

How to do an anova in excel 2017