Hi,
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.
VERS_NR 2,801
VERS_DATO 01.01.1960
VERS_CLIENT_ID 301
VERS_TYPE LOAD_CST
VERS_TS 1960-01-01-00.00.00.253692
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
table=systemf.tbcrvers function=i;
mapto VERSNR = VERS_NR
VDATO = VERS_DATO
VCLIENT = VERS_CLIENT_ID
VTYPE = VERS_TYPE
VTS = VERS_TS;
update;
run;
Hi mate,
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
funded.
Check the working with SAS dates.
Att
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.