BookmarkSubscribeRSS Feed
AnuragRankja
Fluorite | Level 6
If i want to calculate interest rate 6 annually for amount 5000 then i will write 5000*1.06 but if i want to calculate same thing with interest rate 5.75?
2 REPLIES 2
sbxkoenk
SAS Super FREQ

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

 

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 821 views
  • 2 likes
  • 3 in conversation