topic Load and Unload datatable in sas viya caslib in SAS Programming

Load and Unload datatable in sas viya caslib

SatishR — Fri, 22 Dec 2023 11:22:51 GMT

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 ?

Re: Load and Unload datatable in sas viya caslib

SASJedi — Fri, 22 Dec 2023 13:12:54 GMT

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)

Re: Load and Unload datatable in sas viya caslib

SatishR — Sat, 23 Dec 2023 07:06:36 GMT

@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;