SAS/CONNECT User's Guide

Accessing SAS Views

As with data sets, there are limitations and restrictions when accessing data views in a cross-version environment. Data views that are affected in this environment include:

DATA step views
PROC SQL views
SAS/ACCESS views

Access to the data views and SAS programs is based on the SAS/CONNECT service that is used to access it and whether the data employs any new Version 7 or Version 8 features. There are three SAS/CONNECT services that allow you to access data views in a cross-version environment:

Remote Library Services (RLS)
Data Transfer Services (DTS)
Compute Services (CS)

Note: SAS/CONNECT uses the data that the view references, not the view itself. [cautionend]

Version 6 Local Host Accessing a Version 7 or Version 8 Remote Host

This section summarizes the limitations of a Version 6 local host that accesses data views on a Version 7 or Version 8 remote host in a cross-version environment.

Using remote library services, a Version 6 local host can read, write, and update a Version 6 DATA step view or a PROC SQL view if the view is processed on the client. The view can be processed on the client by specifying RMTVIEW=NO in the LIBNAME statement. The local host has read-only access to a Version 7 or Version 8 DATA step view or a PROC SQL view if the view is processed on the server (RMTVIEW=YES).

For SAS/ACCESS views, a Version 6 local host has complete read, write, and update access using remote library services for both Version 6 and Version 7 or Version 8 SAS/ACCESS views.

Using data transfer services, a Version 6 local host can upload and download PROC SQL views by using the DATA= option to specify the data file associated with the view that is being transferred, or by using the INLIB= option to specify the library that you want to transfer.

Using compute services, a Version 6 local host can remote submit a SAS program to a Version 7 or Version 8 remote host that references SAS data views.

Version 7 or Version 8 Local Host Accessing a Version 6 Remote Host

This section summarizes the limitations of a Version 7 or Version 8 local host that accesses views on a Version 6 remote host in a cross-version environment.

Using remote library services, a Version 7 or Version 8 local host can read a Version 6 DATA step view or a Version 6 PROC SQL view provided the view is processed on the server. The view can be processed on the server by specifying RMTVIEW=YES in the LIBNAME statement. However, the Version 7 or Version 8 local host can read, write, and update a Version 6 SAS/ACCESS view on a Version 6 remote host.

Using data transfer services, a Version 7 or Version 8 local host can upload data that is associated with a view to a Version 6 remote host and will follow the truncation rules described earlier.

Using compute services, a Version 7 or Version 8 local host can remote submit a SAS program to a Version 6 remote host that references SAS data views. However, the data referenced in the remote submit must not implement new Version 7 or Version 8 features.

Chapter Contents
Previous
Next
Top of Page