ERROR: Physical file does not exist

[danbowers]

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?

[SASKiwi]

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

[danbowers · Accepted solution]

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

[femi28]

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

[sachinsunny]

try

infile '"path"' ; 

    single quote followed by double 

[pareshrodrigues]

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