RETRIEVE_SQLVIEW

Retrieves a PROC SQL view from a package
Syntax
Details
Example

Syntax

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

Required Arguments

entryId
identifies the PROC SQL view entry.
Type:Numeric, Input
libname
specifies the SAS library that will contain the retrieved PROC SQL view.
Type:Character, Input
memname
specifies the member name of the PROC SQL view.
Type:Character, Input
rc
receives a return code.
Type:Numeric, Output

Details

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

Example: Using RETRIEVE_SQLVIEW

The following example retrieves the PROC SQL view WORK.OUTDATA from the package. 
lib = 'work';
mem = 'outdata';
CALL RETRIEVE_SQLVIEW(entryId, lib, mem, rc);
Copyright © SAS Institute Inc. All rights reserved.