topic Re: ODS not creating output file in ODS and Base Reporting

ODS not creating output file

eagles_dare13 — Fri, 02 May 2014 19:19:55 GMT

l tried to run this simple code in my EG:

ods html file = "C:\temp.xls";

proc print data = sashelp.class;

run;

ods html close;

But the output file is not created in my C directory. I am on windows XP.

How to debug this problem?

Re: ODS not creating output file

ballardw — Fri, 02 May 2014 19:55:36 GMT

The Log usually includes a note about the destination.

ODS HTML though usually wants a Path and Body instead of file:

ODS HTML path="C:\" body="temp.xls";

I would say that naming html xls is moderately poor practice as the behavior of Excel changes with each release.

Re: ODS not creating output file

eagles_dare13 — Fri, 02 May 2014 20:02:29 GMT

Thank you. It now says:

NOTE: Writing HTML Body file: temp.xls

ERROR: Physical file does not exist, /opt/sas/ServerConfig/xxx/C:\/temp.xls.

ERROR: No body file. HTML output will not be created.

The directory "/opt/sas/ServerConfig/xxx" does not even exist on my machine, where does it pick it up from?

Re: ODS not creating output file

ballardw — Fri, 02 May 2014 20:08:54 GMT

Looks like you are running SAS through a server on a Unix box which I have no experience with. There have been a number of posts on the forum about redirecting output in the server setups.