topic Re: Highest value between 4 variables in SAS Programming

Highest value between 4 variables

indox — Tue, 08 Aug 2017 12:33:06 GMT

Hello,

I have four variables A, B, C and D. For each row these variables have integer values.

I would like to know how to get the value of the highest variable between the 4. FOr example:

A B C D

12 11 18 7

The result should be 18.

I want to do this with proc sql.

Thanks for help.

Re: Highest value between 4 variables

PeterClemmensen — Tue, 08 Aug 2017 12:38:36 GMT

Like this?

data have;
	input A B C D;
	datalines;
	12
	11
	18
	7
	;

proc sql;
	create table want as
	select *
	      ,max(A,B,C,D) as highest_value
	from have;
quit;

Re: Highest value between 4 variables

RW9 — Tue, 08 Aug 2017 12:43:02 GMT

With your data:

data want;
  a=12; b=11; c=18; d=7;
  max=max(a,b,c,d);
  /* or */
  mx=max(of _numeric_);
run;

The second will take all numeric variables.