Hello, Not sure whether I understand it well.
If you want your output to include only Patient A &B, this should work: dat1<-read.table(text=" Patient Cycle Variable1 Variable2 A 1 4 5 A 2 3 3 A 3 4 NA B 1 6 6 B 2 NA 6 C 1 6 5 C 3 2 2 ",sep="",header=TRUE) subset(dat1,!dat1$Patient=="C") Patient Cycle Variable1 Variable2 1 A 1 4 5 2 A 2 3 3 3 A 3 4 NA 4 B 1 6 6 5 B 2 NA 6 But, if you want patient rows having NA's in either variable1 or 2, subset(dat1,is.na(dat1$Variable1)|is.na(dat1$Variable2)) #Patient Cycle Variable1 Variable2 #3 A 3 4 NA #5 B 2 NA 6 This will help to locate the patients which have missing values. Hope it helps. A.K. ----- Original Message ----- From: Lib Gray <[email protected]> To: [email protected] Cc: Sent: Wednesday, July 18, 2012 3:30 PM Subject: [R] Subsetting problem data Hello, I need to subset my data to only look at the parts that have "holes" in it. I already have a formula to get rid of inconsistencies, but now I need to look only at the problem data to reconfigure it. In my data set where there are multiple "cycles" per "patient," and I want to highlight the patients who have a variable was not measured every cycle. Here's a similar example of the data: Patient, Cycle, Variable1, Variable 2 A, 1, 4, 5 A, 2, 3, 3 A, 3, 4, NA B, 1, 6, 6 B, 2, NA, 6 C, 1, 6, 5 C, 3, 2, 2 So in this case, I would want Patient A and Patient B, but not Patient C. Thanks! [[alternative HTML version deleted]] ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
