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
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.
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.
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 |
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.