SAS Cloud Analytic Services (CAS) (Problem importin in trial version)

[Thierry95]

Is version 3.3 instance of SAS Cloud Analytic Services (CAS) included in the trial version of SAS Visual Analytics ???

I want to test the Recommender System described Here.

[joeFurbee]

Hi @Thierry95,

All SAS Viya Trials are on version 3.4, so you should be good on trying the  Recommender System.

[Thierry95]

Hi @joeFurbee ,

I'm just beginning SAS, I just tried to test the Recommender system and it failed on reading data (Physical file does not exist). Can you tell me if the problem related to the trial version.

And thank you very much.

[joeFurbee]

Hi @Thierry95, 

I took a look at the repo on GitHub and the code is expecting the file to be there already; however, there are no instructions in the README on where to get the files. On this SAS documentation page (which may be helpful to you in your Trial) you will find a link to the csv's used in the example.

I am creating a pull request on the GitHub repo to include the file locations. Good Luck!

[Thierry95]

Hi @joeFurbee ;

Thank you very much for your support, I'm using the same files you mentionned and I'm working now to secceed the import.

Best Regards,

[Thierry95]

As I said, I'm using the same files used in the Recommender System, and I described absolutely my problem in this post, if you have an advise for me I will be very grateful Mr. @joeFurbee .

Thank you

[joeFurbee]

Hi @Thierry95,

The documentation link that I sent in the last response will walk you through the entire Recommender System exercise. From setup to running various recommendation examples.

If you are continuing to have the upload issue, have you updated this SAS code?

filename books '/path/to/BX-Books.csv' encoding="wlatin1" lrecl=32767;

You will need to replace the /path/to/ part with the actual path to where you uploaded the csv files.

[Thierry95]

Hi @joeFurbee ,

This is exactly what I did, It is shown below (on trial version I uploaded the CSV but it is not recognized physically) :

filename books '/Users/chaabolla30@gmail.com/My Folder/Data/BX-books.csv' encoding="wlatin1" lrecl=32767;

Is the method used good to have access to the file path or not ?

Thank you very much.

[joeFurbee]

@Thierry95, I was able to replicate your issue using the same csv files in my own env. I'm working with a couple of people on uncovering the root of the problem. I'll let you know what I find out.

[joeFurbee · Accepted solution]

Hi @Thierry95,

I think I've finally gotten to the bottom of this. Based on how the filesystem of the trial is set up, you need to use the FILESRVC Access method in the filename statement. 

Here is sample code you should be able to use to resolve the file not found issue you encountered:

cas casauto;

libname mycas cas sessref=casauto;

filename books filesrvc folderpath="/Users/jofurb@sas.com/My Folder/" 
  filename="bxbooks.csv" contenttype='text/csv' lrecl=32767;

Make sure to replace the file path as needed. After successfully running these statements, I was able to proceed with the data steps to prepare and load data. After running the first data step you can verify the success by running the following code:

proc cas;
  table.fetch table="books";
run;

Hope this helps you move forward with the recommender sample.

[Thierry95]

Hi @joeFurbee ,

Thank you very much for your support. I'm loading the data successfully ! 

I wish all the best for you.

Best Regards.