The REPEAT() function is for making a long string by repeating shorter strings N+1 times.
Example:
87 data test;
88 s='AB ';
89 l=repeat(s,2);
90 put (s l) (=:$quote./);
91 run;
s="AB"
l="AB AB AB"
That is not going to be very useful for working with NUMBERS.
Now it might be useful when used in macro code to generate CODE. But then it needs to generate the COMMAs also.
With actual data it would probably be better to put the values into an ARRAY and then pass the ARRAY of values to the IRR() function.
It is not clear what data you have from the description. Do you have one observation per payment per load ID? If so then perhaps something like this:
data want;
do i=1 by 1 until(last.id);
set have end=eof;
by id;
pmts[i] = payment_amount ;
end;
irr = irr(12,-financed_amount,of pmts[*]);
drop payment_amount i pmts: ;
run;
So for each ID you read in ALL of the PAYMENT_AMOUNT values and put them into the ARRAY. (Just make the size of the array larger than the maximum number of payments per loan.) The DO loop will collapse all of the observations per loan into one observation so that when it ends you have all of the payment amounts in the array. Then just pass the whole array to IRR() and it will ignore the missing values are the end of the array.
Since you said they are monthly payments use 12 as the frequency value to pass to IRR().
Now if instead you just have one observation per loan ID then instead use a different DO loop.
data want;
set have end=eof;
by id;
array pmts[360] ;
do i=1 to TERM ;
pmts[i] = payment_amount ;
end;
irr = irr(12,-financed_amount,of pmts[*]);
drop i pmts: ;
run;
Again just make the array size larger than the maximum value or the TERM variable across all of the loans in the dataset.
