topic Re: How to use infile on an uploaded CSV file in SAS Data Science

How to use infile on an uploaded CSV file

paulaxa1 — Fri, 10 Jan 2020 18:49:51 GMT

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;

Re: How to use infile on an uploaded CSV file

Reeza — Fri, 10 Jan 2020 20:32:43 GMT

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

Re: How to use infile on an uploaded CSV file

paulaxa1 — Fri, 10 Jan 2020 20:34:54 GMT

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

Re: How to use infile on an uploaded CSV file

Reeza — Fri, 10 Jan 2020 20:38:56 GMT

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

Re: How to use infile on an uploaded CSV file

Reeza — Fri, 10 Jan 2020 20:41:27 GMT

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.

Re: How to use infile on an uploaded CSV file

Tom — Fri, 10 Jan 2020 20:46:23 GMT

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

https://documentation.sas.com/?docsetId=lestmtsglobal&docsetTarget=p0qapul7pyz9hmn0zfoefj0c278a.htm&docsetVersion=9.4&locale=en

Re: How to use infile on an uploaded CSV file

BrianGaines — Fri, 10 Jan 2020 20:59:03 GMT

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

Re: How to use infile on an uploaded CSV file

paulaxa1 — Sat, 11 Jan 2020 10:18:42 GMT

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');