s-news
[Top] [All Lists]

Subsetting a dataframe in SPlus 8

To: s-news@wubios.wustl.edu
Subject: Subsetting a dataframe in SPlus 8
From: Madeline Bauer <mbauer@usc.edu>
Date: Tue, 16 Jun 2009 16:58:50 -0700
attach (tmp.keep )
I'm using SPlus 8.1.1 in Windows XP Pro and I'd like to remove 5 records from a dataframe. The following code works in SPlus 2000, but in SPlus 8, the final line produces a dataframe with all NAs.  Obviously there is something new and wonderful in SPlus 8 that I need to know!

Sample code:

attach (tmp.keep )

Subset <- I( (Log.No == 5071 & Rep.ICCC2008 == 1) |
                 (Log.No == 5087 & Rep.ICCC2008 == 2) |
                 (Log.No == 5055 & Rep.ICCC2008 == 1) |
                 (Log.No == 5102 & Rep.ICCC2008 == 1) |
                 (Log.No == 5032 & Rep.ICCC2008 == 2) )

# this works in both SPlus 8 and 2000.
table (Log.No [Subset], Rep.ICCC2008 [Subset])

# this works in SPlus 2000, but not in SPlus 8:
as.data.frame ( tmp.keep [!Subset,])

All suggestions welcome!
Thanks in advance,
Madeline

===
Madeline Bauer, Ph.D.        University of Southern California
Keck School of Medicine (Infectious Diseases)
IRD Room 620 (MC9520), 2020 Zonal Ave, Los Angeles 90033
(323) 226-2775 [Voice] (FAX by appointment ;-)
mbauer@usc.edu  [Fastest communication method]


<Prev in Thread] Current Thread [Next in Thread>