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
... View more