topic Re: Importing Data in SAS Visual Analytics

Importing Data

nhi996 — Fri, 06 Oct 2017 11:20:09 GMT

Hey!

I started using visual analytics today and can't really get going. I imported a data set called "multiple_sclerosis_data.csv"
which is now in the subfolder LASR, which is in Shared Data. I called the table "multiple_sclerosis" and wanted to test if the import was successful. So I tried a proc means command and got the following error:

File WORK:MULTIPLE_SCLEROSIS.DATA does not exist.

Did I do anything wrong or did I forget anything?

Thanks for any help!

Re: Importing Data

RW9 — Fri, 06 Oct 2017 12:00:14 GMT

What does your libname point to where that dataset is located. You need to give the library and the dataset otherwise SAS will think to use WORK. E.g.:

libname myloc "...";

proc import... out=myloc.multiple_sclerosis...;

data want;
  set myloc.multiple_sclerosis;
run;

Re: Importing Data

nhi996 — Fri, 06 Oct 2017 12:45:48 GMT

Hey thanks for the reply.

I normally use SAS 9.3 and for whatever reason I don't even know how to assign a library in Visual Analytics.
This is where my dataset is located:

I don't really know which path I have to use, to set a library.

Re: Importing Data

Madelyn_SAS — Fri, 06 Oct 2017 13:10:40 GMT

If you have imported the table to the SAS LASR Analytic Server, why not use one of the Visual Analytics components to view the table? Visual Analytics Designer or Visual Analytics Explorer?

Re: Importing Data

nhi996 — Fri, 06 Oct 2017 13:13:12 GMT

Yeah that's possible. But I'm still getting the same error, when I want to analyse my data

Re: Importing Data

SASKiwi — Sat, 07 Oct 2017 21:36:39 GMT

The default LIBREF for the public LASR library is LASRLIB. If this hasn't been changed since VA was installed it may work for you. You do need to be using the VA Application Server, via SAS Studio or Enterprise Guide for it to work, and the LASR server needs to be running with your dataset loaded into memory.

data want;
  set lasrlib.multiple_sclerosis;
run;