Beginning in SAS^® 9.2, support for the CUMIPMT, CUMPRINC, IPMT, PMT, and PPMT financial functions was moved from SAS/ETS^® to Base SAS^®. However, if any of these functions are run under SAS^® Release 9.2 or higher on a system where SAS/ETS software is not installed, then the following error message is returned:

where xxxx is the name of one of the aforementioned functions.

To circumvent the problem, use the FINANCE function and specify the name of the desired function as the initial "string-identifier" argument. Details on the FINANCE function are available in the SAS Functions and Call Routines: Reference.

The following example illustrates comparable specifications of the CUMPRINC and FINANCE functions to obtain the cumulative principle paid on a loan between two periods. The FINANCE function returns a value that is equal in magnitude but opposite in sign of the result returned by the CUMPRINC function.

Similar syntax can be used with the FINANCE function to obtain comparable results to the CUMIPMT, IPMT, PMT, and PPMT functions.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	Base SAS	Solaris for x64	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		z/OS	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.21		9.2 TS2M0
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	9.21		9.2 TS2M0
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	9.21		9.2 TS2M0
		Microsoft Windows XP 64-bit Edition	9.21		9.2 TS2M0
		Microsoft® Windows® for x64	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		Microsoft Windows Server 2003 Datacenter Edition	9.21		9.2 TS2M0
		Microsoft Windows Server 2003 Enterprise Edition	9.21		9.2 TS2M0
		Microsoft Windows Server 2003 Standard Edition	9.21		9.2 TS2M0
		Microsoft Windows Server 2003 for x64	9.21		9.2 TS2M0
		Microsoft Windows Server 2008 R2	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		Microsoft Windows Server 2008 for x64	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		Microsoft Windows XP Professional	9.21		9.2 TS2M0
		Windows Vista	9.21		9.2 TS2M0
		Windows Vista for x64	9.21		9.2 TS2M0
		64-bit Enabled AIX	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		64-bit Enabled HP-UX	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		64-bit Enabled Solaris	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		OpenVMS on HP Integrity	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		Linux	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		Linux for x64	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3
		HP-UX IPF	9.21	9.4_M3	9.2 TS2M0	9.4 TS1M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

If SAS/ETS software is not installed, the functions CUMIPMT, CUMPRINC, IPMT, PMT and PPMT generate the following error: ERROR 68-185: The function xxxx is unknown or cannot be accessed.

Type:	Problem Note
Priority:	medium
Topic:	Analytics ==> Econometrics Analytics ==> Financial Analysis Analytics ==> Financial Data Access and Manipulation Analytics ==> Time Series Analysis SAS Reference ==> Functions ==> Financial

Date Modified:	2017-08-08 15:57:45
Date Created:	2014-12-12 13:33:39