08-08-2017 08:33 AM
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.
08-08-2017 08:38 AM
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;
08-08-2017 08:43 AM
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.