The SAS Output Delivery System and reporting techniques

Error: Physical file does not exist

Reply
Contributor
Posts: 73

Error: Physical file does not exist

Hello again

I can't explain why i get this error, why does it look for P:\DMC?

ERROR: Physical file does not exist,
P:\DMC\\\mtrlpqdc304\busint_SS$\msg\2010\Report_for_2010_july2010_20100810.xls.



%let report="\\mtrlpqdc304\busint_SS$\msg\2010\Report_for_2010_july2010_20100810.xls";
ods listing close;
ods html file=&report RS=none style=styles.noborder;

option nodate;
title1 'Outsourcer lateness - 2010';
title2 ' ';
SAS Super FREQ
Posts: 8,868

Re: Error: Physical file does not exist

Hi:
Are you by any chance using SAS Enterprise Guide to submit code to a server??? Or possibly running SAS under a Business Intelligence Platform configuration??? It looks like something in your configuration is putting that location "P:\DMC" in front of the path created by FILE=. These previous forum postings and Tech Support notes might be relevant:
http://support.sas.com/forums/thread.jspa?threadID=10994
http://support.sas.com/forums/thread.jspa?threadID=7840
http://support.sas.com/kb/37/593.html
http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#win-sysop-sasiniti...
http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#startsas.htm#workd...
http://support.sas.com/kb/23/457.html
http://support.sas.com/kb/17/709.html

You might want to work with your SAS Administrator to investigate settings in the configuration file used or investigate SAS Option settings for SASINITIALFOLDER by using this code:
[pre]
proc options group=envfiles;
run;
[/pre]

PROC OPTIONS output is written to the SAS log, so you should be able to see where/whether "P\DMC" appears in the list of option values.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 2806 views
  • 0 likes
  • 2 in conversation