SPDO Procedure

SET USER Statement

Connects to a non-locking proxy for the specified user ID.

Requirement: You must have special privilege and specify ACLSPECIAL=YES in the LIBNAME statement to use this statement.
Interaction: Used in conjunction with the LIST USERS, SHOWLIBNAME, SET MODE OPER, and OPER statements to issue proxy commands.
See: SPD Server proxies are described in detail in Managing SPDSBASE Processes.
Syntax
Arguments
Details

Syntax

SET USER user-ID [port-number];

Arguments

user-ID

specifies a user ID that is returned by the LIST USERS statement. The user ID is required.

port-number

specifies a proxy operator port number. The port number is optional. The proxy operator port number enables you to distinguish between two proxies that share the same user ID.

Details

The SET USER statement is used after the LIST USERS statement in preparation for executing a proxy command. The LIST USERS statement identifies the non-locking users that are active in the connected domain. The SET USER statement enables you to connect to one of the listed user proxies.
After you have established a user connection with SET USER, you can issue the SHOWLIBNAME statement to list the active librefs for the user and to get information about tables that are accessible or open in specific librefs. You can also use the SET MODE OPER and OPER statements to cancel, disconnect from, or interrupt the user proxy.
See Using PROXY Statements to Get Information about Non-Locking SPD Server Users to see how this statement is used with other statements to issue a proxy command.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017