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.
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
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.
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;
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
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
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.