topic Re: Get minimum value of variable data in SAS Programming

Get minimum value of variable data

pdhokriya — Thu, 27 Aug 2020 13:18:08 GMT

Final data should be with money4 column with minimum value in data step or pro sql programming or macro

data b ;
input USUBJID MONEY1 MONEY2 MONEY3 ;
cards ;

10001 120 110 300
20001 120 10 300
30002 120 900 90
;
run;

I want output in new column Money4
where i will get min value of (money1 money2 money3)
i.e
Money4
110
10
90

Thank you

Re: Get minimum value of variable data

novinosrin — Thu, 27 Aug 2020 13:22:38 GMT

data b ;
input USUBJID MONEY1 MONEY2 MONEY3 ;
cards ;

10001 120 110 300
20001 120 10 300
30002 120 900 90
;
run;

data want;
 set b;
 money4=min(of money1-money3);
run;

Re: Get minimum value of variable data

chaoli — Thu, 27 Aug 2020 13:26:10 GMT

data b ;
input USUBJID MONEY1 MONEY2 MONEY3 ;
cards ;

10001 120 110 300
20001 120 10 300
30002 120 900 90
;
run;

data a;
set b;
MONEY3=min(MONEY1, MONEY2, MONEY3);
run;

Re: Get minimum value of variable data

pdhokriya — Fri, 28 Aug 2020 03:35:34 GMT

Ok Thank you.

What about proc sql syntax?

Re: Get minimum value of variable data

Kurt_Bremser — Fri, 28 Aug 2020 05:18:51 GMT

@pdhokriya wrote:
Ok Thank you.

What about proc sql syntax?

You also use the MIN function in the SELECT.

Re: Get minimum value of variable data

pdhokriya — Sat, 29 Aug 2020 17:01:36 GMT

Thank you , I will try this.