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.
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.
Join us for SAS Community Trivia
SAS Bowl XLIII, The New SAS Developer Portal
Wednesday, August 14, 2024, at 10 a.m. ET | #SASBowl
Hi @Thierry95,
All SAS Viya Trials are on version 3.4, so you should be good on trying the Recommender System.
Join us for SAS Community Trivia
SAS Bowl XLIII, The New SAS Developer Portal
Wednesday, August 14, 2024, at 10 a.m. ET | #SASBowl
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.
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!
Join us for SAS Community Trivia
SAS Bowl XLIII, The New SAS Developer Portal
Wednesday, August 14, 2024, at 10 a.m. ET | #SASBowl
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,
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
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.
Join us for SAS Community Trivia
SAS Bowl XLIII, The New SAS Developer Portal
Wednesday, August 14, 2024, at 10 a.m. ET | #SASBowl
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.
@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.
Join us for SAS Community Trivia
SAS Bowl XLIII, The New SAS Developer Portal
Wednesday, August 14, 2024, at 10 a.m. ET | #SASBowl
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.
Join us for SAS Community Trivia
SAS Bowl XLIII, The New SAS Developer Portal
Wednesday, August 14, 2024, at 10 a.m. ET | #SASBowl
Hi @joeFurbee ,
Thank you very much for your support. I'm loading the data successfully !
I wish all the best for you.
Best Regards.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.