ODS Tagset excel - Titles for Columns

[West26]

Guys,

I am trying to create an excel report, by using ods tagsets.excelxp.

Title1:I got this	Title2: Ineed this	Title2: I need this
Month	Previous Month	Future Month
Mar	Feb	Apr
Apr	Mar	May

ods tagsets.excelxp file="...\abc.xml" options(embed_titles='yes');
title "I got this";
proc print...;
run;
ods tagsets.excelxp close;

What changes, do I need to do for the code, if I want Title2 and Title3, respective to Previous Month and Future Month Columns?

Thank YOU

[ArtC · Accepted solution]

One easy way to control your text is to use PROC REPORT.

title;
proc report data=sashelp.class;
column ('i got this' name) ('second' age) ('third' sex);
define name /display 'insteadofname';
define age / display 'insteadofage';
define sex / display 'insteadofsex';
run;

This avoids any tagset issues.

[West26]

hi ArtC

Thanks for your time. But I need titles above the columns. I'm able to generate the first Title. So, for the column2, 'Previous Month',  I need the title as "I need this". Is there a way to do so?

Title1:I got this	Title2: Ineed this	Title2: I need this
Month	Previous Month	Future Month
Mar	Feb	Apr
Apr	Mar	May

[ArtC]

Did you execute the REPORT step? In what way does the PROC REPORT not place the text as you requested? Must the text come from a TITLE statement?