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