Thank you all for the replies. Ods rtf exclude all; has done the trick for me ... View more

Ods exclude all; stops the image from saving ... View more

I have a massive lot of code within ods rtf. This is just a section. I don't want image to print when running proc sqplot step. Ods exclude doesn't work. Multiple ods close didn't work as not all the data went to the rtf file. Ods rtf file=... ; /*loads of code*/ /*Creating an chart and saving it*/ /*issue: I don't want it to print image to ods rtf. ods exclude all; stops it printing to ods but stops image saving*/ ods listing gpath="&loc." style=htmlblue image_dpi=300; ods graphics / width=3in height=3in reset=index noborder imagename='data' outputfmt=png; proc sgplot data = x; /*more code*/ run; /*image is then used in proc report. This is why I don't want it to print above*/ proc report data=x ; column x column; define x/display '' style(column)={ preimage="&path\chart.png" bordertopcolor=white borderbottomcolor=white borderrightcolor=white borderleftcolor=white} style(header)={ cellwidth=20% bordertopcolor=white borderbottomcolor=white borderrightcolor=white borderleftcolor=white}; /*more code*/ endcomp; run; ... View more

Perfect! Thank you. You have been very helpful! ... View more

I realise the what the issue is but haven't found solution. If you do noheader, it puts image above table. I need to color in the header just for the table columns. Also, if I didn't use "noheader" the table is too big, the last row fills down to the height of the image. I might have to do image by image but some reason I couldn't save table as png. Kept receiving error that the image didn't exist in my proc report because it wasn't saving. ... View more

That's great but I still having problems.   I have been fiddling with it for awhile. If I use group or noprint on the x column, the image goes above the table. If I don't, I get the image repeating.   ods listing gpath="&report_loc." style=htmlblue image_dpi=300; ods graphics / width=3in height=3in reset=index noborder imagename='max_chart' outputfmt=png;       %* Create a plot of all concurrent sessions on the platform by day.;       title color=CX002B49 "Title" ;       proc sgplot data = marts.chart ;         yaxis min = 0 max = &max_concurrent_to_display. label = "Daily" grid gridattrs=(color=black pattern=35);         xaxis interval = month minorinterval= month type = time display = (nolabel);            series x = connection_date y = concurrent_connections / lineattrs = (color = CX002B49 thickness = 1px /*pattern=4*/);       run;             title;    data c_table;     length Average_Daily $25 Maximum_Daily $25;          /* First row with header-like values */     Average_Daily = "Average Daily";     Maximum_Daily = "Maximum Daily";     output;          /* Second row with macro values */     Average_Daily = "&&avg_c.";     Maximum_Daily = "&max_c.";     output; run;            data x; set c_table;        x='09'x;      run;      title;   proc report data=x nowd  noheader spanrows ;   column x Average_Daily Maximum_Daily;   define x /group '' style(column)={ preimage="&report_loc.\max_concurrent.png" bordertopcolor=white borderbottomcolor=white borderrightcolor=white borderleftcolor=white} style(header)={ cellwidth=50% bordertopcolor=white borderbottomcolor=white borderrightcolor=white borderleftcolor=white};   define Average_Daily/display "Average Daily" style={cellwidth=1in cellheight=0.5in};   define Maximum_Daily/display "Maximum Daily" style={cellwidth=1in cellheight=0.5in};    compute Average_Daily;     if Average_Daily="Average Daily"  then do;       call define(_col_, "style", "style={background=blue foreground=white cellwidth=1in cellheight=0.5in}");     end;   endcomp;   compute Maximum_Daily;     if Maximum_Daily="Maximum Daily"  then do;       call define(_col_, "style", "style={background=blue foreground=white cellwidth=1in cellheight=0.5in}");     end;   endcomp;     run; Need this table on the right of chart   ... View more

Ideally I wanted the table as a table to copy data over from the rtf file easier. If not possible, I will settle for image. This is a great example however my ods printer isn't saving the image ... View more

Perfect! Thank you! ... View more