|
View previous topic :: View next topic
|
| Author |
Message |
amirberner
New User
Joined: 14 Oct 2021
Posts: 2
Location: israel
|
|
|
|
Hi,
I have a file consisting of name, date and number
I want to sort the data by name and date, and add a counter that will show how many records I have for the combination of name and date.
e.g.
name date number counter
James 14.2 50 1
James 14.2 100 2
James 14.2 70 3
James 20.2 100 1
Kevin 5.1 100 1
Kevin 14.2 50 1
Kevin 14.2 32 2
how do I do it?
thanks |
|
| Back to top |
|
 |
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1134
Location: Bamberg, Germany
|
|
|
|
Provide samples of Input and desired Output. Make use of code tags (button Code works as a toggle), check with preview before hitting submit. Show what you have attempted by yourself, error codes and such, if any.
PS: Real OS know Datasets but not files. |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 1875
Location: USA
|
|
|
|
I need to add that this task cannot be done using neither JCL, nor VSAM.
Wrong forum section.
One way to do this is, using DFSORT/SYNCSORT.
Many other ways are available, too, but no JCL/VSAM under any circumstances. |
|
| Back to top |
|
|
|
|
