11-23-2017 01:21 AM
Hi Community members,
Need assistance on one topic.
Product name : SAS Visual Analytics
Issue : Querying in memory LASR table in SAS.
SAS dataset is loaded into memory in Visual Analytics in SAS LASR server and it can be used successfully in SAS VA reports.
Question : Can we query SAS LASR table or in memory table using SAS EG or proc sql or any other way ?
Same question in another way : I am trying to understand whether we can query in memory SAS table any way ?
Thanks for your help in advance, as always.
11-23-2017 02:06 AM
Yes you can using SAS code, EG, SAS Studio and so on. You can connect to your SAS VA server the same way you connect to any other SAS Compute server. Then if you are using the public LASR server the default LIBNAME for that is LASRLIB. For example:
proc print data = LASRLIB.MyLASRTable (obs=10); run;
11-23-2017 02:12 AM
Thanks for answer.
Question is : Will execution happen in memory or at standard SASAppVA workspace server ?
I am looking for method to query in memory table and execution of query should be in memory.
11-23-2017 02:38 AM
Processing happens on the SASAppVA workspace server CPUs but IO is done from LASR memory so in my experience it is fast but not as fast as queries built in SAS VA.
11-23-2017 02:52 AM
Also have a look at Proc IMSTAT
Using this procedure, processing will be done in the LASR Server
11-23-2017 03:13 AM
I will look at IMSTAT procedure in more details. This answers are helpful.
What I am trying to do is to find out a familiar SQL way to query memory tables in VA either from SAS VA interface or EG and execution should happen in VA memory in place of it uses traditional IO.
Any insight on below questions will help.
Is there any interface within SAS VA where we can write down queries same as it is written in SAS EG ? or
some simple code within IMSTAT proc , which allows user to write proc sql ?
11-23-2017 04:05 AM
Hope the below weblink is helpful to you: