https://communities.sas.com/t5/SAS-Programming/How-to-upload-a-CAS-table-to-Oracle/m-p/892821#M352658 <P>From my limited understanding of Viya the <A href="https://documentation.sas.com/doc/en/pgmsascdc/v_042/casref/p1momv516ndlt7n1vhgva4urpuk6.htm" target="_blank" rel="noopener">CASUTIL procedure</A> is one way to do this. Check out the doc link and look at the SAVE statement which allows you write a CAS table to an external database via a Viya Data Connector.</P> Tue, 05 Sep 2023 23:47:14 GMT SASKiwi 2023-09-05T23:47:14Z https://communities.sas.com/t5/SAS-Programming/How-to-upload-a-CAS-table-to-Oracle/m-p/892785#M352646 <P>I used to have the below base SAS code to append a sas table to an Oracle table. I want o convert it to CAS. Does anyone have any idea how to append a CAS table to an Oracle table?&nbsp;</P><P>&nbsp;</P><P>proc append base=Oracle.gtt_clm_t<BR />data=work.clms<BR />force nowarn;<BR />run;</P> Tue, 05 Sep 2023 18:55:51 GMT https://communities.sas.com/t5/SAS-Programming/How-to-upload-a-CAS-table-to-Oracle/m-p/892785#M352646 daisyxiang 2023-09-05T18:55:51Z https://communities.sas.com/t5/SAS-Programming/How-to-upload-a-CAS-table-to-Oracle/m-p/892821#M352658 <P>From my limited understanding of Viya the <A href="https://documentation.sas.com/doc/en/pgmsascdc/v_042/casref/p1momv516ndlt7n1vhgva4urpuk6.htm" target="_blank" rel="noopener">CASUTIL procedure</A> is one way to do this. Check out the doc link and look at the SAVE statement which allows you write a CAS table to an external database via a Viya Data Connector.</P> Tue, 05 Sep 2023 23:47:14 GMT https://communities.sas.com/t5/SAS-Programming/How-to-upload-a-CAS-table-to-Oracle/m-p/892821#M352658 SASKiwi 2023-09-05T23:47:14Z