topic Re: ODS Tagset excel - Titles for Columns in SAS Programming

ODS Tagset excel - Titles for Columns

West26 — Fri, 28 Apr 2017 22:19:39 GMT

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

Re: ODS Tagset excel - Titles for Columns

ArtC — Fri, 28 Apr 2017 23:05:41 GMT

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.

Re: ODS Tagset excel - Titles for Columns

West26 — Fri, 28 Apr 2017 23:19:15 GMT

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

Re: ODS Tagset excel - Titles for Columns

ArtC — Sat, 29 Apr 2017 01:23:10 GMT

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?