Hi all, I have been having some trouble to use this following function; FINANCE('ACCRINT', issue, first-interest, settlement, rate, par-value, frequency, [basis]); I used this syntax from here: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=ds2ref&docsetTarget=n0xns2d1axa92rn1es5q30h8qr7o.htm&locale=en My code is as follows: data want; set original; format i_date MMDDYY10.; informat i_date YYMMDD8.; format fid_date MMDDYY10.; informat fid_date YYMMDD8.; format st_date MMDDYY10.; informat st_dateYYMMDD8.; AI= finance('accrint', i_date, fid_date, st_date, coupon/100, PRINCIPAL_AMT, INTEREST_FREQUENCY, 1); run; In my original file, the variables format /informat are as follows: INTEREST_FREQUENCY, PRINCIPAL_AMT, coupon, i_date, fid_date and st_date: length: 8 format: best12. informat: best32. In the output, "want" file is created but with missing values for the variable, "AI". In the log, this kind of message is generated: NOTE: Argument 4 to function FINANCE('accrint',20041116,20090401,16715,0.1025,1000,2,1) at line 830 column 6 is invalid. Variables description ..................... NOTE: Argument 4 to function FINANCE('accrint',20041116,20090401,16719,0.1025,1000,2,1) at line 830 column 6 is invalid. Variables description ..................... REPEATS AGAIN............ ERROR: There was a problem with the format so BEST. was used ERROR: There was a problem with the format so BEST. was used ................................................................ Please, help me with what changes I should make in my code. It would be a great help if you can correct my original code. Thanks in Advance!!!!!
... View more
