IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DFSORT : GroupBy


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
nnkthri

New User


Joined: 01 Apr 2016
Posts: 1
Location: India

PostPosted: Fri Apr 01, 2016 3:22 pm
Reply with quote

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
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Sat Apr 09, 2016 9:16 pm
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
No new posts DFSORT - VB file RDW getting overridden DFSORT/ICETOOL 3
Search our Forums:

Back to Top