06-05-2018 06:13 PM
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 ;
libname sandbox cas caslib="Sandbox" datalimit=all;
create table work.test1 as
where ac_type='021' and asofdate='30MAR2018'd;
*Promote data set to in-memory cas table;
load casdata="test1" incaslib="Sandbox"
outcaslib="Public" casout="test1" promote;
But this shows errors:
06-06-2018 07:27 AM
ERROR: ERROR: ERROR: relation does not exist ANALYSIS._ANALYSIS.test1
The error shown above has been generated by proc sql, not by proc casutil.
06-06-2018 09:15 AM
@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..