How to use infile on an uploaded CSV file

[paulaxa1]

I am using a demo version of SAS Viya. I want to recreate the benchmark experiments for of the hyperparameter optimization tool "autotune". The version I use is online, I haven't downloaded anything, I just log in and I have access to SAS Studio. I have uploaded the CSV files I want to use, they are under the "Explorer", in the SAS Content/Users/(my username)/dataCSV folder (See Image). 

When I right click on the file and copy the file location, and use that file location for the infile statement, I get the "ERROR: Physical file does not exist" error. 

This is a sample of the code, same error same problem. What should I do? (again I am using online version I haven't downloaded anything). Thanks in advance.

data work.Banana;
   infile "/Users/paulxaxaxaxa@gmail.com/dataCSV/banana.csv" delimiter=',';  /* set path appropriately */
   input 
      Y
      X1
      X2 ;
run;

[Reeza]

Right click on the file, select properties and see if that doesn't have the path to the file there.

[paulaxa1]

I did that I also say it in my original post. I get the Physical file does not exist" error.

[Reeza]

You copied and pasted the exact path? It is case sensitive as well.

[Reeza]

Another option is to use the import task not code it. The GUI allows you to point it to the file and then check the log/code to see what path it used.

[Tom]

I thought you had to use the FILESRVC engine with VIYA/CAS.

https://documentation.sas.com/?docsetId=lestmtsglobal&docsetTarget=p0qapul7pyz9hmn0zfoefj0c278a.htm&...

[BrianGaines]

Hi @paulaxa1,

@Tom is right, you need to use the FILESRVC engine to interact with data located in SAS Content (SAS Drive).  So your code would look something like this:

filename in FILESRVC folderpath='/Users/paulxaxaxaxa@gmail.com/dataCSV/' filename='banana.csv';

data work.Banana;
   infile in delimiter=','; 
   input Y X1 X2;
run;

Does that work for you?

Best,

-Brian

[paulaxa1]

Thanks @Tom and @BrianGaines . It worked. I also managed to use %include to include another SAS code file by this:

filename myfldr filesrvc folderPath = '/Public/Projects/';
%include myfldr ('SAS2017-0514_benchmark_datasets.sas');