How to extract the data for current year and previous year

Venkata Ramayya · Posted: Thu Jan 05, 2023 10:20 pm

Hello,

I have a year the in the input file. I have to extract data for current year and previous year only using sort card. Please help

Thanks
Venkat

sergeyken · Senior Member Joined: 29 Apr 2008 Posts: 1751

Venkata Ramayya · Posted: Thu Jan 05, 2023 11:14 pm

No I have not tried anything. Year is not static value in this case. It will keep changing every year. I think I need to use some date function in the sort card. I need help on that. Thanks

sergeyken · Senior Member Joined: 29 Apr 2008 Posts: 1751

Venkata Ramayya · Posted: Thu Jan 05, 2023 11:38 pm

I thought someone would post an example here. Anyways, thanks for the document. I will take a look.

Rohit Umarjikar · Posted: Fri Jan 06, 2023 5:14 am

Cleaned up and let us adhere to the forum rules.

You need to show us sample data and expected output for anyone here to help you. I restate to search this forum for having many examples of how to filter on dates in include condition.

Try it .

Joerg.Findeisen · Posted: Fri Jan 06, 2023 6:28 pm

You could use DATE<n> and DATEDIFF to build symbolics in a first step. In the next step compare against the freshly created SYMNAMES. This is not much lines of code.

Rohit Umarjikar · Posted: Sat Jan 07, 2023 2:50 am

Agree with Joreg but can be done in a single step. This is how it can be used, just replace with your year.
ibmmainframes.com/about57873.html

Joerg.Findeisen · Posted: Mon Jan 09, 2023 1:01 pm

Minor mistake by me, but the solution is on the same page in DFSORT manual as DATEDIFF. Obviously it should be SUBYEARS keyword (as I have used in my test case).