topic Re: promote table from temporary folder in SAS Visual Analytics

promote table from temporary folder

michellekwai — Tue, 05 Jun 2018 22:13:46 GMT

Hi everyone,

I know how to load table from internal database and promote the table to global session, I want to know if I create a table in work folder, or any any folder in sas studio, and want to load and promote this table which is created by sas program, what can I do?

Code is below:

*Create CAS libref ;
cas;
libname sandbox cas caslib="Sandbox" datalimit=all;

*Create table;
proc sql; 
create table work.test1 as
select *
from tlake.mkt_account
where ac_type='021' and asofdate='30MAR2018'd;
quit;

*Promote data set to in-memory cas table;
proc casutil; 
load casdata="test1" incaslib="Sandbox" 
outcaslib="Public" casout="test1" promote; 
run;

But this shows errors:

ERROR: ERROR: ERROR: relation does not exist ANALYSIS._ANALYSIS.test1

ERROR: Function failed.

ERROR: The action stopped due to errors.

Thanks!

Re: promote table from temporary folder

Reeza — Tue, 05 Jun 2018 22:48:41 GMT

Is this for SAS VA? If so, I'll move the question the SAS VA forum.

Re: promote table from temporary folder

michellekwai — Tue, 05 Jun 2018 22:56:25 GMT

I need to load and promote table for VA use... Yeah.. should I delete the post and post under VA section?

Re: promote table from temporary folder

alexal — Wed, 06 Jun 2018 11:27:17 GMT

@michellekwai,

ERROR: ERROR: ERROR: relation does not exist ANALYSIS._ANALYSIS.test1

The error shown above has been generated by proc sql, not by proc casutil.

Re: promote table from temporary folder

michellekwai — Wed, 06 Jun 2018 13:15:52 GMT

@alexal Thank you for your reply!

I want to create a temporary table in work folder and then promote this table to CAS.

I run proc sql seperately, but no error shows... when I run proc casutil.. the error shows..

Any suggestions?

Thanks!

Re: promote table from temporary folder

alexal — Wed, 06 Jun 2018 13:56:32 GMT

@michellekwai,

I would suggest opening a track with our access team. You can do it here:

https://support.sas.com/ctx/supportform/createForm

Re: promote table from temporary folder

michellekwai — Wed, 06 Jun 2018 14:58:17 GMT

ok. Thanks! @alexal