topic Re: ERROR: Physical file does not exist in SAS Studio

ERROR: Physical file does not exist

danbowers — Tue, 05 Jun 2018 02:27:12 GMT

Please see the code snippet below:

%let path=/folders/myfolders/ecprg293;

Data saleQ1;
infile '&path/sales.dat';
*infile '/folders/myfolders/ecprg293/sales.dat';
input @1 SalesID $4.;
run;

I get the error: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/&path/sales.dat. when using the infile statement that includes the &path macro reference.

if I comment out that line, and use: infile '/folders/myfolders/ecprg293/sales.dat'; Line, it works fine.

using VirtualBox 5.2.8

What am I doing wrong?

Re: ERROR: Physical file does not exist

SASKiwi — Tue, 05 Jun 2018 02:52:25 GMT

Use double quotes to resolve the macro variable, single quotes stop the resolution: infile "&path/sales.dat";

Re: ERROR: Physical file does not exist

danbowers — Tue, 05 Jun 2018 17:58:43 GMT

Wow, I was pulling my hair out, didn't even realize I was using single quotes, Thank you!!!

Re: ERROR: Physical file does not exist

femi28 — Wed, 22 Aug 2018 06:10:09 GMT

I am getting the same message for this short script;

Data Convert;
	infile "/Users/femioluwa@gmail.com/My Folder/My Snippets/femi/celsius.txt";
	input Temp_C;
	Temp_F = 1.8*Temp_C + 32;
run;

I am working on a SAS® Viya® SAS Visual Analytics environment application

Re: ERROR: Physical file does not exist

sachinsunny — Thu, 11 Jul 2019 10:31:09 GMT

try

infile '"path"' ;

single quote followed by double

Re: ERROR: Physical file does not exist

pareshrodrigues — Mon, 25 Nov 2019 05:14:32 GMT

"Hello Everyone,

I am working on two Ports. Lev1 on Port:8561 with SAS Visual Analytics 7.1 and Lev2 on Port:8562 with SAS Visual Analytics 7.4
The entire process/project is working fine (importing raw files, data modelling and uploading data to LASR server). And now we want to migrate from SAS VA 7.1 to SAS VA 7.4 and hence we are now running the code on Lev2 Port:8562. But the problem is the import/export code isn't working on Lev2.

25 GOPTIONS ACCESSIBLE;
26 PROC IMPORT DATAFILE= "D:\VA_Data\RF productivity data\RF_SUBCATEGORY_TAT_DETAILS.xlsx"
27 OUT= expo_ccd.RF_SUBCATEGORY_TAT
28 DBMS=xlsx
29 REPLACE;
30 SHEET="Sheet1";
31 GETNAMES=YES;
32 RUN;

ERROR: Physical file does not exist, D:\VA_Data\RF productivity data\RF_SUBCATEGORY_TAT_DETAILS.
NOTE: The SAS System stopped processing this step because of errors.

I tried switching ports and running same piece of code so its running properly on Lev1 and not working on Lev2.
Where Lev1 & Lev2 are similar only difference is pointing to different versions of SAS VA.

Please help how do I resolve this."