BookmarkSubscribeRSS Feed
xxformat_com
Barite | Level 11

Hi,

I was doing some testing to figure out when to use flow='text'  (I'll write a separate post on the topic)

but I was surprised to see that embedded titles are removed when ods text is used.

 

Here is the code. Activate the ods text statement to see the difference.

 

ods excel file="&xxtest./reporting/ods_excel_test.xlsx" 
          options(embedded_titles='on');

*ods text ='This is a first example of a long string';

title 'This is a test';
proc print data=sashelp.class;
    var name age;
run;

ods text ='This is a first example of a long string';

ods excel close;

Is this something you would expect?

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 0 replies
  • 954 views
  • 0 likes
  • 1 in conversation