topic Re: finding the range of a value in SAS Programming

finding the range of a value

Anita_n — Wed, 10 Nov 2021 14:30:01 GMT

Dear all,

assuming I have this dataset and I want to find the range of the ages.

If I want the range to be displayed like (23-94). How do I do that?

data have;
    infile datalines truncover ;
  input age;
datalines;
23
43

55
60
94
55
60

;
run

Re: finding the range of a value

andreas_lds — Wed, 10 Nov 2021 14:33:58 GMT

What do expect as result exactly?

Untested:

data want;
  set have end=jobDone;
  retain min max;
  if _n_ = 1 then do;
    min = 99999;
    max = 0;
  end;

  min = min(min, age);
  max = max(max, age);

  if jobDone then do;
    put min " - " max;
  end;
run;

Re: finding the range of a value

Ksharp — Thu, 11 Nov 2021 13:53:34 GMT

data have;
    infile datalines truncover ;
  input age;
datalines;
23
43
.
55
60
94
55
60
;


proc sql;
select cats('(',min(age),'-',max(age),')') as range label='#'
 from have;
quit;

Re: finding the range of a value

Kurt_Bremser — Thu, 11 Nov 2021 14:01:18 GMT

proc sql;
select min(age), "-", max(age)
from have;
quit;

Re: finding the range of a value

Anita_n — Mon, 15 Nov 2021 10:01:49 GMT

@andreas_lds @Ksharp @Kurt_Bremser : Thankyou all for the reply, I will try that