finding the range of a value

[Anita_n]

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

[andreas_lds]

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;

[Ksharp]

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;

[Kurt_Bremser]

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

[Anita_n]

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