topic Re: Calculating Present Value (PV) or PV Function in SAS in SAS Programming

Calculating Present Value (PV) or PV Function in SAS

Timbim — Fri, 21 Jun 2019 05:46:22 GMT

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

Re: Calculating Present Value (PV) or PV Function in SAS

PeterClemmensen — Fri, 21 Jun 2019 05:53:00 GMT

Perhaps the Finance PV Function can help you 🙂

Re: Calculating Present Value (PV) or PV Function in SAS

ballardw — Fri, 21 Jun 2019 15:02:19 GMT

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.

Re: Calculating Present Value (PV) or PV Function in SAS

Timbim — Mon, 24 Jun 2019 03:22:01 GMT

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);

_______

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

17 run;

Re: Calculating Present Value (PV) or PV Function in SAS

ballardw — Mon, 24 Jun 2019 15:57:39 GMT

@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.