RETRIEVE_SQLVIEW

Retrieves a PROC SQL view from a package.

Syntax

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

entryId

Numeric, input.
Identifies the PROC SQL view entry.

libname

Character, input.
Specifies the SAS library that will contain the retrieved PROC SQL view.

memname

Character, input.
Specifies the member name of the PROC SQL view.

rc

Numeric, output.
Receives a return code.

Details

If the memname parameter is blank, the RETRIEVE_SQLVIEW CALL routine creates the PROC SQL view using the original member name as it was defined at publish time.

The following example retrieves the PROC SQL view WORK.OUTDATA from the package.

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