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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.