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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.