topic Re: ERROR: Physical file does not exist? in SAS Programming

ERROR: Physical file does not exist?

Saravanan — Thu, 19 Jul 2012 16:03:32 GMT

Hi,

I`m trying to read a large text file using infile statement.

When i ran the code, i encountered this error. "ERROR: Physical file does not exist".

I checked the location and see the file is there.

Your help is greatly appreciated.

Thanks,

Saravanan

Re: ERROR: Physical file does not exist?

ballardw — Thu, 19 Jul 2012 21:44:00 GMT

Please provide the FILENAME statement if used or the INFILE statement.

The most likely problem is a typo in the path or filename, or if using a macro the resolved macro filename or infile has a problem.

Re: ERROR: Physical file does not exist?

Saravanan — Fri, 20 Jul 2012 12:51:16 GMT

Hi, The FILENAME statement is used as given,

filename in "Q:\Data\Original\2010\Decrypted\MDS_Qtr\201204(Apr)\2011Q1\QWU_J67455_P1_Custom.txt" lrecl=1274;

infile in dsd truncover;

The Q: is on server and it is mapped to my computer. This is how it reads,

computer\tmstua(\\sas-2003)(Q:)\Data\Original\2010\Decrypted\MDS_Qtr\201204(Apr)\2011Q1

Thanks

Re: ERROR: Physical file does not exist?

bentleyj1 — Fri, 20 Jul 2012 15:00:00 GMT

In addition to verifying visually that the file exists in the directory you're referencing, can open and view the file in a text editor?

I'm wondering if the parenthesis in the filename are causing a problem. I've never seen those used before. The only special characters I can recall seeing in a path are the underscore and dash.

I'd say create the exact same directory structure on your C: drive or another mapped drive but without the ( ) characters and copy the file there. Then change the filename statement and see what happens.

Good luck. This is a curious one. Be sure to let us know what you figure out.

Re: ERROR: Physical file does not exist?

Saravanan — Fri, 20 Jul 2012 15:08:32 GMT

The data is too large to be opened in a text editor. I have tried creating the same directory structure in my C: drive and it works perfectly.

Q: drive is on the server and it is mapped to my computer. When i try to access Q:drive, it doesn`t work. I`m baffled.

Thanks.

Re: ERROR: Physical file does not exist?

bentleyj1 — Fri, 20 Jul 2012 15:47:48 GMT

Very curious. I created a directory on my LAN with (Apr) in the path, put a text file there, created a filename pointing to it, and it worked just fine.

Except that I mistyped the path the first run and it returned the file not exists error. To be sure, I went into Windows Explorer and copied and pasted the directory path and filename into the filename statement. It worked then. Have you done that or did you type it in.

You have a long path and filename, and I see the path has directories for years 2010, 2012, and 2011 in it. Looks confusing. Are those all correct?

Ballardw suggested earlier it's a typo.

Re: ERROR: Physical file does not exist?

Saravanan — Fri, 20 Jul 2012 15:58:23 GMT

To avoid typos i copy pasted the path and file name from windows explorer.

It works fine with same directory structure in other drives except for Q: drive.

I`m not sure why it is not working for Q: drive.

Thanks.

Re: ERROR: Physical file does not exist?

niam — Fri, 20 Jul 2012 15:58:42 GMT

make sure that the file is closed when you run the code, sometimes if the file is open by another program, this may happen

Re: ERROR: Physical file does not exist?

Saravanan — Fri, 20 Jul 2012 16:03:15 GMT

File is closed and it is not used by anyother program. Much appreciated.

Re: ERROR: Physical file does not exist?

bentleyj1 — Fri, 20 Jul 2012 16:24:58 GMT

I'm afraid I'm stumped on this one.

Re: ERROR: Physical file does not exist?

Linlin — Fri, 20 Jul 2012 16:53:35 GMT

maybe there are two many subdirectories?

I had problem to get files from the subdirectories of

"\\Fhs-srv-array1\Users\www\my documents\From my old computer"

after changing

"\\Fhs-srv-array1\Users\www\my documents\From my old computer"

to a letter drive (Y:) it worked fine.

Re: ERROR: Physical file does not exist?

Doc_Duke — Fri, 20 Jul 2012 17:33:16 GMT

Are you running SAS locally or on the server? If you are running on the server, it may require different drive mappings than you have on your local PC.

Re: ERROR: Physical file does not exist?

Saravanan — Fri, 20 Jul 2012 18:15:27 GMT

I should try that.Thanks.

Re: ERROR: Physical file does not exist?

Saravanan — Fri, 20 Jul 2012 18:17:15 GMT

I`m running SAS on server. I have other drives which is mapped the same way as Q: drive. There is no such problem when pulling data from other drives which is also mapped similar to Q: drive.

I don`t know why it is not working.

Re: ERROR: Physical file does not exist?

bentleyj1 — Fri, 20 Jul 2012 18:52:33 GMT

Is this a UNIX server that SAS is running on? If so, you've got a special setup that allows it to read from what I presume is a Windows-based LAN and your Q: drive isn't mapped to the server. Our Unix server can't access file on our LAN.

Re: ERROR: Physical file does not exist?

Saravanan — Fri, 20 Jul 2012 19:24:52 GMT

No we have windows server where SAS is running on.!

Re: ERROR: Physical file does not exist?

Linlin — Fri, 20 Jul 2012 19:27:05 GMT

Hi,

save a simple file to the same location to try to read it.

Re: ERROR: Physical file does not exist?

Doc_Duke — Fri, 20 Jul 2012 20:05:17 GMT

My guess is that the Q: drive on your server is not mapped the way it is on your workstation and you are going to have to work with your local network support to solve this.

Re: ERROR: Physical file does not exist?

robby_beum — Fri, 20 Jul 2012 20:26:30 GMT

You might need to give the actual drive designation instead of the drive letter...for example, something like:

\\sas-2003\computer\tmstua \Data\Original\2010\Decrypted\MDS_Qtr\201204(Apr)\2011Q1

Re: ERROR: Physical file does not exist?

Saravanan — Mon, 23 Jul 2012 12:36:55 GMT

I tried saving a simple file and it did not work either