topic Re: Load & unload data in cas in SAS Viya in SAS Programming

Load & unload data in cas in SAS Viya

SatishR — Wed, 17 Jul 2024 05:50:16 GMT

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

Re: Load & unload data in cas in SAS Viya

ChrisNZ — Wed, 17 Jul 2024 08:27:59 GMT

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

Re: Load & unload data in cas in SAS Viya

SatishR — Wed, 17 Jul 2024 12:29:31 GMT

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

Re: Load & unload data in cas in SAS Viya

ChrisNZ — Thu, 18 Jul 2024 10:46:08 GMT

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).