Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS Visual Anlytics - Querying in memory table from EG

Reply
Occasional Contributor
Posts: 10

SAS Visual Anlytics - Querying in memory table from EG

Hi Community members, 

 

Need assistance on one topic. 

 

Product name : SAS Visual Analytics 

Issue : Querying in memory LASR table in SAS. 

Description :

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.

 

Regards, 

Fahim

 

Super User
Posts: 3,305

Re: SAS Visual Anlytics - Querying in memory table from EG

Posted in reply to pathanfahim1986

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;
Occasional Contributor
Posts: 10

Re: SAS Visual Anlytics - Querying in memory table from EG

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.

 

Regards, 

Fahim

Super User
Posts: 3,305

Re: SAS Visual Anlytics - Querying in memory table from EG

Posted in reply to pathanfahim1986

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.

SAS Super FREQ
Posts: 724

Re: SAS Visual Anlytics - Querying in memory table from EG

Posted in reply to pathanfahim1986
Occasional Contributor
Posts: 10

Re: SAS Visual Anlytics - Querying in memory table from EG

Posted in reply to Bruno_SAS

Thank you @Bruno_SAS and @SASKiwi.

 

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 ?

 

Regards, 

Fahim

 

Occasional Contributor
Posts: 15

Re: SAS Visual Anlytics - Querying in memory table from EG

Posted in reply to pathanfahim1986
Occasional Contributor
Posts: 10

Re: SAS Visual Anlytics - Querying in memory table from EG

Posted in reply to sandykota

@sandykota thanks. 

 

Will try all options and let you guys know how it goes. 

 

Thanks & Regards, 

Fahim

Occasional Contributor
Posts: 10

Re: SAS Visual Anlytics - Querying in memory table from EG

Posted in reply to pathanfahim1986

@sandykota@Bruno_SAS@SASKiwi and all , Will go through all details and update here outcome.

Regards,

Fahim

Ask a Question
Discussion stats
  • 8 replies
  • 192 views
  • 2 likes
  • 4 in conversation