topic Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory in SAS Visual Analytics

Get a list of all tables loaded in SAS Visual Analytics LASR memory

Filipvdr — Mon, 11 Sep 2017 15:36:28 GMT

Hi,

I need an export in .csv or excel of the management table in SAS VA which shows all tables (loaded/not loaded) and library. Is it stored somewhere? Because i can't rightclick and export.

Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory

RexDeus9 — Wed, 21 Nov 2018 19:57:22 GMT

Hi,

This baffals me. More than one year later and no reasonable SAS resource can answer this!!!!

I am looking for the same thing, but using SAS code (eg proc IMSTAT TABLEINFO) but I can't get any sensible answer NO WHERE.

I will update when there...

Yvan

Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory

Filipvdr — Thu, 22 Nov 2018 13:18:42 GMT

Hi Yvan,

I did the following steps:

Get a list of al my LASR libraries.

Loop through this list and assign the library.

Using proc datasets getting a list of the tables in the library.

Maybe not the best solution, but it worked for me.

Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory

RexDeus9 — Thu, 22 Nov 2018 13:22:42 GMT

Hi Filipvdr,

Good, nice that you got what you were looking for. In my case, I'm looking
to retrieve a list of all Tables that are 'loaded' in LASR memory.

Thank you,

Yvan

Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory

alexal — Thu, 22 Nov 2018 14:23:02 GMT

@RexDeus9,

I'm looking to retrieve a list of all Tables that are 'loaded' in LASR memory.

LIBNAME LASRLIB SASIOLA  TAG=VAPUBLIC  PORT=<LASR_PORT> HOST="<HEAD_NODE_FQDN>"  SIGNER="<MIDDLE_TIER_URL>/SASLASRAuthorization" ;

data tablemem;
    set lasrlib._T_TABLEMEMORY;
run;

proc print data=tablemem;
    var tablename;
run;

Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory

Filipvdr — Thu, 22 Nov 2018 14:23:17 GMT

Yes, that is what proc datasets gives me.

I also got all tables registered in metadata to retrieve all the tables, not only the loaded ones

Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory

Filipvdr — Thu, 22 Nov 2018 14:53:29 GMT

@alexal: this gives me more the same then proc datasets. The fact is, if i have for example 50 different LASR libraries, i will have to assign them one by one...

Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory

RexDeus9 — Thu, 22 Nov 2018 15:03:42 GMT

Hi Alexal,

Thx, now we're talking, exactly what I needed!

Yvan

Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory

ocrambo — Tue, 02 Jun 2020 12:10:02 GMT

Hi,

It is possible to get al list of all loaded tables in LASR with proc IMSTAT. And what's not in can't get out 🙂

fill in the correct values of the variables:

%LET POORT=;

%LET AL_LASRHOST= ;
%LET AL_HOST=;
%LET AL_LASRINST=;
%LET AL_SIGNER=;
%LET AL_PATH=;
%LET AL_TABLEMEM=;
%LET AL_LOGGINGENABLED=;
%LET AL_LOGGINGKEEPLOG=KEEPLOG;

and run........

PROC IMSTAT;
TABLEINFO / port=&Poort.;
RUN;

Cheers

Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory

shekhar_chavan — Fri, 15 Mar 2024 06:02:12 GMT

Below code can be used to get the list of tables loaded on the LASR:

LIBNAME LASRLIB SASIOLA TAG=VAPUBLIC PORT=10031 HOST=<HOSTNAME> SIGNER="http://<hostname>:<port_no>/SASLASRAuthorization" ;

%let sizecols = InMemorySize UncompressedSize
CompressedSize TableAllocatedMemory
InMemoryMappedSize ChildSMPTableMemory
VirtualMemory ResidentMemory AllocatedMemory;
%let countcols = NumberRecords UseCount RecordLength ComputedColLength;

data tablemem;
set lasrlib._T_TABLEMEMORY;
run;

data lasrmem;
set lasrlib._T_LASRMEMORY;
run;

proc print data=lasrmem;
title "LASR Server Memory Usage";
format &sizecols. sizekmg9.2;
format &countcols. 8.;
sum _numeric_;
run;

proc print data=tablemem;
title "LASR Server Table Memory Usage";
format &sizecols. sizekmg9.2;
format &countcols. 8.;
sum _numeric_;
run;