What's New in SAS 9.3 Functions and CALL Routines

Overview

The SAS functions and CALL routines are now published as a separate document. They are no longer part of the SAS Language Reference: Dictionary.

The ability to call Web services in the DATA step is a new feature. For this feature, six new SOAPxxx functions were added. In addition, several other new functions are new, and enhancements to existing functions were added.

New Functions and CALL Routines

The following functions and CALL routines are new:

CALL RANCOMB

permutes the values of the arguments, and returns a random combination of k out of n values.

EFFRATE

returns the effective annual interest rate.

MVALID

checks the validity of a character string for use as a SAS member name.

NOMRATE

returns the nominal annual interest rate.

SAVINGS

returns the balance of periodic savings by using variable interest rates.

SOAPWEB

calls a Web service by using basic Web authentication; credentials are provided in the arguments.

SOAPWEBMETA

calls a Web service by using basic Web authentication; credentials for the authentication domain are retrieved from metadata.

SOAPWIPSERVICE

calls a SAS registered service by using WS-Security authentication; credentials are provided in the arguments.

SOAPWIPSRS

calls a SAS registered Web service by using WS-Security authentication; credentials are provided in the arguments. The Registry Service is called directly to determine how to locate the Security Token Service.

SOAPWS

calls a Web service by using WS-Security authentication; credentials are provided in the arguments.

SOAPWSMETA

calls a Web service by using WS-Security authentication; credentials for the provided authentication domain are retrieved from metadata.

SQUANTILE

returns the quantile from a distribution when you specify the right probability (SDF).

SYSEXIST

returns an indication of the existence of an operating environment variable.

TIMEVALUE

returns the equivalent of a reference amount at a base date by using variable interest rates.

Enhancements to Existing Functions

The following enhancements were made to existing functions:

  • The GENPOISSON and TWEEDIE distributions were added to the following functions:

    • CDF
    • PDF
    • SDF
    • LOGCDF
    • LOGPDF
    • LOGSDF
    • QUANTILE

  • A new argument, seasonality, was added to the INTCYCLE, INTINDEX, and INTSEAS functions. The seasonality argument enables you to have more flexibility in working with dates and time cycles.

  • A new option that computes age was added to the YRDIF function.

  • An explanation about SAS session encoding and UTF-8 encoding was added to the URLDECODE and URLENCODE functions.

  • In the GETOPTION function, you can use the following options:

    • The DEFAULTVALUE option obtains the default shipped value for a system option. The value can be used to reset a system option to its default.
    • The HEXVALUE option returns a system option value as a hexadecimal value.
    • The LOGNUMBERFORMAT option returns a system option numeric value. The punctuation that is used is dependent on the language locale.
    • The STARTUPVALUE option returns the system option value that was used to start SAS either on the command line or in a configuration file.

Documentation for Existing Functions

The documentation for the following five functions was moved from the SAS/ETS User's Guide to SAS Functions and CALL Routines: Reference:

CUMIPMT

returns the cumulative interest paid on a loan between the start and end period.

CUMPRINC

returns the cumulative principal paid on a loan between the start and end period.

IPMT

returns the interest payment for a given period for a constant payment loan or the periodic savings for a future balance.

PMT

returns the periodic payment for a constant payment loan or the periodic savings for a future balance.

PPMT

returns the principal payment for a given period for a constant payment loan or the periodic savings for a future balance.

Changes to SAS Language Reference: Dictionary

Prior to SAS 9.3, this document was part of SAS Language Reference: Dictionary. Starting with SAS 9.3, SAS Language Reference: Dictionary has been divided into seven documents:

  • SAS Data Set Options: Reference
  • SAS Formats and Informats: Reference
  • SAS Functions and CALL Routines: Reference
  • SAS Statements: Reference
  • SAS System Options: Reference
  • SAS Component Objects: Reference (contains the documentation for the Hash Object and the Java Object)
  • Base SAS Utilities: Reference (contains the documentation for the SAS DATA step debugger and the SAS Utility macro %DS2CSV)
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset