Importing Data

[nhi996]

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!

[RW9]

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;

[nhi996]

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.

[Madelyn_SAS]

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?

[nhi996]

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

[SASKiwi · Accepted solution]

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;