There are limitations and restrictions when accessing
SAS views in a cross-version environment. Here are the types of SAS
views:
DATA step
PROC SQL
SAS/ACCESS
Note: SAS/CONNECT uses the data
that the SAS view references, but not the SAS view itself.
SAS 6 Client Accessing a SAS 8 (or Later) Server
This table summarizes
the limitations of a SAS 6 client that accesses SAS views on a SAS
8 (or later) server in a cross-version environment.
Limitations for Accessing SAS Views on SAS 8 (or Later) from
SAS 6
SAS/CONNECT Service
SAS 6 Client Connecting
to SAS 9 Server
SAS 6 Client Connecting
to SAS 8 Server
Remote Library Services
No access is permitted
between a SAS 6 client and a SAS 9 server.
For SAS 8 DATA step
views, the SAS 6 client has only read access.
For SAS 8 SAS/ACCESS
views, the SAS 6 client has read, write, and update access.
Data Transfer Services
For PROC SQL views,
a SAS 6 client can upload a PROC SQL view between a SAS 9 or SAS 8
server by using the INLIB= option to specify the library that is associated
with the view to transfer. The DATA= option can be used, but a data
set will be created.
Compute Services
For SAS views, a Version
6 client can remote submit a SAS program that references SAS views
to a SAS 9 or SAS 8 server. The SAS views that are referenced in remote
submit blocks can be SAS 9, SAS 8, or SAS 6 data files.
SAS 8 (or Later) Client Accessing a SAS 6 Server
This table summarizes
the limitations of a SAS 8 (or later) client that accesses SAS views
on a SAS 6 server in a cross-version environment.
Limitations for Accessing SAS Views on SAS 6 from SAS 8 (or
Later)
SAS/CONNECT Service
SAS 9 Client Connecting
to a SAS 6 Server
SAS 8 Client Connecting
to a SAS 6 Server
Remote Library Services
No access is permitted
between a SAS 9 client and a SAS 6 server.
For SAS 6 DATA step
views and SAS 6 PROC SQL views, if the view is processed at the server
(RMTVIEW=YES in the LIBNAME statement), the SAS 8 client has read
access only for DATA step views.
Data Transfer Services
A SAS 9 or SAS 8 client
can upload data that is associated with a SAS view to a SAS 6 server.
Names of files that
are transferred to a SAS 6 server are truncated, following truncation
rules.
Compute Services
A SAS 9 or SAS 8 client
can remotely submit a SAS program that references SAS 6 views to a
SAS 6 server.