topic Re: Programatically control EG ODS Options in SAS Enterprise Guide

Programatically control EG ODS Options

DanielLangley — Wed, 09 Oct 2019 16:09:47 GMT

Hello All,

We have recently switched to Enterprise Guide 8.1. Along with that switch one of our pdf reports broke.

We found that we could fix the report by going Tools --> Options --> Results --> General and unticking the Result Format of HTML.

Is there a way to achieve the same effect by setting some options?

Thanks

Daniel

Re: Programatically control EG ODS Options

ChrisHemedinger — Wed, 09 Oct 2019 16:24:21 GMT

EG 8.1 uses HTML5 by default, so you might start by unchecking the "flavor" of HTML to use and set back to plain HTML.

Also, if what "broke" is a setting related to graphics style/type, you could add explicit ODS statements for PDF that set it to what you want. If using EG to generate the PDF output for you, try statements like:

 ods pdf(id=egpdf) gtitle gfootnote...;

Learn more in this blog post about ODS control in EG.

Re: Programatically control EG ODS Options

DanielLangley — Thu, 10 Oct 2019 16:23:44 GMT

Hi Chris.

Thank you for your response.

I am trying to write code that can run in multiple instances of EG or be sent to someone else and it will "just work".

I was hoping that there was a way of writing code that could set the options that I want. I have tried using ods _all_ close and it is not stopping the html EG option from affecting my pdf.

Any thoughts?

Thanks

Daniel

Re: Programatically control EG ODS Options

ChrisHemedinger — Thu, 10 Oct 2019 16:34:10 GMT

Can you share specifics about what's "broken" in your PDF report? Paging, style, graphics, layout?

Re: Programatically control EG ODS Options

DanielLangley — Thu, 10 Oct 2019 17:02:19 GMT

Sure. There is a proc sgplot used to build some custom graphs. It is using text as one of the attributes and if EG html is check the text becomes really squished up and disassociated from the text backlighting which remains where it is supposed to bed and is not squished up. If I uncheck the html box and rerun the pdf this doesn't happen. I am not sure how or why html is affecting the pdf.

Re: Programatically control EG ODS Options

ChrisHemedinger — Thu, 10 Oct 2019 18:05:51 GMT

Any custom style or special settings?

if you add this to the top of your program:

ods pdf(egpdf) style=(your desired style) gtitle;

Does that help?

Re: Programatically control EG ODS Options

DanielLangley — Fri, 11 Oct 2019 10:05:49 GMT

Hi Chris,

I'm afraid that didn't work.

I have stripped my code back to create the worlds ugliest pdf.

Try running it with the Tools-->Options-->Results-->General-->Html checked and again with it unchecked.

data work.class;
set sashelp.class(obs = 5);
N = _n_;
low = 0;
mid = 1;
high = 2;
run;

ods _all_ close;
ods pdf(mypdf) file=&fileLoc. style=PEARL gtitle;

proc sgplot data = work.class;
	text	y = n
		x = mid
		text = name
		/
		textattrs = (size = 18pt color=red)
		backlight = 1
	;
run;
quit;

ods pdf(mypdf) close;

Re: Programatically control EG ODS Options

ChrisHemedinger — Fri, 11 Oct 2019 13:48:44 GMT

Try adding this to your code. Default with HTML is SVG, and I think that's affecting the way SGPLOT builds the graph.

 options dev=png;

Re: Programatically control EG ODS Options

DanielLangley — Fri, 11 Oct 2019 16:41:55 GMT

Thankyou