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

• PACKAGE_BEGIN
• PACKAGE_PUBLISH