SAS Note SN-001851

From: tsdlist@UNX.SAS.COM
Date: Tue Mar 21 2000 - 08:04:31 EST

  • Next message: tsdlist@UNX.SAS.COM: "SAS Note SN-001844"

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

    SAS Note: 001851 ***Alert Note*** Product: FSP

    Title:
    Deleting a range of observations within a WHERE subset may delete
    observations outside of the range

    Keywords:
    DELETE MEMBER LOCK TABLE WHERE ROW OBSERVATIONS RANGE OUTSIDE UPDATE
    EDIT DEL

    In FSVIEW, if you delete a range of observations within a WHERE subset,
    observations outside the range may also be deleted.

    For example, if you display the data set SASUSER.CLASS in edit mode with
    member-level locking, create the WHERE subset for those observations in
    which AGE LE 13, and issue the command

       delete 1-4

    observations 1, 2, 4, and 5 will be deleted even though observation 5 is
    outside of the range of observations and should not be deleted.

    To circumvent the problem, either delete observations one at a time such
    as with the following DELETE command,

       delete 4

    or choose ranges for the delete command that would not result in this
    problem. For example, the following DELETE command,

       delete 1-2

    would work in the above example since the WHERE subset includes
    observations 1 and 2.

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

    AIX/R 7 P1
    AIX/R 8 M0
    CMS 7 P1
    CMS 8 M0
    DigitUnx 7 P1
    DigitUnx 8 M0
    HP800 7 P1
    HP800 8 M0
    IABI 8 M0
    MIPS ABI 8 M0
    MVS 7 P1
    MVS 8 M0
    OS/2 7 P1
    OS/2 8 M0
    Solaris 7 P1
    Solaris 8 M0
    VMS 7 P1
    VMS 8 M0
    VMS/AXP 7 P1
    VMS/AXP 8 M0
    WIN/NT 7 P1
    WIN/NT 8 M0
    Win95 7 P1
    Win95 8 M0
    Win98 7 P1
    Win98 8 M0



    This archive was generated by hypermail 2b29 : Tue Mar 21 2000 - 08:06:46 EST