Chapter Contents


Moving and Accessing SAS Files across Operating Environments

Deciding Where Views Should Be Interpreted

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.

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.

Chapter Contents



Top of Page

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