Load & unload data in cas in SAS Viya

[SatishR]

Hello team,

I am using below code to unload and load data in cas

cas casauto sessopts=(caslib="test123");

caslib mycaslib datasource=(srctype='sqlserver' user='xxxxxxx' password='xxxxxxxx' sqlserver_dsn="xxxxxxx"
schema=dbo catalog=*);

PROC CASUTIL;
droptable CASDATA="Event_calltype_analysis_rpt"
INCASLIB="test123";
QUIT;

caslib _all_ assign;
proc casutil;
load casdata="Event_calltype_analysis_rpt" incaslib="mycaslib" outcaslib="test123" casout="Event_calltype_analysis_rpt" promote;
quit;

However, I am getting below warning 

NOTE: Performing serial LoadTable action using SAS Data Connector to SQL Server.

WARNING: WARNING: [SAS][ODBC SQL Server Wire Protocol driver]Fractional truncation. Error in column 37.

Warning count is too much

Column 37 is 

How to resolve this issue. Thanks in advance

[ChrisNZ]

This typically happens because the data type does not support time fractions (milliseconds).
A workaround is to round the value to the nearest second.

[SatishR]

@ChrisNZ  any solution to trunctate this fraction in Load statement?

[ChrisNZ]

If the target does not support the data type, you need to modify the source data.

Either a temporary solution that preserves the current data: create a view and upload it if that's supported,

or a permanent solution: round the values in the source table.

You might be able to compute a new variable on the fly, I've never tried that (options COMPPGM and COMPVARS, see here).