topic Where can I find the data in SAS Visual Analytics in SAS Visual Analytics

Where can I find the data in SAS Visual Analytics

Kboukaabar — Tue, 30 Jun 2020 03:59:08 GMT

I need the rugby and insighttoy_sales data sets in SAS Visual Analytics, and can't find them, do I need to load these in the CAS? if so, how?

Re: Where can I find the data in SAS Visual Analytics

PetriRoine — Tue, 30 Jun 2020 06:51:18 GMT

Hello @Kboukaabar

Could you please provide a little bit more information so people get a clear picture of your need and are better able to help you?

Do you have the data sets rugby and insighttoy_sales or are you asking for the data set files to be placed somewhere so you can download them? Or you believe that these data sets are already somewhere in your SAS Viya environment and you want to know how to find these files?
If you have the files then in which format (csv, xlsx, sas data set,....)?
Are you also asking for instructions how to upload files to CAS?

Best regards,

Petri

Re: Where can I find the data in SAS Visual Analytics

Kboukaabar — Tue, 30 Jun 2020 10:58:39 GMT

These are supposed to be files that come with SAS Visual Analytics.

Re: Where can I find the data in SAS Visual Analytics

Madelyn_SAS — Tue, 30 Jun 2020 13:47:42 GMT

SAS Visual Analytics comes with some sample reports but the insight_toys and rugby takes are not used by those reports. Were you told by someone that these tables would be available? Are you using a trial version?

Re: Where can I find the data in SAS Visual Analytics

PetriRoine — Tue, 30 Jun 2020 13:54:00 GMT

I'm not sure if Insight_toys and Rugby are part of SAS standard set of data sets included, but it is true that SAS installations include some data sets out of the box. The files are spread into two libraries - SAS9 and CAS library:

SASHELP library
SAS data sets that you have to load to CAS f.ex. via SAS StudioV. I didn't see any data set called rugby there, but could be with different name.
Open SAS Studio V > Libraries > SASHELP
Samples library
Can be loaded to in-memory with right mouse button.
Open Manage Data > Data Sources > Samples
or
Open VA > Add/Change Data > Data Sources > Samples

Here's a little code snippet which you can utilize should you want to upload some data from SASHELP to CAS:

/* Start a session */
cas casauto;
caslib _all_ assign;

proc casutil;

	/* Reads data from SASHELP library and loads it into memory on SAS CAS */
	load data=sashelp.cars casout="my_cars" outcaslib="CASUSER" replace ; 

	/* Removes a table from memory on SAS CAS. A table might exist if you have submitted this code before. PROMOTE can't replace tables */
	droptable casdata="my_cars" incaslib="PUBLIC" quiet;
                             
	/* Copies a session-scope table to global scope so it's available outside this session */
	promote casdata="my_cars" incaslib="CASUSER" casout="my_cars" outcaslib="PUBLIC" keep; 
                             
run;

/* Terminate session Casauto */
/* cas casauto terminate; */

Brgds,

Petri

Re: Where can I find the data in SAS Visual Analytics

Kboukaabar — Tue, 30 Jun 2020 13:51:39 GMT

I am using the SAS Viya for Learners to teach the Data Visualization course which uses SAS Studio and SAS Visual Analytics. How and where then can I access them and how to upload them so the students have access to them? Thanks.

Re: Where can I find the data in SAS Visual Analytics

Kboukaabar — Tue, 30 Jun 2020 14:18:31 GMT

I followed your suggestion below

"Samples library
Can be loaded to in-memory with right mouse button.
Open Manage Data > Data Sources > Samples
or
Open VA > Add/Change Data > Data Sources > Samples, "

and it says "no Item available.

Re: Where can I find the data in SAS Visual Analytics

Sam_SAS — Tue, 30 Jun 2020 17:11:37 GMT

A version of the Insight Toy data set is available here:

http://support.sas.com/documentation/onlinedoc/va/8.1/insightToyDemo.zip

I am not familiar with the rugby data set.

Re: Where can I find the data in SAS Visual Analytics

Kboukaabar — Fri, 03 Jul 2020 13:39:40 GMT

It has been solved. Thanks.

Re: Where can I find the data in SAS Visual Analytics

Kboukaabar — Fri, 03 Jul 2020 13:40:45 GMT

It has been solved, thanks.