topic Re: How to export chart produced with ODS LAYOUT GRIDDED in Graphics Programming

How to export chart produced with ODS LAYOUT GRIDDED

svh — Thu, 22 Dec 2022 16:19:40 GMT

I am trying to put two histograms side by side, and the variables I'm using are different ones that do not lend themselves to using PROC SGPANEL. In the following code, I can produce the plot but not save an image file that has the two charts side by side. Instead, I get a separate image file for each histogram. I cannot find a solution in the documentation for ODS GRAPHICS...

ods listing gpath="C:\Figures\";
ods graphics / imagename="test" imagefmt=png;
ods layout gridded columns=2 advance=table;
ods noproctitle;                       
 proc sgplot data=sashelp.cars;
   histogram MPG_city;
   run;
   proc sgplot data=sashelp.cars;
   histogram MPG_highway;
   run;
 ods select all;                    
ods proctitle;                        

ods layout end;

Re: How to export chart produced with ODS LAYOUT GRIDDED

SASJedi — Thu, 22 Dec 2022 18:08:10 GMT

Each PROC SGPLOT step generates a graphic file containing the specified plot(s). ODS LAYOUT just specifies how they are laid out in the output destination. In a web page, the layout is accomplished in the HTML:

<table class="c layoutcontainer" cellspacing="30" cellpadding="0" border="0" summary="Layout table">
	<col>
	<col>
		<tr class="layoutregion">
		<td class="c layoutregion">
			<div class="branch"><a name="IDX"/>
				<div>
					<div class="c">
						<img alt="The SGPlot Procedure" src="test1.png" style=" height: 480px; width: 640px;" border="0" class="c">
					</div>
				</div><br>
			</div>
		</td>
		<td class="c layoutregion">
			<div class="branch"><a name="IDX1"/>
				<div>
					<div class="c">
						<img alt="The SGPlot Procedure" src="test2.png" style=" height: 480px; width: 640px;" border="0" class="c">
					</div>
				</div><br>
		</div>
	</table>

If you write the output to PDF instead, you can get a single file with the images side by side:

ods graphics / imagename="test" imagefmt=png;
ods noproctitle;                       
ods pdf file="C:temp\test.pdf";
ods layout gridded columns=2 advance=table;
ods region width=3in;
proc sgplot data=sashelp.cars;
   histogram MPG_city;
run;
ods region width=3in;
proc sgplot data=sashelp.cars;
   histogram MPG_highway;
run;
ods select all;                    
ods proctitle;                        
ods layout end;
ods pdf close;

Does that help?

Re: How to export chart produced with ODS LAYOUT GRIDDED

PaigeMiller — Thu, 22 Dec 2022 18:09:43 GMT

https://communities.sas.com/t5/Graphics-Programming/How-to-save-out-PLOT-Picture-explicitly/m-p/832204/highlight/false#M23144

Re: How to export chart produced with ODS LAYOUT GRIDDED

DanH_sas — Thu, 22 Dec 2022 18:11:15 GMT

I did a blog post on how to write ODS LAYOUT output into a single image. Check out this post and let me know if you have any questions.

Thanks!

Dan

Re: How to export chart produced with ODS LAYOUT GRIDDED

svh — Thu, 22 Dec 2022 19:12:46 GMT

That worked with some trial and error to get the settings right. The outputted plots have blue cell borders. Is there a way to control the cell borders for the layout? I could not see an option, but thought I would ask. These blue borders are not matching the style of other figures.

Re: How to export chart produced with ODS LAYOUT GRIDDED

SASJedi — Thu, 22 Dec 2022 20:22:11 GMT

That's an awesome blog!

Re: How to export chart produced with ODS LAYOUT GRIDDED

DanH_sas — Thu, 22 Dec 2022 20:36:59 GMT

By default, ODS PRINTER will have a different style than HTML. Did you use the STYLE= option on the ODS PRINTER statement to force the style to be the same?

Re: How to export chart produced with ODS LAYOUT GRIDDED

svh — Thu, 22 Dec 2022 21:19:28 GMT

This suggestion did the trick. .