topic ERROR: physical file does not exist in SAS Studio

ERROR: physical file does not exist

paulinap1 — Wed, 03 Jul 2019 14:01:59 GMT

Hi,

I'm trying to read in an Excel file into SAS so I can later use it in SAS Visual Analytics. Here is my code:

libname prs '/SAS/SASDATA/SASUSER/paulina.portnoy';
PROC IMPORT DATAFILE= 'C:\Users\pportnoy\Documents\COUNT_DX\Count_DX_HCC_v12_2015.xlsx'
DBMS=XLSX
out=prs.COUNT_DX replace;
GETNAMES=YES;

RUN;

I keep getting the error that the physical file does not exist. The excel file sits on my laptop. Can someone please help?

I'm using SAS Studio V

Re: ERROR: physical file does not exist

Tom — Wed, 03 Jul 2019 14:06:42 GMT

Is SAS running on Windows? Or is it running on Unix (perhaps in a virtual machine)?

Either way you need to use paths for the library and the Excel file that SAS can see. So one of the two is in the wrong format.

Re: ERROR: physical file does not exist

alexal — Wed, 03 Jul 2019 14:08:31 GMT

@paulinap1 ,

I assume SAS Studio V is running on Linux server? If the answer is yes, you won't be able to access the data from your laptop unless you mount that folder on the server.

Re: ERROR: physical file does not exist

paulinap1 — Wed, 03 Jul 2019 14:10:11 GMT

Might be running on Linux. How do I change the format of my code so it works?

Re: ERROR: physical file does not exist

paulinap1 — Wed, 03 Jul 2019 14:11:01 GMT

How can I mount the folder?

Re: ERROR: physical file does not exist

alexal — Wed, 03 Jul 2019 14:14:14 GMT

@paulinap1 ,

How can I mount the folder?

https://access.redhat.com/solutions/448263

Re: ERROR: physical file does not exist

Tom — Wed, 03 Jul 2019 14:27:03 GMT

If you are using SAS/Studio then use that interface to upload the file to some place on the Unix server where SAS can see it and use the new name in the PROC.

Re: ERROR: physical file does not exist

Reeza — Wed, 03 Jul 2019 14:58:38 GMT

Go to SAS Studio, find the Server Files and Folders pane. At the top menu bar of that section is an icon with an up arrow, use that to upload your data and then you can import it.