INSERT_MDDB

Arguments

packageID

identifies the package.

Type:	Numeric
Direction:	Input

libname

names the library that contains the MDDB.

Type:	Character
Direction:	Input

memname

names the MDDB.

Type:	Character
Direction:	Input

desc

describes the MDDB.

Type:	Character
Direction:	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. See filtering.

Type:	Character
Direction:	Input

rc

receives a return code.

Type:	Numeric
Direction:	Output

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.

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

Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.