topic PROC Report - Retain Formatting of Report when using ODS output excel and rsubmit (SAS/Connect) in ODS and Base Reporting

PROC Report - Retain Formatting of Report when using ODS output excel and rsubmit (SAS/Connect)

Amitkmr1979 — Fri, 13 Dec 2019 03:26:22 GMT

I am using Windows Client and submitting my code to UNIX for processing.

When I use windows client with my PROC report it retains all formats (font type/size/color etc) but when I create the excel output on UNIX the font type changes from Calibri to Courier. Also, what I had set as 0 on SAS for missing observations are replaced as 'period' on download.

Please can anyone suggest a way to retain the exact format as of windows when using UNIX?

Re: PROC Report - Retain Formatting of Report when using ODS output excel and rsubmit (SAS/Connect)

andreas_lds — Fri, 13 Dec 2019 07:38:31 GMT

Please post the code you are using to create the excel-file.

Re: PROC Report - Retain Formatting of Report when using ODS output excel and rsubmit (SAS/Connect)

Amitkmr1979 — Mon, 16 Dec 2019 06:33:50 GMT

rsubmit;
filename xlf "/appl/xxxxxxxxxxxxxxxxxxxxx/IB_Reporting.xls";

ods excel file=xlf options(embedded_titles='yes' frozen_headers='yes' start_at="6,2" frozen_rowheaders='7' tab_color='red' autofilter='1-2');
proc report data=work.test_report 
/*     nofs headline headskip style(summary)=[font_weight=bold]*/
     style(report)=[cellspacing=5 borderwidth=10 fontfamily=times bordercolor=blue]
	 style(header)=[color=Dark Blue fontstyle=italic fontsize=3 fontfamily=calibri just=center]
	 style(column)=[color=moderate blue fontfamily=calibri fontsize=2]
     style(lines)=[color=white backgroundcolor=black fontstyle=italic fontweight=bold fontsize=2 fontfamily=calibri]
     style(summary)=[color=cx3e3d73 backgroundcolor=cxaeadd9 fontsize=2 textalign=r fontfamily=calibri]
     ;

     title1 "Title for report";
	 title2 " For the process &month";
     column   Agent_state Typ Renewal_type Transaction_Type Y_: RollingTotal ytd_total ;
	 define   Renewal_type       / group noprint 'AUTO | MANUAL'; 
     define   Transaction_Type   / group noprint 'N.B. | RNWL'  ; 

     define   Agent_State        / order=internal 'STATE' style(column)=[just=center font_size=2 fontfamily=calibri];
	 define   Typ                / order=internal 'PRODUCT'; 

     define   Y_:                / style(column)=[tagattr="format:#,###.00;-#,###.00"]; 
     define   RollingTotal       / 'ROLLING TOTAL' style(column)=[tagattr="format:#,###.00;-#,###.00" color=DarkBlue backgroundcolor=aqua fontfamily=calibri fontsize=2 fontweight=bold]  ;
     define   ytd_total          / 'YTD TOTAL'  style(column)=[tagattr="format:#,###.00;-#,###.00" color=DarkBlue backgroundcolor=tan  fontfamily=calibri fontsize=2 fontweight=bold] ;

     break    after transaction_type /  skip summarize;
	 rbreak   after                  /  skip summarize;

     compute  before transaction_type / style=[background=lightblue just=c font_weight=bold fontfamily=calibri color=dark blue];
	                                           line Renewal_type $32. transaction_type $32. ;
	 endcomp;

	
run; 
ods excel close ;
endrsubmit;

Re: PROC Report - Retain Formatting of Report when using ODS output excel and rsubmit (SAS/Connect)

Amitkmr1979 — Mon, 16 Dec 2019 06:36:20 GMT

One option we are exploring is to install font package on Linux RedHat 6.1

Re: PROC Report - Retain Formatting of Report when using ODS output excel and rsubmit (SAS/Connect)

andreas_lds — Mon, 16 Dec 2019 07:44:18 GMT

@Amitkmr1979 wrote:

One option we are exploring is to install font package on Linux RedHat 6.1

Sound like something to try. If this doesn't help contacting sas tech support is recommended.