Arrray concepts

[robertrao]

Hi Team,

This example is from page 5 of the paper below.

http://www.sys-seminar.com/EE/Files/Arrays_Made_Easy(1).pdf

CAN ANYONE FROM THE TEAM EXPLAIN TO ME THE TECHNIQUE HOW SAS IS ABLE TO SPECIFICALLY CONSIDER 4th POSITION IN THE ARRAY(0.20 value) WHEN IT SEES A month_ delinquent equal to 4

WITHOUT ARRAY PROCESSING

if month_delinquent eq 1 then balance = balance + (balance * 0.05);
else if month_delinquent eq 2 then balance = balance + (balance * 0.08);
else if month_delinquent eq 3 then balance = balance + (balance * 0.12);
else if month_delinquent eq 4 then balance = balance + (balance * 0.20);
else if month_delinquent eq 5 then balance = balance + (balance * 0.27);
else if month_delinquent eq 6 then balance = balance + (balance * 0.35);

WITH ARRAY PROCESSING

array rate {6} _temporary_ (0.05 0.08 0.12 0.20 0.27 0.35);
if month_delinquent ge 1 and month_delinquent le 6 then
balance = balance + (balance * rate{month_delinquent});

[data_null__ · Accepted solution]

rate{month_delinquent}

Array elements are referenced through their index.  The VALUE of month_delinquent provides the index in this example.  Just as if you had written rate{4}

[robertrao]

Thanks so much _null_. I get it now..

Regards