[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Nesting header background color and pleace two reports side by side in the excel
From:       Baba s <sairamhello0328 () GMAIL ! COM>
Date:       2015-09-30 20:03:16
Message-ID: 8402486220878601.WA.sairamhello0328gmail.com () listserv ! uga ! edu
[Download RAW message or body]

Hi,

Below is code to generate excel report and I have problems as below.
1. I need to specify background color to nesting headers.First row is for blue and second row is for red.
2. I need to place another report besides existing report which is one column after the existing report.

Please do needful.

data x1;
set sashelp.shoes;
run;
OPTIONS NODATE NONUMBER nobyline;
ods escapechar="^";
title;
title1 bold J=L 'Region Reconcilliation';
title2 J=L 'Year of Service 2014 thru May 2015,Paid Through 7-31-2015';
title3 J=L "Run Date:%sysfunc(today(),mmddyy10.)";
title4 ' ';

ODS TAGSETS.EXCELXP FILE="C:\Users\vsandu\Desktop\S\Tagsets\shoe.XLS" UNIFORM
style=minimal
OPTIONS(
ORIENTATION = 'LANDSCAPE'
EMBEDDED_TITLES='YES'
EMBEDDED_FOOTNOTES='YES'
CENTER_HORIZONTAL='YES'
PAGES_FITWIDTH = '1'
 PAGES_FITHEIGHT = '100'
 AUTOFIT_HEIGHT = 'YES'
 print_header_margin = '0.25'
 print_footer_margin = '0.25'
 /* print_header = '&amp;R&amp;8Page &P of &N'*/
 ROW_REPEAT = '1-3'
 SHEET_INTERVAL='bygroup'
 sheet_label=''
 FITTOPAGE='YES'
 SKIP_SPACE='0,0,0,0,0'
  GRIDLINES='NO'
 WRAPTEXT='NO'
  /*  doc='help' */
  );


proc report data=x1 nowd SPLIT='/' headline
style=[frame=void rules=none background=white CELLPADDING=0 font_face=ARIAL font_style=ROMAN];

 column region ('product level analysis'('Region level products' sales  Returns) stores);    

 compute after;
Region='Grand Total';
endcomp;

rbreak after/summarize STYLE=[FONT_WEIGHT=BOLD FONT_FACE=Arial FONT_SIZE=10PT];

 RUN;
ODS TAGSETS.EXCELXP CLOSE;

Regards,
Baba.
[prev in list] [next in list] [prev in thread] [next in thread]