| Moving and Accessing SAS Files across Operating Environments |
You decide whether a view (either PROC SQL, DATA step, or SAS/ACCESS)
is interpreted in the client session or the server session. Factors to consider
are:
- Location of data
- The view must be interpreted at the location
that has access to the data.
- Performance
- If the data is equally accessible to the
client and the server, consider the amount of data that must be sifted in
order to produce the view. If a view selects most of the data, interpreting
on the client may be preferable. If a view selects a small amount of data,
interpreting on the server may be preferable.
- Version of SAS that runs in the client session and the
server session
- If the server and client run different versions
of SAS, and both have equal access to the SAS data, consider interpreting
the view at the location that requires no data conversion. For example, if
a Version 6 client accesses a Version 8 SAS data set by means of a Version
8 server, interpreting the view at the server is preferable because the data
set does not have to be converted at the server. However, the view would have
to be converted before it could be interpreted at the client.
You use the RMTVIEW= option in the LIBNAME statement to specify
the location for the view interpretation. RMTVIEW= takes the values YES (interpretation
is done at server) or NO (interpretation is done at client). You specify the
RMTVIEW= option in the LIBNAME statement in either the client session or the
server session. Here is an example:
libname grades 'SAS-data-library' server=shr1 rmtview=yes;
In this example, the view is interpreted in the server
session.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
