@chriskoeo ,
Here is a basic example:
cas casauto;
proc casutil;
load data=sashelp.cars
replace;
quit;
proc casutil outcaslib="public";
promote casdata="cars";
quit;
proc cas;
table.deleteRows / table={caslib="public", name="cars", where="Make='Chrysler'"};
run;
cas casauto terminate;
Here is what you will see in the SAS log:
93 proc cas;
94 table.deleteRows / table={caslib="public", name="cars", where="Make='Chrysler'"};
95 run;
NOTE: Active Session now CASAUTO.
{rowsDeleted=15}
With this approche table stays in memory and the "update" taking place in memory?
That is correct.
... View more
