BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
eagles_dare13
Obsidian | Level 7

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?

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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

3 REPLIES 3
ballardw
Super User

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.

eagles_dare13
Obsidian | Level 7

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?

ballardw
Super User

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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