Hi Friends,
We have SAS Viya license. SAS® Studio (5.1), SAS® Viya® release:V.03.04.I failed to load cas in memory data to teradata db. But the reverse case load data from teradata db to cas in memory successfully. But i can successfully load data to Teradata db using SAS 9.4 libname or proc sql successfully.
Please suggest. Please find my code below.
--------------------------------Load teradata db to cas in memory------------------Successful----------------------------------------------------------
cas;
caslib tdlib
datasource=(srctype='teradata' dataTransferMode='serial' server='AWSTEST'
username='sasbi' password='sasbi' database='BIM');
run;
caslib _all_ list;
proc casutil;
list tables incaslib="casuser";
load casdata="price_dates" incaslib="tdlib" outcaslib="casuser" casout="price_dates_1";
list tables incaslib="casuser";
quit;
libname pp cas caslib=casuser;
proc print data =pp.price_dates_1(obs=10);
run;
---------------------------------Load cas in memory data to teradata db--------------------Failed-------------------------------------------------------
cas;
libname mycas cas caslib=casuser;
data mycas.carsWght;
set sashelp.cars;
if weight<5500 then delete;
keep make model type weight MPG_City;
run;
options msglevel=i;
caslib tdlib
datasource=(srctype='teradata' dataTransferMode='serial' server='AWSTEST'
username='sasbi' password='sasbi' database='BIM');
run;
proc casutil;
list tables incaslib="casuser";
load casdata="carsWght" incaslib="casuser" outcaslib="tdlib" casout="carsWght_1";
list tables incaslib="tdlib";
quit;
libname mytdlb cas caslib=tdlib;
proc print data=mytdlb.carsWght_1(obs=10);
run;
Regards,
Bimal