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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.