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..
@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.
1. What version of SAS Viya are you using?
2. Please review the documentation for PROC CASUTIL:
3. Please share your complete code, including:
@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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.