Chapter Contents |
Previous |
Next |
SAS/SHARE User's Guide |
LIBNAME libref < 'SAS-data-library'> SERVER=serverid <ACCESS=READONLY> <OUTREP= format> <USER=userid> <PASSWORD=password > <SAPW=server-access-password> <SLIBREF=server-libref> <engine-options>; |
In a SAS program, after you specify a library name in the LIBNAME statement, you refer to the libref in the following form:
data; set libref.SAS-data-set; run;
If you omit the physical name of the data library in your LIBNAME statement and you do not specify the engine/host SLIBREF= option, the libref that you specify is presumed to be the server libref for an existing server library. Information about the SLIBREF= option appears later in this chapter.
The physical name that you specify is used by the server session and not the client session. If you omit the physical name, you can access the library by the libref argument or by the SLIBREF= engine/host option. Information about the SLIBREF= option appears later in this chapter.
For examples of host-specific library-naming conventions, see Specifying a Host-Specific SAS Data Library.
Server naming is also constrained by the host type and the access method that you specify for communication between a server and a client session. Consult the server administrator for the value of serverid.
For complete access method and server-naming details, see Communications Access Methods for SAS/CONNECT and SAS/SHARE Software.
For more information about this option, see the LIBNAME statement in SAS Language Reference: Dictionary.
Note: Specifying the SERVER= option
is not required when using the ACCESS= option.
A data set is always converted to the native server format before writing to disk or reading for a client. Therefore, attempting to convert a data set on the server to a client's format could cause extra translations and slower performance. The data could also suffer a loss of precision because of the extra translations. For these reasons, the use of OUTREP= is not generally recommended with SAS/SHARE.
The valid format values for OUTREP in Version 7 and later releases are:
¹ Support for these values was introduced in Version 8.
Nicknames for USER are USERNAME, USERID, and UID.
Valid values that can be assigned to USER are:
Nicknames for PASSWORD are PASSWD, PASS, PWD, and PW.
Valid values for PASSWORD are:
Although this option is specified in the LIBNAME statement, it has nothing to do with the SAS data library being accessed. This option is used to establish communication with the server through which the library can be accessed.
Note: You must also specify the SERVER= option when
using any of the engine options.
SAS data views are accessed through an engine just as other SAS data sets are. Where a data view is interpreted determines where the view engine is loaded and used. DATA step views use the SASDSV engine, and PROC SQL views use the SQLVIEW engine. SAS Institute creates a product-specific engine for each SAS/ACCESS interface product, which the SAS/ACCESS views use for that interface.
The default value of this option (YES) causes views to be interpreted in the server's SAS execution. When views are interpreted in the server SAS session, the server may require large amounts of processor time and storage, but the amount of data transferred to the client SAS sessions may be reduced. Conversely, disallowing view processing by the server SAS session might increase the amount of data transferred between the server and client SAS sessions but prevents the server from using more than minimal processing time.
If you set the value of this option to NO, SAS data views are interpreted in the client SAS session.
For details about view interpretation, see Interpreting SAS Data Views.
The LIBNAME statement also takes the arguments LIST and CLEAR. See SAS Language Reference: Dictionary for more information.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.