Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
nnkthri

New User

Joined: 01 Apr 2016
Posts: 1
Location: India

Posted: Fri Apr 01, 2016 3:22 pm    Post subject: DFSORT : GroupBy

Hello All,

Please suggest how to achieve below desired result using DFSORT.

Input:
------
 Code: XXXXX;111;2014;AAAAA;222;2014;  XXXXX;111;2014;AAAAA;222;2014;  XXXXX;111;2014;AAAAA;222;2014;  ZZZZZ;111;2015;BBBBB;222;2015;  ZZZZZ;111;2015;BBBBB;222;2015;  ZZZZZ;111;2015;BBBBB;222;2015;  ZZZZZ;111;2015;BBBBB;222;2015;

Output:
-------
 Code: 2014       2015       Total Unique 111                   1           0 222                   1           0 Total Count 111                   0           3 222                   0           4

Total Unique --> distinct Count of XXXXX from pos 1 to 15 per year
distinct Count of AAAAA from pos 16 to 15 per year

Total count --> Number of occurances of XXXXX from pos 1 to 15 per year
Number of occurances of AAAAA from pos 16 to 15 per year

Rohit Umarjikar

Senior Member

Joined: 21 Sep 2010
Posts: 2443
Location: NY,USA

 Posted: Sat Apr 09, 2016 9:16 pm    Post subject: its not clear what is expected. but what is the problem that you face? There are many similar topics under dfsort forum, please take a look.
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Covert k to 1000 / m to 1000000 using... A_programmers DFSORT/ICETOOL 5 Tue Jun 23, 2020 6:52 pm DFSORT Output file order query A_programmers DFSORT/ICETOOL 2 Thu Mar 26, 2020 11:59 pm DFSORT-How to convert ZD to ZS in DFSORT useit DFSORT/ICETOOL 2 Thu Mar 26, 2020 10:43 am DFSORT to handle in between specific ... subratarec DFSORT/ICETOOL 6 Thu Feb 06, 2020 1:22 am Need help with this dfsort problem kushkush DFSORT/ICETOOL 7 Sun Feb 02, 2020 6:34 pm

 © 2003-2020 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us