topic Re: ODS word titles with proc ttest in SAS Programming

ODS word titles with proc ttest

Sticky — Fri, 01 Jul 2022 05:18:08 GMT

Hi found a problem with ODS word with Proc ttest. when you have more than one analysis variable the title doesn't change from the first one.

For example if you have code something like this:

ods word file='junk.docx';

proc ttest data=screen;
var SCREEN_B_WDHR SCREEN_B_WEHR;
class NAPLAN3_R_NMS;
title 'Screen time ';
run;

ods word close;

When the analysis variable changes to SCREEN_B_WEHR the title still says the first variable, ie SCREEN_B_WDHR, which makes the output confusing to read.

It can be overcome by including the option 'options(body_title="yes")' in the ODS word statement, but that seems a bit clunky.

For it to work it would need a section break when the variable changes.

Regards

Re: ODS word titles with proc ttest

ballardw — Fri, 01 Jul 2022 08:59:51 GMT

ODS Word is preproduction. That means it is still in testing and development.

Use ODS rtf instead. Use your word processor software to open and save as if you need Docx file format.

Re: ODS word titles with proc ttest

Sticky — Sun, 03 Jul 2022 05:59:22 GMT

Its been preproduction for quite a while now.

Re: ODS word titles with proc ttest

Sticky — Tue, 05 Jul 2022 04:17:50 GMT

The same occurs with ODS EXCEL even though every table is on a separate sheet. ODS excel is not labelled preproduction so I would call this a bug.