topic Re: replace lowest value in a list of numbers in SAS Programming

replace lowest value in a list of numbers

GreggB — Tue, 08 Dec 2020 16:28:59 GMT

Students take 4 tests and a final exam. I replace the lowest test grade with the final exam grade. If the final exam is the lowest grade, nothing happens. If there is a tie between the 2 lowest grades, I don't care which one involved in the tie gets replaced.

Example:

data before applying the substitution

test1 test2 test3 test4 final

88 90 100 50 75

90 55 70 100 50

data after applying the substitution

test1 test2 test3 test4 final

88 90 100 75 75

90 55 70 100 50

Re: replace lowest value in a list of numbers

FreelanceReinh — Tue, 08 Dec 2020 16:47:59 GMT

Hi @GreggB,

Try this:

data have;
input test1-test4 final;
cards;
88 90 100 50 75
90 55 70 100 50
;

data want;
set have;
array g[*] test1--final;
g[whichn(min(of g[*]), of g[*])]=final;
run;

Re: replace lowest value in a list of numbers

Ksharp — Wed, 09 Dec 2020 14:01:54 GMT

What if there are two 50 in the first obs?

data have;
input test1-test4 final;
cards;
88 90 100 50 75
90 55 70 100 50
;

data want;
set have;
array g{*} test1--test4;
do i=1 to dim(g);
g{i}=max(g{i},final) ;
end;
drop i;
run;

Re: replace lowest value in a list of numbers

Ksharp — Wed, 09 Dec 2020 14:07:21 GMT

what if there are two 50 in the first obs ?

data have;
input test1-test4 final;
cards;
88 90 100 50 75
90 55 70 100 50
;

data want;
set have;
array g{*} test1--test4;
do i=1 to dim(g);
  g{i}=max(g{i},final) ;
end;
drop i;
run;

Re: replace lowest value in a list of numbers

GreggB — Wed, 09 Dec 2020 14:27:57 GMT

I would want to replace one of them. It wouldn't matter which one.