>>>>>>>> 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