topic Re: FInd Min and max value in SAS Programming

FInd Min and max value

pawandh — Tue, 19 Apr 2016 04:53:56 GMT

I want to find the min value.
data t;
input x;
cards;
10
20
40
30
26
;run;

i found this code

data t1;
set t end=last;
retain y;

y=min(y,x);
run;

And it's giving the right solution.I want to ask that initially the value of y is missing and if we using min(y,x) then it should come as missing value as missing value has the lowest priority, then how come it is coming 10 . Please explain.

Re: FInd Min and max value

user24feb — Tue, 19 Apr 2016 05:32:15 GMT

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245915.htm

.. the min function only returns a missing value, if all arguments are missing. This is simply how the function works.

Re: FInd Min and max value

Kurt_Bremser — Tue, 19 Apr 2016 05:45:37 GMT

All those summary functions (max, min, sum, ...) have the advantage that they return a non-missing value as long as one of the arguments is non-missing. If you want a missing value treated as the minimum, you will have to code that manually.

Re: FInd Min and max value

Reeza — Tue, 19 Apr 2016 06:11:38 GMT

Although it works I would highly recommend using proc means instead.

Proc means data=have stackods min max;
Var x;
ODS output summary=want;
Run;

Proc print data=want;
Run;