The SAS Output Delivery System and reporting techniques

Ods html body - redirecting to other directory

Reply
Occasional Contributor
Posts: 17

Ods html body - redirecting to other directory

Hi there,

I'm just running some simple ods html body= code but when I run it, I get this in the log:

ERROR: Physical file does not exist, H:\Documents\RB attrition Analysis\G:\Research and Analysis
Group Folder\35. Customer Analysis\Group Strategy\Output\Scorecard_JUN09.

What's really strange is that I'm not pointing to the h drive at all. My code is this:

ods html body="G:\Research and Analysis Group Folder\35. Customer Analysis\Group Strategy\Output\Scorecard_June.xls";

in the log before the error is this message:
NOTE: Writing HTML Body file: G:\Research and Analysis Group Folder\35. Customer Analysis\Group Strategy\Output\Scorecard_JUN09

so it looks like it's writing to the right file then in the error it looks like it's trying to write it to the H:\documents file.

Any suggestions?

Thanks,
Christy
Super Contributor
Super Contributor
Posts: 3,174

Re: Ods html body - redirecting to other directory

You need to share the SAS-generated log information with expanded SAS code which will likely reveal the problem cause. Reply again to your post and PASTE the log with related diagnostics messages as generated by SAS.

Scott Barry
SBBWorks, Inc.
Occasional Contributor
Posts: 17

Re: Ods html body - redirecting to other directory

Here's the entire log:

316 ods html body="G:\Research and Analysis Group Folder\35. Customer Analysis\Group
316 ! Strategy\Output\Scorecard_&grpdate";
NOTE: Writing HTML Body file: G:\Research and Analysis Group Folder\35. Customer Analysis\Group
Strategy\Output\Scorecard_JUN09
ERROR: Physical file does not exist, H:\Documents\RB attrition Analysis\G:\Research and Analysis
Group Folder\35. Customer Analysis\Group Strategy\Output\Scorecard_JUN09.
WARNING: No body file. HTML output will not be created.
Super Contributor
Super Contributor
Posts: 3,174

Re: Ods html body - redirecting to other directory

You haven't shared enough SAS code leading up to the error - that's the most important, as much for your diagnosis as well as those individuals who subscribe here. It's quite clear that the generate SAS code is not compatible with a file directory/name structure -- which realistically you will need to help debug. Forum subscribers have little, if any, knowledge about your SAS application.

Scott Barry
SBBWorks, Inc.
Occasional Contributor
Posts: 17

Re: Ods html body - redirecting to other directory

Thanks Scott,

We actually worked it out... in the Tools, preferences, I had the html box checked with a directory chosen so it was over righting my code and trying to put it in that directory.

Cheers,
Christy
Ask a Question
Discussion stats
  • 4 replies
  • 150 views
  • 0 likes
  • 2 in conversation