10-19-2015 09:39 AM
I am using this procedure to insert a record into my DB2 table.
The issue is that I am getting cutoff date when the row gets updated in DB2, whereas I am passing date from SAS dataset and Current timestamp.
Please let me know why it is happening and how to sort out the issue.
Output from SAS Dataset :
VTYPE VERSNR VDATO VCLIENT VTS
LOAD_CST 2801 21331 301 1760887609
Excerpt from Code :
proc db2util data=abcd SSID=db0t
mapto VERSNR = VERS_NR
VDATO = VERS_DATO
VCLIENT = VERS_CLIENT_ID
VTYPE = VERS_TYPE
VTS = VERS_TS;
10-22-2015 07:24 AM - edited 10-22-2015 07:24 AM
This happens sometimes, because if you declare a SAS Date without the correct syntax
it will uderstand that you are making an expression and will print a value close to zero,
the zero if you transform into date format it will be 01/01/1960 that's when SAS was
Check the working with SAS dates.