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?
Please post the code you are using to create the excel-file.
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;
One option we are exploring is to install font package on Linux RedHat 6.1
@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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.