Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

The TSO global SAS statement issues a TSO command or invokes a CLIST
or a REXX exec during a SAS session.

In Version 6, you can issue a TSO command to allocate a SAS data
library, then, at the command line of the Program Editor window, type
'ACCESS libref' to bring up the ACCESS window for that library.

In Version 8, if you issue the ACCESS window command, you get the
Explorer window and the following message:

  ERROR: Library 'libref' does not exist.

To circumvent this problem, first reference the library with another
SAS task (e.g. PROC PRINT, CONTENTS, FSEDIT, etc.).  A library that is
allocated externally (i.e. using a JCL DD statement or a TSO ALLOCATE
command) is not listed by the LIBNAME window until after you have used
it in your SAS session.

The following is documented in "What's New in Version 8", p. 93:

  Under Version 7 and later of SAS/ACCESS software, the ACCESS
  and DBLOAD procedures continue to be supported for the DBMSs
  and operating environments on which they were supported in
  Version 6. You can still create SAS/ACCESS descriptor files to
  access or load DBMS data. There are some changes and
  enhancements to the ways in which these features work:

    The SAS Explorer window replaces the ACCESS window and its
    functionality.  The ACCESS procedure has been enhanced by the
    UPDATE statement, which enables you to edit and update access
    descriptors and view descriptors in SAS code.  The DBLOAD
    procedure has been enhanced by the APPEND statement, which
    enables you to append data to an existing DBMS table.

    Access descriptor, view descriptor, and SAS variable names,
    when used in the ACCESS and DBLOAD procedures, are still
    limited to 8 characters.  The interactive windowing interface
    for the ACCESS procedure is not supported; you can no longer
    create and edit access descriptors and view descriptors by
    using the Access Descriptor and View Descriptor definition
    windows. The interactive windowing interface for the DBLOAD
    procedure is also no longer supported.

    Note: It is recommended that you use the new SAS/ACCESS
    LIBNAME statement or the SQL procedure pass-through facility
    to access your DBMS data more directly and to take full
    advantage of Version 7 and later enhancements. See SAS/ACCESS
    LIBNAME Statement for more information about the new LIBNAME
    statement.

Operating System and Release Information