Help using Base SAS procedures

Arrray concepts

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,040
Accepted Solution

Arrray concepts

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});


Accepted Solutions
Solution
‎09-28-2012 11:37 AM
Respected Advisor
Posts: 3,777

Re: Arrray concepts

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}

View solution in original post


All Replies
Solution
‎09-28-2012 11:37 AM
Respected Advisor
Posts: 3,777

Re: Arrray concepts

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}

Super Contributor
Posts: 1,040

Re: Arrray concepts

Thanks so much _null_. I get it now..

Regards

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 158 views
  • 0 likes
  • 2 in conversation