SAS has also FINANCIAL FUNCTIONS for this type of calculations.
Use for example the FINANCE ACCRINT Function: Computes the accrued interest for a security that pays periodic interest.
data _null_;
issue =mdy(8, 28, 2021);
firstinterest=mdy(8, 28, 2022);
settlement =mdy(8, 28, 2022);
rate =0.0575;
par =5000;
frequency =1;
basis =1;
r=finance('accrint', issue, firstinterest, settlement, rate, par, frequency, basis);
put r=;
my_r = 5000 * 1.0575;
put my_r=;
run;
/* end of program */
Cheers,
Koen
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.