DFSORT - number of occurrences of each column



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

DFSORT - number of occurrences of each column

Postby NAMPULA » Sun Jul 15, 2018 1:20 am

Hi,
Please, could you help me on this.


Layout:
I have this matrix with a group (1-3) and 4 columns:
Group....: position 1-3
Column(A): position 5-7.
Column(B): position 8-10.
Column(C): position 11-13.
Column(D): position 14-16.


GRP.(A)(B)(C)(D)

Data:
AAA 111        
AAA 111        
AAA     222    
AAA         333 
AAA         331 
AAA             441
AAA             442
AAA             442
BBB 123         
BBB         301 
BBB         301 
BBB             404
CCC     888    
 

output:
I need the number of occurrences of each column,
separated by position 1-3 (group), like this:

AAA 002 001 002 003
BBB 001 000 002 001
CCC 000 001 000 000


Thank you so much.
NAMPULA
 
Posts: 2
Joined: Sat Jul 14, 2018 10:26 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DFSORT - number of occurrences of each column

Postby NAMPULA » Sun Jul 15, 2018 2:03 pm

I have moved the new information from here to your original post and added the code tags to that post so that your data aligns. I have deleted the rest of this post. Use the code tags to display data, jcl screen shots and anything else that requires a fixed font and maintain multiple spaces. It is simple to that; simply highlight the text to be coded and click the 'Code' button in the editor. You will need to use the full editor to see the buttons.
NAMPULA
 
Posts: 2
Joined: Sat Jul 14, 2018 10:26 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post