Hi All,
I'm hoping someone can help me with a relatively simple problem. Take the
following dataset:
ID Diabetes ESRD HIV Contact
1 0 0 NA 0
2 1 0 NA 0
3 NA 1 0 0
4 0 NA 0 1
5 1 1 1 0
I want to generate a column called TSTcutoff based on the values in the row.
TSTcutoff would be the lower of 15 (if Diabetes=ESRD=HIV=Contact=0), 10 (if
Diabetes or ESRD=1 AND HIV=Contact=0), or 5 (if HIV OR Contact=1). I was
thinking this could be done with a series of IFELSE statements, but the NA
values make this more challenging. I want to ignore NA values when calculating
TSTcutoff. So the final dataset should look like this:
ID Diabetes ESRD HIV Contact TSTcutoff
1 0 0 NA 0 15
2 1 0 NA 0 10
3 NA 1 0 0 10
4 0 NA 0 1 5
5 1 1 1 0 5
Thanks for any suggestions.
Jason Stout, MD, MHS
Box 102359-DUMC
Durham, NC 27710
FAX 919-681-7494
[[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.
