Page 1 of 1

How to suppress repeated values using DFSORT

PostPosted: Mon Apr 21, 2014 5:58 pm
by shankar_dh
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.

Re: How to suppress repeated values using DFSORT

PostPosted: Mon Apr 21, 2014 7:37 pm
by BillyBoyo
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.

Re: How to suppress repeated values using DFSORT

PostPosted: Mon Apr 21, 2014 10:21 pm
by skolusu
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?