How to suppress repeated values using DFSORT



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

How to suppress repeated values using DFSORT

Postby shankar_dh » Mon Apr 21, 2014 5:58 pm

Hi,

How to suppress the repeated values using sort?
Like,
I have records
01000 X
01000 Y

I want it like,
01000 X
      Y



Thanks,
Shankar.
shankar_dh
 
Posts: 41
Joined: Fri Mar 22, 2013 1:00 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to suppress repeated values using DFSORT

Postby BillyBoyo » Mon Apr 21, 2014 7:37 pm

Have a look at IFTHEN=(WHEN=GROUP with KEYBEGIN and PUSH a SEQuence number.

Then have IFTHEN=(WHEN=(logical expression which tests the sequence number. If that is not one, blank out your key field.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to suppress repeated values using DFSORT

Postby skolusu » Mon Apr 21, 2014 10:21 pm

shankar_dh,

what happened to the other topic of multiplying large numbers? dfsort-icetool-icegener/topic9855-10.html#p49301

Was SAS handling it without rounding?
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post