Cynthia: Thanks for your prompt reply and comments. SAS code (Version SAS 9.4) updated is attached below for your review and reference. Is it possible to design report with following changes ? (1) For the second line, it should be ' THIN ' line with white background. (2) Background of third line (which reads -: Type : Sedan) should be other than yellow. (3) Font Color for the third line should be black. %let ff = %str(HEIGHT=9PT Bold F=ARIAL bcolor="White" color='BLACK') ; %Let Title1 =%str(Line of Business : Electronics); %Let Title2 =%str(US Export); %Let Title3 =%str(Enterprise Unit); %Let Title4 =%str(Report ID: Ele_Export_US); %Let Title5 =%str(Department : HR01AL9012) ; %Let Title6 =%str(Paid Period); %Let Title7 =%str( December 2013); Title Font=Arial bold height=12pt J=c "&title1" J=c Font=Arial bold height=12pt "&title2" J=l Font=Arial bold height=10pt "&title3" J=l Font=Arial bold height=10pt "&title4" J=c Font=Arial bold height=9pt "^{newline 1}" "&title5" J=c Font=Arial bold height=9pt "^{newline 1}" "&title6" J=c Font=Arial bold height=9pt "^{newline 1}" "&title7"; FootNote ' '; ODS escapechar='^'; ODS _all_ close; options orientation=landscape leftmargin="0.2cm" rightmargin="0.2cm" Device=ACTXIMG topmargin="0.5cm" bottommargin="0.5cm" nodate nonumber center spool printerpath="Postscript"; ODS pdf file="d:\temp\Test.pdf" style=sasweb startpage=yes notoc; %Let starttime=%sysfunc(datetime()); Proc Report Data=sashelp.cars(obs=5 keep=Make Model Type Origin MSRP Invoice) nowd style(report)=[cellspacing=5 borderwidth=0 bordercolor=white] style(header)=[color=Black Fontstyle=italic Fontsize=4] style(column)=[color=moderate brown Fontfamily=helvetica Fontsize=4] style(lines)=[color=black backgroundcolor=black Fontstyle=italic Fontweight=bold Fontsize=5] style(summary)=[color=cx3e3d73 backgroundcolor=cxaeadd9 Fontfamily=helvetica Fontsize=3 textalign=r]; /* style(calldef)=[background=white]; /* Reference from SAS Guide to Report Writing By Michele M. Burlew : Page 191 */ Columns Make model Type Origin MSRP Invoice ; Define make / Order Noprint; Define model / 'Model' ; Define type / Order Noprint; Define origin / Order Noprint; Define MSRP / sum analysis ; Define invoice / sum analysis ; break after type / page skip; compute before _page_ / left style=[Font_weight=bold foreground=green background=yellow]; if _Break_ ne ' ' then CALL DEFINE(_COL_,'style', 'style=[ foreground=green background=yellow Fontstyle=italic Fontsize=2 ]'); line 'Make: ' Make $char. ; /* First Line */ line ' '; /* Blank Line */ if _Break_ ne ' ' then CALL DEFINE(_COL_,'style', 'style=[ foreground=red background=silver Fontstyle=italic Fontsize=2 ]'); line 'Type : ' Type $char.; /* Third Line */ endcomp; run; ODS PDF Close; ODS LISTING ;
... View more
