sort on accending order and display the count.

[bodhi]

Hello All,

I have a file with the record count of 1000000 in which i need to sort the data on the accending order and then display the record count for a particular condition. Below is the example for better understanding:

Input file:
P AAAA
P AAAA
P AAAA
P BBBB
P BBBB
P CCCC
P DDDD


Output file:
AAAA 3
BBBB 2
CCCC 1
DDDD 1

Thanks
Bodhi

[arcvns]

Bodhi,

display the record count for a particular condition

What's your condition here? It seems like u r counting all occurrences of field-2.

[bodhi]

Yes, I am counting all the occurrences of the field-2.

Bodhi

[lal]

Hi Bodhi,
Following JCL should help you...

Code: Select all

//SORTIN   DD *                                                     
P AAAA                                                             
P AAAA                                                             
P AAAA                                                             
P BBBB                                                             
P BBBB                                                             
P CCCC                                                             
P DDDD                                                             
//SORTOUT  DD SYSOUT=*                                             
//SYSIN    DD *                                                     
  SORT FIELDS=(3,4,CH,A)                                           
  OUTFIL REMOVECC,NODETAIL,                                         
  SECTIONS=(3,4,TRAILER3=(3,4,5X,COUNT))                           
//*     


Thanks,
lal

[bodhi]

Thank you Lal it is working fine for me.

Bodhi