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.
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;
Also have a look at Proc IMSTAT
Using this procedure, processing will be done in the LASR Server
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 ?
Hope the below weblink is helpful to you:
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.