BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
NitinDwivedi
Calcite | Level 5


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

1 ACCEPTED SOLUTION

Accepted Solutions
NitinDwivedi
Calcite | Level 5

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

View solution in original post

1 REPLY 1
NitinDwivedi
Calcite | Level 5

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

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 1128 views
  • 0 likes
  • 1 in conversation