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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.