Hi ,
I am accessing DB2 table thru SAS program, I need to retrieve infomation based on DATE field of DB2 table, Please advise how it can be done
I need to extract data from DB2 table from execution date + 1 month from execution date
Type Column Name
DATE B
Getting exec_date in following format ddmmyyyy thru JCL.
Select A
,B
,C
From TABLE_Ax
,TABLE_Bx
Where B + 1 Month > exec_date
and B <= exec_date
How can I change exec_date into DATE field of DB2 table(DD.MM.YYYY) and also add +1 month to database date field
Hi,
I have got the solution , refer SAS format and informat reference document for that,
To convert date parameter received from jcl,
Execdate=put(input(substr(param),ddmmyy10.),ddmmyyp10.) ;
and in where clause need 's' in defining month.
Where B + 1 Months > exec_date
and B <= exec_date
Hi,
I have got the solution , refer SAS format and informat reference document for that,
To convert date parameter received from jcl,
Execdate=put(input(substr(param),ddmmyy10.),ddmmyyp10.) ;
and in where clause need 's' in defining month.
Where B + 1 Months > exec_date
and B <= exec_date
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.