Contents Publish Package Interface Previous Next

INSERT_MDDB

Inserts a SAS multidimensional database into a package.

Syntax

CALL INSERT_MDDB(packageId, libname, memname, desc, nameValue, rc);

packageID
Numeric, input.
Identifies the package.

libname
Character, input.
Names the library that contains the MDDB.

memname
Character, input.
Names the MDDB.

desc
Character, input.
Describes the MDDB.

nameValue
Character, input.
Identifies a list of one or more space-separated name/value pairs, each in one of the following forms:

  • name
  • name=value
  • name="value"
  • name="single value with spaces"
  • name=(value)
  • name=("value")
  • name=(value1, "value 2",... valueN)

Name/value pairs are site-specific; they are used for the purpose of filtering.

rc
Numeric, output.
Receives a return code.

Details

An MDDB is a multidimensional database (not a data set) offered by SAS. It is a specialized storage facility where data may be pulled from a data warehouse or other data sources and stored in a matrix-like format for fast and easy access by tools such as multidimensional data viewers.

The following example inserts the MDDB FINANCE.PAYROLL into the package returned in packageId.

libname  = 'finance';
memname = 'payroll';
desc = 'Monthly payroll data.';
nameValue='';
CALL INSERT_MDDB(packageId, libname, memname, desc, nameValue, rc);

See Also

Contents Publish Package Interface Previous Next