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.
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;
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.