BookmarkSubscribeRSS Feed
Sticky
Fluorite | Level 6

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

R

3 REPLIES 3
ballardw
Super User

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.

 

 

Sticky
Fluorite | Level 6

Its been preproduction for quite a while now.

R

Sticky
Fluorite | Level 6

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.

R

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 269 views
  • 0 likes
  • 2 in conversation