ERROR: physical file does not exist

[paulinap1]

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

[Tom]

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.

[paulinap1]

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

[Tom]

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.

[alexal]

@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.

[paulinap1]

How can I mount the folder?

[alexal]

@paulinap1 ,

How can I mount the folder?

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

[Reeza]

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.