Calculating Present Value (PV) or PV Function in SAS

[Timbim]

Hi Team,

I am working on a mini project and as part of that I need to determine the Present Value.

Can someone please help me how to compute Present Value? I could not find a PV function in SAS?

I was doing something like the following but SAS could not recognise the PV function I inserted.

PV((Current_DRInterestRate/Current_LoanPaymentFrequency),RemainingPeriods,CALCULATED MonthlyPmtPostMod)

Kind regards,

Mags

[PeterClemmensen]

Perhaps the Finance PV Function can help you 🙂

[ballardw]

The FINANCE function will do something like 53 different financial calculation from ACCRINT, accrued interest, to YIELDMAT, annual yield of a security that pays interest at maturity.

[Timbim]

Hi Ballardw,

I am getting an error with the finance function. Below is my logic

Data loans06;

set loans05;

r= finance('pv',Current_DRInterestRate/Current_LoanPaymentFrequency,RemainingPeriods,MonthlyPmtPostMod);

run;

Below is the error message

SYMBOLGEN: Macro variable ACCESSIBLE resolves to ACCESSIBLE

14 Data loans06;

15 set loans05;

16 r= finance('pv',Current_DRInterestRate/Current_LoanPaymentFrequency,RemainingPeriods,MonthlyPmtPostMod);

_______

68

ERROR 68-185: The function FINANCE is unknown, or cannot be accessed.

17 run;

[ballardw]

---

@Timbim wrote:

Hi Ballardw,

I am getting an error with the finance function. Below is my logic

Data loans06;

set loans05;

r= finance('pv',Current_DRInterestRate/Current_LoanPaymentFrequency,RemainingPeriods,MonthlyPmtPostMod);

run;

Below is the error message

SYMBOLGEN: Macro variable ACCESSIBLE resolves to ACCESSIBLE

14 Data loans06;

15 set loans05;

16 r= finance('pv',Current_DRInterestRate/Current_LoanPaymentFrequency,RemainingPeriods,MonthlyPmtPostMod);

_______

68

ERROR 68-185: The function FINANCE is unknown, or cannot be accessed.

17 run;

---

When we have a MACRO message, such as our SYMBOLGEN result the issue can be related to a number of other macro generated statements from previous lines of code. And without the definition of the macro or data sets it is hard to trace.

If you extract that code from the middle of your macro and run alone what does the log show?

Since the FINANCE function is a BASE SAS function about the only reason I would expect to see such an error without macro code is either you are running a version of SAS that predates the FINANCE function or you are running this code in some module of SAS that can't access the function for some reason.