topic Picking largest value from two variables to create a third in SAS Enterprise Guide

Picking largest value from two variables to create a third

Sean_OConnor — Fri, 22 Mar 2019 12:41:22 GMT

Folks,

I have two variables on income, and I would like to choose whatever the biggest value is to put in a third one. However, in certain cases they will be the same so I need to let SAS know that in this case it can choose either.

Example

data have ;

  input id $ Var1 Var2 Var3  ;

cards;

a1 15000 20000 20000

a2 30000 5000 30000

a3 10000 10000 1000

run;

Any help would be welcome

Re: Picking largest value from two variables to create a third

Kurt_Bremser — Fri, 22 Mar 2019 12:42:58 GMT

Max() function:

var3 = max(var1,var2);

Re: Picking largest value from two variables to create a third

novinosrin — Fri, 22 Mar 2019 12:54:55 GMT


data have ;

  input id $ Var1 Var2   ;

cards;
a1 15000 20000 20000
a2 30000 5000 30000
a3 10000 10000 1000
;
run;

data want;
set have;
var3=largest(1,var1,var2);
run;