DATA Step, Macro, Functions and more

Loading data to DB2 table

Reply
N/A
Posts: 0

Loading data to DB2 table

Dear SAS,

I am getting a problem related to the value rounding off while loading the data to DB2 table from SAS Dataset using PROC APPEND.

Details:

Issue:

A 16 digit numeric field which contains value for e.g. as 8853159845301049 in SAS data set gets rounded off to 8853159845301050 while populating in DB2 using proc append in the table loader.
NOTE:
The metadata for a field in SAS Dataset is -
Type - Numeric
Length - 8
Format - 16.
Informat - 16.

The metadata for a field in DB2 is -
Type - DECIMAL
Precision - 16
Scale - 0

Please suggest the way by which this issue can be prevented.

Any help regarding this will be highly appreciated.

regards
Kapil Agrawal
Ask a Question
Discussion stats
  • 0 replies
  • 98 views
  • 0 likes
  • 1 in conversation