INSERT_MDDB

Inserts a SAS multidimensional database into a package

Syntax

Details

Example

Syntax

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

Required Arguments

packageID: identifies the package.

Type:Numeric, Input

libname: names the library that contains the MDDB.

Type:Character, Input

memname: names the MDDB.

Type:Character, Input

desc: describes the MDDB.

Type:Character, Input

nameValue

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.

Type:Character, Input

rc: receives a return code.

Type:Numeric, Output

Details

An MDDB is a multidimensional database (not a data set) offered by SAS. It is a specialized storage facility where data can 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.

Example: Using INSERT_MDDB

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