topic Re: remove repeated data and retain the maximum value in ODS and Base Reporting

remove repeated data and retain the maximum value

deleted_user — Sun, 29 Mar 2009 00:17:00 GMT

Hi,

Do you know the script or procedure in JMP on how to remove the repeated items and still retain the row with maximum data. ie

Raw Data
Company Job Salary
ABC D 50
ABC D 60
DEF F 70
DEF G 80

Desired Output
Company Job Salary
ABC D 60
DEF G 80

Thanks,
Phil

Re: remove repeated data and retain the maximum value

sbb — Wed, 01 Apr 2009 15:18:55 GMT

Here's one SAS programming approach using only SORT to generate the result you showed:

data ;
input Company $ Job $ Salary ;
datalines;
ABC D 50
ABC D 60
DEF F 70
DEF G 80
run;
proc sort ;
by company descending salary;
run;
proc sort nodupkey equals ;
by company ;
run;
options nocenter;
proc print u noobs;
run;

Scott Barry
SBBWorks, Inc.

Re: remove repeated data and retain the maximum value

Alankar — Fri, 03 Apr 2009 02:27:26 GMT

Hi Scott,

Good Answer.
I've a small Question.
Actually in Proc Sort what is the functionality of "Equals","Noequals".
In which conditions we need to use those options?

Thanks,
Alankar

Re: remove repeated data and retain the maximum value

Cynthia_sas — Fri, 03 Apr 2009 04:16:03 GMT

Hi:
The documentation talks about it in great detail:
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a000146878.htm

in short:
EQUALS: Maintain relative order within BY groups
NOEQUALS: Do not maintain relative order within BY groups

cynthia