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 |
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.