Load and Unload datatable in sas viya caslib

[SatishR]

Hi guys... I have connectivity with Sql Srv database using Odbc connectivity. To load and unload data automatically on daily basis i m traying to write below code

/* Unload data from source table */
PROC CASUTIL;
ALTERTABLE CASDATA="Feedback_data" INCASLIB="test123" CASOUT="feedback_data" INCASLIB="test123";
QUIT;

/* Load data into destination table from SAS data set */
PROC CASUTIL;
LOAD CASDATA="SAS-data-set" INCASLIB="test123" CASOUT="feedback_data" OUTCASLIB="test123";
QUIT;


but I am Getting below error..

ERROR: A connection to the Cloud Analytic Services session could not be made.

ERROR: An error has occurred.

90 LOAD CASDATA="SAS-data-set" INCASLIB="test123" CASOUT="feedback_data" OUTCASLIB="test123";

ERROR: An error has occurred.

how to make connection to caslib ?

[SASJedi]

1. What version of SAS Viya are you using?

2. Please review the documentation for PROC CASUTIL:

• The ALTERTABLE statement modifies an existing CAS table; it does not unload a table. To unload a CAS table from memory, use the DROPTABLE statement. 
• To load a dataset from an existing SAS library to CAS, your LOAD statement should use Form 2 (LOAD DATA= )
  Note that this will perform a client-side load of the data, and may take a long time if the data is large.

3. Please share  your complete code, including:

• the CAS statement (which initiated the CAS session)
• the CASLIB statement (which established the caslib test123)

[SatishR · Accepted solution]

@SASJedi Thanks for reply... I followed steps mentioned by you.

I am using SAS VIYA V.03.05.

Below code able to establish the cas session and load and unload the table from caslib created.

LIBNAME test123 ODBC  NOPROMPT="dsn=XXXXXXXXX;Trusted_Connection=yes"  SCHEMA=DBO ;

cas casauto sessopts=(caslib="test123"); 

/*To Unload the Data*/

PROC CASUTIL;

droptable CASDATA="Class_test" 

INCASLIB="test123";

QUIT;

/*To load the Data*/

proc casutil;

       load data=test123.Class_test promote;                                     /* 2 */  

   contents casdata="Class_test";

run;