RETRIEVE_MDDB

Retrieves an MDDB entry from a package.

Syntax

CALL RETRIEVE_MDDB(entryId, libname, memname, rc);

entryId

Numeric, input.
Identifies the MDDB entry.

libname

Character, input.
Specifies the SAS library that will contain the retrieved MDDB.

memname

Character, input.
Specifies the name of the retrieved MDDB.

rc

Numeric, output.
Receives a return code.

Details

An MDDB is a multidimensional database (not a data set) offered by SAS. An MDDB is a specialized storage facility that can be created by tools such as multidimensional data viewers, which populate the MDDB with data retrieved from sources such as a data warehouse. The matrix format of MDDBs allows the viewer to access data quickly and easily.

If the memname parameter is blank, the RETRIEVE_MDDB CALL routine creates the MDDB using the original member name as it was defined at publish time.

The following example retrieves an MDDB entry WORK.OUTDATA from the package.

lib = 'work';
mem = 'outdata';
CALL RETRIEVE_MDDB(entryId, lib, mem, rc);