Hi all, Someone knows if is possible to preserve transparency of a gif image when used in a proc report with ods pdf? I want to avoid that annoying white square on the images without create an icon for each combination of colour. Thanks in advance 🙂 Sample code for test only: filename rpt "d:\temp\test.pdf"; options nodate nonumber center ; ods escapechar='^'; ods pdf file=rpt notoc uniform; title; footnote; proc report data=sashelp.class nowd split="~" style(report)={cellspacing=0 cellpadding=5 frame=box rules=group} style(header)={background=cx009d57 foreground=cxffffff cellheight=0.25in vjust=middle just=center} style(column)={cellheight=0.18in}; columns name age height weight; define name / display style(header)={pretext=" " preimage="D:\temp\16GreenCheck.gif" cellwidth=2in}; run; ods pdf close; ... View more

Hello all, I'm building some reports for excel and now i have a couple of questions. 1 - My report will need one image at the top for now i'm using preimage on the title. this image must be always in the same relative or absolute place, is possible to embed the image on the file? 2 - this reports always have charts, i try some devices but activex looks the one to chose. some advice about this point? 3 - how can i control my column size 😞 i tried so many things that i found on the web and nothing. can someone help on this? 4 - how can i suppress the proc separator? (is putting a line between the procs) bad line 😞 to help i send a sample with the last 2 problems. thanks in advance 🙂 /* =========================== SAMPLE =================*/ %let path=d:\temp; data a; length col1-col3 $ 100; label col1="Jan-09" col2="Feb-09" col3="Mar-09"; do i=1 to 10; col1=ranuni(100); col2=ranuni(100); col3=ranuni(100); output; end; run; ods tagsets.MSOffice2K file="test.xls" path="&path." (url=none) gpath="&path." (url=none) style=styles.minimal; proc report data=a nowd style(report)={cellspacing=0 cellpadding=0 rules = all frame = void} style(header)={foreground=#ffffff background=#808080 htmlstyle="mso-number-format:\@"} style(column)={bordercolor=#000000 borderwidth=1px} ; column col1-col3; run; proc report data=a nowd style(report)={cellspacing=0 cellpadding=0 rules = all frame = void} style(header)={foreground=#ffffff background=#808080 htmlstyle="mso-number-format:\@"} style(column)={bordercolor=#000000 borderwidth=1px} ; column col1-col3; define col1-col3 / display style(header)={htmlstyle="width:162pt"} style(column)={htmlstyle="width:162pt"}; run; ods tagsets.MSOffice2K close; ... View more

Hi there, I would like to know if is possible to add the attribute ID for each TR tag on a HTML table produced by the proc report. I would like to get something like this with proc report or proc print .... .... I already have a table with ID for each column. ods listing close; ods html file='teste.html' style=fancyPrinter; proc report data=sashelp.class nowd; column name sex age height; define name / display style(COLUMN) = {tagattr='id="1"'}; define sex / display style(COLUMN) = {tagattr='id="2"'}; define age / display style(COLUMN) = {tagattr='id="3"'}; define height / display style(COLUMN) = {tagattr='id="4"'}; run; ods html close; Thanks ... View more