The system options statement:
option CASNCHARMULTIPLIER=4;
...can be used to handle some transcoding errors and possibly address the BLOB issue, since SAS sees that as a large CHAR data type. I had to use the above for just loading a Viya table from a Windows 2012 Server-based 9.4M6 platform to a Viya 3.4 platform. It cleared up the errors messages and allowed the loads to continue. A full implementation of this established before the caslib and session in EG would be:
option CASNCHARMULTIPLIER=4; options CASHOST="server.domain.us" CASPORT=5570 ; cas sessCon; caslib myCASLib SESSREF=sessCon datasource=(srctype="path") path="/sasdata/departments/daily/data" GLOBAL;
proc casutil outcaslib="myCASLib"; load data=srcelib.Daily_Transactions promote;
run;
cas sessCon terminate;
In DI Studio if you are using the CAS Loader transform, you would place the CASNCHARMULTIPLIER system option in the "System Options" field, Additional Options* section, under the Options tab...
... View more
