- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
How to resolve this issue. Thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
A workaround is to round the value to the nearest second.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@ChrisNZ any solution to trunctate this fraction in Load statement?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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).