SAS Note 003515

From: SAS Technical Support (LISTSERV@VM.SAS.COM)
Date: Tue Oct 03 2000 - 11:19:42 EDT

  • Next message: SAS Technical Support: "SAS Note 003537"

    >>>>>>>> SAS Notes -- Copyright (c) 1991 - 2000 by SAS Institute Inc. <<<<<<<<

                                      ***ALERT NOTE***
    SAS Note: SN-003515
    Product: CONNECT
    Component: RLIBRARY

    Title:
    SAS/CONNECT may replace datasets even when NOREPLACE option is set

    Keywords:
    CONNECT REPLACE DATASETS FILE NOREPLACE OPTION OBSERVATIONS REMOTE
    SUBMIT SUBMITTED RLS LIBRARY LIBNAME ERROR BY VARIABLE PROPERLY SORTED
    WORK MERGE RSUBMIT

    Text:
    A remote submitted data step that encounters errors will erroneously
    replace a permanent file if there is a RLS library associated with the
    SAS/CONNECT session even if the RLS library is not being used. This
    problem will only occur if the SERVER= value and the REMOTE HOST NAME
    are the same. Following is an example that will cause this problem:

    LIBNAME TESTLIB SLIBREF=WORK SERVER=RMT1;

    RSUBMIT RMT1;
    OPTIONS NOREPLACE;

    DATA A;
      DO I=1 TO 20;
        OUTPUT;
      END;
    RUN;

    DATA B;
      DO I=1 TO 3,5,4;
        OUTPUT;
      END;
    RUN;

    DATA A;
      MERGE A B;
      BY I;
    RUN;

    ENDRSUBMIT;

    Data step errors may be written in the SAS log leading the user to
    believe that the dataset was not replaced. The example above would
    produce the following error.

    ERROR: BY variables are not properly sorted on dataset WORK.A.

    In this case, you would not expect the dataset to be replaced, however
    it does get replaced.

    As a workaround, do not assign remote libraries before executing your
    remote submit.

    Reported Releases:
    +------------REPORTED------------+ +------FIXED-----+
    System Version Level Version Level

    AIX/R 8 M1 8.2 2M0
    CMS 8 M1 8.2 2M0
    DigitUnx 8 M1 8.2 2M0
    HP800 8 M1 8.2 2M0
    IABI 8 M1 8.2 2M0
    MIPS ABI 8 M1 8.2 2M0
    MVS 8 M1 8.2 2M0
    OS/2 8 M1 8.2 2M0
    Solaris 8 M1 8.2 2M0
    VMS 8 M1 8.2 2M0
    VMS/AXP 8 M1 8.2 2M0
    WIN/NT 8 M1 8.2 2M0
    Win2000DCServer 8 M1 8.2 2M0
    Win2000Pro 8 M1 8.2 2M0
    Win2000Server 8 M1 8.2 2M0
    Win95 8 M1 8.2 2M0
    Win98 8 M1 8.2 2M0

    +-------------------------------------------------------------------------
    + NOTE: To unsubscribe you can reply to this mail with:
    + "SIGNOFF tsnews-l"
    + as the only text in the body of the message (without the double quotes).
    + If you have any questions please send them to SUPPORT@SAS.COM
    +-------------------------------------------------------------------------



    This archive was generated by hypermail 2b29 : Tue Oct 03 2000 - 11:38:41 EDT