topic Re: Get a min and max in SAS Programming

Get a min and max

SASPhile — Sun, 08 Apr 2012 19:05:46 GMT

I have a pulse rate column with takes values like 100-125 or 60-80 or 60-125.

Now how to separate the min and max from say 100-125 as min=100 and max=125.same with other values.

pulse min max

100-125 100 125

60-125 60 125

60-80 60 80

art297 — Sun, 08 Apr 2012 19:40:43 GMT

scan function should work. try (untested)

min=scan(pulse,1);

max=scan(pulse,2);

SASPhile — Sun, 08 Apr 2012 20:15:49 GMT

thanks art. if the column has missing value?

art297 — Sun, 08 Apr 2012 21:45:35 GMT

You could just precede the call with an if statement. Again, not tested:

if not missing(pulse) then do;

min=scan(pulse,1);

max=scan(pulse,2);

end;