Skip to content

Rearanging Data

6 messages · kevin123, Tal Galili, David Winsemius +2 more

#
Hi,

This is only a small portion of the Data i am working on
I want to make a subset of this data set( Data Set=Claims) 

  MemberID   ProviderID Vendor   PCP    Year  Specialty           
1 42286978    8013252 172193 37796   Y1    Surgery              
2 97903248    3316066 726296  5300    Y3    Internal            
3  2759427    2997752 140343 91972    Y1   Internal             
4 73570559    7053364 240043 70119   Y3   Laboratory     

I want to put all the rows containing Y1 into a subset. I tried this but it
does not work

sub <- subset(Claims, Year=Y1)

I would greatly appreciate any help

Kevin

--
View this message in context: http://r.789695.n4.nabble.com/Rearanging-Data-tp4371717p4371717.html
Sent from the R help mailing list archive at Nabble.com.
#
On Feb 8, 2012, at 9:48 PM, kevin123 wrote:

            
You (as well , apparently, as Tal) don't seem to have learned that "="  
is an assignment function and the needed Comparison operator is "=="

?Comparison

Try instead:

sub <- subset(Claims, Year=="Y1")
#
Try

   sub <- subset(Claims, Year==Y1)

In R, the equality test is performed by two
equal signs, not one.

 					- Phil Spector
 					 Statistical Computing Facility
 					 Department of Statistics
 					 UC Berkeley
 					 spector at stat.berkeley.edu
On Wed, 8 Feb 2012, kevin123 wrote: