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?
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.
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.
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?
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.