topic Re: What is the code equivalent of load table from VIYA data explorer? in SAS Viya

What is the code equivalent of load table from VIYA data explorer?

Ullsokk — Fri, 19 Feb 2021 13:48:54 GMT

What is the code equivalent of loading a table to memory, as illustrated in this screenshot? I need to load sas_model_table from a CAS publishing destination in code. I have tried the following:

proc casutil  ;
load casdata="&table" casout="&table" outcaslib="&caslib" incaslib="&caslib";
run;

But I get the following error:

ERROR: The file or path 'SAS_MODEL_TABLE' is not available in the file system.
ERROR: The action stopped due to errors.

Re: What is the code equivalent of load table from VIYA data explorer?

Ullsokk — Fri, 19 Feb 2021 14:19:13 GMT

Found the sollution:

	proc casutil incaslib="Mod_pub" outcaslib="MOD_PUB" ;
    load casdata='sas_model_table.sashdat' 
	casout="SAS_MODEL_TABLE"  promote;
	quit;

I have no idea why the casdata all of the sudden needs a .sashdat extension, or why the outcaslib is uppercase, and the incaslib lower case. Same with the casout. I really hope this is due to some sloppyness on my end when setting things up.