The SAS Output Delivery System and reporting techniques

ODS not creating output file

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 82
Accepted Solution

ODS not creating output file

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?


Accepted Solutions
Solution
‎05-02-2014 04:08 PM
Super User
Posts: 10,516

Re: ODS not creating output file

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.

View solution in original post


All Replies
Super User
Posts: 10,516

Re: ODS not creating output file

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.

Frequent Contributor
Posts: 82

Re: ODS not creating output file

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?

Solution
‎05-02-2014 04:08 PM
Super User
Posts: 10,516

Re: ODS not creating output file

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 2354 views
  • 3 likes
  • 2 in conversation