INSERT_SQLVIEW

Arguments

packageID

identifies the package.

Type:	Numeric
Direction:	Input

libname

names the library that contains the PROC SQL view.

Type:	Character
Direction:	Input

memname

names the PROC SQL view.

Type:	Character
Direction:	Input

desc

describes the PROC SQL view.

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

This example inserts the PROC SQL view FINANCE.PAYROLL into the package that is returned in packageId .

libname = 'finance';
memname = 'payroll';
desc = 'Monthly payroll data.';
nameValue='';
CALL INSERT_SQLVIEW(packageId, libname,
   memname, desc, nameValue, rc);

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