Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

promote temporary table from sas studio to sas VA

Reply
Occasional Contributor
Posts: 19

promote temporary table from sas studio to sas VA

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! 

Ask a Question
Discussion stats
  • 0 replies
  • 110 views
  • 0 likes
  • 1 in conversation