question about coding array for money and choosing highest payment

lmyers2 — Mon, 27 Nov 2017 12:26:46 GMT

Hello,

I'm using SAS 9.4 full version. I have the following sample data where the payments are formatted into a money variable. I want to code an array to keep the highest payment per line and maintain money formatting. Is an array the best way to do this? How do I maintain the money formatting?

Payment1 Payment 2 Payment 3

Person 1 $500 . $750

Person 2 $100 . .

Person 3 . $450 $400

I want:

Highest Payment

Person 1 $750

Person 2 $100

Person 3 $450

Thank you in advance for the help!

Re: question about coding array for money and choosing highest payment

Kurt_Bremser — Mon, 27 Nov 2017 12:48:03 GMT

Use the max() function and the dollar format:

data have;
input (paym1-paym3)(:10.);
format paym1-paym3 dollar10.2;
cards;
500 . 750
;
run;

data want;
set have;
max_paym = max(of paym1-paym3);
format max_paym dollar10.2;
run;

proc print data=want noobs;
run;

Result:

   paym1         paym2         paym3      max_paym

 $500.00           0         $750.00       $750.00

topic question about coding array for money and choosing highest payment in SAS Programming

question about coding array for money and choosing highest payment

Re: question about coding array for money and choosing highest payment