BookmarkSubscribeRSS Feed
pathanfahim1986
Fluorite | Level 6

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

 

8 REPLIES 8
SASKiwi
PROC Star

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;
pathanfahim1986
Fluorite | Level 6

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

SASKiwi
PROC Star

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.

pathanfahim1986
Fluorite | Level 6

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

 

pathanfahim1986
Fluorite | Level 6

@sandykota thanks. 

 

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

 

Thanks & Regards, 

Fahim

pathanfahim1986
Fluorite | Level 6

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

Regards,

Fahim

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 8 replies
  • 1387 views
  • 2 likes
  • 4 in conversation