topic Re: Programmatically check LASR Table Status in SAS Visual Analytics

Programmatically check LASR Table Status

eslna — Fri, 26 Aug 2016 19:55:15 GMT

Hello guys,

I have been looking around the communities and Google today trying to find a way to do this but I havent been able to. I am new-ish to SAS programming so please bear with me.

I would like to write a program that automatically checks which tables are loaded in LASR and do a proc contents ONLY to the tables that are currently loaded.

I have looked at Proc imstat, Proc SQL, Proc LASR to see if there is a way to check Load/Unload status on a LASR table but I am coming up empty.

Is there a SAS Variable(either in dictionary or otherwise) that provides this information, and if so, which Proc would work best?

Re: Programmatically check LASR Table Status

Shmuel — Sat, 27 Aug 2016 15:28:42 GMT

Im not familiar with SAS Analytics, but I have the feeling that you might find answer or guide in the next link:

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

Look also to the contents on left side of the page.

Using SAS BASE / SQL you can get all availabale tables and columns by:

Proc sql;

create table u_name_it as select *

from dictionary.columns;

quit;

I don't know how to recognize LASR tables and distinguish them from others.

If you know add a WHERE statment to the SQL, to subset them only.

Re: Programmatically check LASR Table Status

SASKiwi — Mon, 29 Aug 2016 04:31:17 GMT

A great question and one I'd like to know the answer for too. I did a bit of searching and I think the answer is here in the special memory usage tables available for SAS VA:

http://support.sas.com/documentation/cdl/en/inmsref/68736/HTML/default/viewer.htm#p050lknh5xepngn1s2kaa5nijrer.htm

Re: Programmatically check LASR Table Status

mike2468 — Mon, 29 Aug 2016 13:24:55 GMT

I wrote a macro to do something similar. I wanted to check a table's load status and, if it is unloaded, fire a stored procedure that loads it. It's for reloading critical tables after a reboot, but you could adapt it for your needs. It uses the _T_TABLEMEMORY set in the LASR library.

Instead of checking a specific table you will want to filter down the loadedtables dataset and then iterate through the rows to fire your PROC CONTENTS.

data loadedtables;
set VALIBLA._T_TABLEMEMORY;
run;

%macro ifunloaded(tablename, thescript);
	proc sql noprint;
		select count(*) into :OBSCOUNT from loadedtables where tablename = upper(&tablename) and uncompressedsize > 0;
	%if &OBscount = 0 %then %do;
		%put "&tablename is unloaded, we need to reload it";
		proc stp program=&thescript; 
		run;
		put "Table &tablename was unloaded and reload was attempted.";
		
	%end;
	%else %do;
		%put "&tablename is already loaded, leave it alone";
	%end;
%mend ifunloaded

Re: Programmatically check LASR Table Status

eslna — Mon, 29 Aug 2016 13:23:33 GMT

Thanks for the replies, will look into each and every one today and let you know which one worked best.

Re: Programmatically check LASR Table Status

eslna — Mon, 29 Aug 2016 17:59:56 GMT

So you are basically checking if there are any observations first. That is very ingenious. I will keep it in mind. Will continue to research if there is an actual flag that can be surfaced via Base SAS code first though.

Re: Programmatically check LASR Table Status

eslna — Mon, 29 Aug 2016 18:01:06 GMT

Dictionary.tables doesnt seem to have an attribute for Loaded/Unloaded status.

I also tried Dictionary.columns it either makes my SAS Session unresponsive, or errors out when it tries to read an unloaded table.