I've a code like below. When I run this proc report, .xml appears as attached. If you see the attachment, you can see that second line is only half coloured, but I would like to get a colour for a complete line as like first line. How to do that? Please advise.
ODS tagsets.excelxp file='/usr/sas/tir/work/log_table.xml' style=statistical
options(autofilter='ALL' sheet_name='log_analysis' sheet_interval='none' embedded_titles='Yes');
title;
title1 'Log Analysis Report';
proc Report data=log_table box nowd missing out=work.log_table_final
style(header) = {background=white foreground=black FONT_WEIGHT = bold bordertopcolor=black borderleftcolor=white
borderrightcolor=white borderbottomcolor=black};
columns fname1 Date_TimeStamp1 date Status processid1 userid1 Details;
define fname1/style(header)=[background=lightgreen] width =45 display;
define Date_TimeStamp1/"Date Timestamp1" style(header)=[background=lightgreen] width =16 display;
define Date/style(header)=[background=lightgreen] width=16 display;
define Status/ style(header)=[background=lightgreen] width =5 display;
define processid1/ style(header)=[background=lightgreen] width =10 display;
define userid1/ style(header)=[background=lightgreen] width =20 display;
define Details/style(header)=[background=lightgreen] width =60 display;
run;
ods tagsets.excelxp close;
ods listing;
ods listing close;
There is nothing attached.
I could not attach
I tHink witHout attaHment also someone Can understand my question.
You attached a Photo to illustrate this .
Hi, not sure what you want to do with the title versus the headers. But as an addition comment, options like BOX and WIDTH= are ignored by ODS destinations, since they are LISTING-only options. Also, I am not entirely sure that ODS TAGSETS.EXCELXP will even use your bordertopcolor, borderbottomcolor, etc styles. I think that may be ignored as well. You might want to work with Tech Support on this.
cynthia
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.