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

SAS Visual Anlytics - Querying in memory table from EG

pathanfahim1986 — Thu, 23 Nov 2017 06:21:01 GMT

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

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

SASKiwi — Thu, 23 Nov 2017 07:06:16 GMT

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;

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

pathanfahim1986 — Thu, 23 Nov 2017 07:12:47 GMT

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

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

SASKiwi — Thu, 23 Nov 2017 07:38:00 GMT

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.

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

BrunoMueller — Thu, 23 Nov 2017 07:52:44 GMT

Also have a look at Proc IMSTAT

http://go.documentation.sas.com/?docsetId=inmsref&docsetTarget=p10dosb1fybvpzn1hw38gxuotopk.htm&docsetVersion=2.81&locale=en

http://go.documentation.sas.com/?docsetId=inmsref&docsetTarget=n1l5k6bed95vzqn1a47vafe3q958.htm&docsetVersion=2.81&locale=en

Using this procedure, processing will be done in the LASR Server

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

pathanfahim1986 — Thu, 23 Nov 2017 08:13:07 GMT

Thank you @BrunoMueller 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

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

sandykota — Thu, 23 Nov 2017 09:05:04 GMT

Hi Fahim,

Hope the below weblink is helpful to you:

http://support.sas.com/documentation/cdl/en/vaug/67270/HTML/default/viewer.htm#p0ci6glvfbc1kin1ipn3uae2xnyv.htm

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

pathanfahim1986 — Thu, 23 Nov 2017 09:35:57 GMT

@sandykota thanks.

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

Thanks & Regards,

Fahim

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

pathanfahim1986 — Wed, 29 Nov 2017 06:25:16 GMT

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

Regards,

Fahim