topic Re: SAS Cloud Analytic Services (CAS) (Problem importin in trial version) in Developers

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

Thierry95 — Wed, 17 Apr 2019 15:57:04 GMT

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.

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

joeFurbee — Thu, 18 Apr 2019 12:31:11 GMT

Hi @Thierry95,

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

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

Thierry95 — Thu, 18 Apr 2019 13:51:07 GMT

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.

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

joeFurbee — Thu, 18 Apr 2019 16:37:37 GMT

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!

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

Thierry95 — Fri, 19 Apr 2019 07:47:02 GMT

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,

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

Thierry95 — Fri, 19 Apr 2019 08:14:21 GMT

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

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

joeFurbee — Fri, 19 Apr 2019 11:55:23 GMT

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.

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

Thierry95 — Mon, 22 Apr 2019 07:31:50 GMT

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.

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

joeFurbee — Mon, 22 Apr 2019 20:08:11 GMT

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

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

joeFurbee — Tue, 23 Apr 2019 19:48:16 GMT

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.

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

Thierry95 — Wed, 24 Apr 2019 11:54:42 GMT

Hi @joeFurbee ,

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

I wish all the best for you.

Best Regards.