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
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 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.