topic Re: Getting an ERROR: Physical file does not exist in New SAS User

Getting an ERROR: Physical file does not exist

BoboTheFool — Fri, 01 Feb 2019 04:15:05 GMT

Hello all. I am trying to do a simple ods from SAS Studio to my computer and keep getting the error that the Physical file does not exist.

My code:

data soccer;
input Team : $20. Wins Losses;
datalines;
Readington 20 3
Raritan 10 10
Branchburg 3 18
Somerville 5 18
;

options nodate nonumber;
title;
ods listing close;
ods csv file ='C:/Users/admin/Documents/soccer.csv';
proc print data=soccer noobs;
run;
ods csv close;
ods listing;

The file extension is what other CSV files that I already have on my computer have as their file extensions, except for the soccer.csv portion.

Is there something I am doing wrong?

Thanks for any help you can provide.

Adam

Re: Getting an ERROR: Physical file does not exist

Tom — Fri, 01 Feb 2019 04:34:17 GMT

Do you have a full version of SAS installed on your PC? Or are you working with the free SAS University Edition?

The path you have in your code 'C:/Users/admin/Documents/soccer.csv' looks somewhat like a Windows PC file location because it starts with C:. But it is using slashes that go in the wrong direction. Normally SAS will fix the slashes for you. But for that to work SAS itself must be running on the Windows machine where that C:\Users\admin\Documents\ directory exists. If you are using the SAS UE edition then SAS is running in a virtual machine so it cannot see you C: drive. It can only see the folder that you mapped to the /folders/myfolders path in the virtual machine. Or if SAS is running on some other server in your environment then that path might not exist.

Even if you are running SAS on your machine and that path exists you might not have permission to make a new file there. Especially since the path seems to be for a user name ADMIN.

Re: Getting an ERROR: Physical file does not exist

BoboTheFool — Fri, 01 Feb 2019 04:55:18 GMT

I am running SAS Studio on my PC. The admin is me, I just never changed the admin name, and left it as is. I have changed the direction of the slashes as well, and then it gives me a permission error as well. I don't have SAS actually downloaded on my computer, and am using SAS Studio through my university. I am pretty certain it may be the university edition as I connect to it through the SAS website. If SAS UE cannot see my C drive, how do I use ods to send a file to my computer? All of the code is for a problem in my textbook, and the only thing we had to change was the file nomenclature, but my understanding is that it has to go to our computer so we can then open it as a CSV file in Excel.

Re: Getting an ERROR: Physical file does not exist

BoboTheFool — Fri, 01 Feb 2019 05:05:07 GMT

When I change the direction of the slashes in the filepath name, this is what I get:

81 options nodate nonumber;

82 title;

83 ods listing close;

84 ods csv file ='C:\Users\admin\Documents\soccer.csv';

NOTE: Writing CSV Body file: C:\Users\admin\Documents\soccer.csv

ERROR: Insufficient authorization to access /pbr/biconfig/940/Lev1/SASApp/C:\Users\admin\Documents\soccer.csv.

ERROR: No body file. CSV output will not be created.

85 proc print data=soccer noobs;

86 run;

Re: Getting an ERROR: Physical file does not exist

Kurt_Bremser — Fri, 01 Feb 2019 05:19:05 GMT

You are supplying a Windows path to a UNIX machine.

You need to use a path that exists on the server, and where you have the necessary permissions.

Re: Getting an ERROR: Physical file does not exist

BoboTheFool — Fri, 01 Feb 2019 05:59:01 GMT

Thanks Kurt - that's what I am finding out. I'm not sure I see the purpose of exporting it the VM and then importing it back again, but that looks like the workaround for it. I appreciate everyone's help on this.

Re: Getting an ERROR: Physical file does not exist

BoboTheFool — Fri, 01 Feb 2019 06:00:16 GMT

Thanks Tom - my professor gave us a workaround for the issue.

Re: Getting an ERROR: Physical file does not exist

Kurt_Bremser — Fri, 01 Feb 2019 07:40:29 GMT

With a VM (University Edition), you have a shared folder to communicate, where you use a Windows path name when putting files there or retrieving them, and use the UNIX path name from SAS.

In a client/server environment, you need to use another means to put your data in reach of SAS. Either by using a file transfer utility like WinSCP or sftp, or by using a shared network resource that is available both on the client and the server.

In both cases, it is necessary to use UNIX-style path syntax from within SAS.

Re: Getting an ERROR: Physical file does not exist

pb82477 — Fri, 15 Feb 2019 17:45:46 GMT

You mentioned that your professor provided a work-around. Would you mind posting it for the rest of the community? Thanks.

Re: Getting an ERROR: Physical file does not exist

BoboTheFool — Fri, 26 Apr 2019 02:55:55 GMT

Sorry it took so long to return with the workaround, but here it is:

Right click your own file folder in SAS (mine is sasuser.v94) and you can "upload files" from your PC.

Re: Getting an ERROR: Physical file does not exist

Bhavya3 — Fri, 01 Oct 2021 15:42:41 GMT

Hey, the upload file option is not working for an excel file on my computer. I'm using a mac

Re: Getting an ERROR: Physical file does not exist

Kurt_Bremser — Fri, 01 Oct 2021 18:12:03 GMT

The upload feature does not work in Safari, use Chrome instead.