[R] ifelse() and missing values in test conditions

2010-07-20 Thread Hosack, Michael
R experts, I have been unable to get the following ifelse statement to work as desired when applied to my data frame. Example: DF$ANYEF - with(DF,ifelse(PSOUGHT1=='ANY'|PSOUGHT2=='ANY'|PSOUGHT3=='ANY',PEFF,0)) # this statement will be replicated 16 times for 16 unique _EF variables

Re: [R] ifelse() and missing values in test conditions

2010-07-20 Thread Joshua Wiley
Hi Mike, Probably the simplest way from what you have done would be to just set any NA values in the column to 0: DF$ANYEF[is.na(DF$ANYEF)] - 0 Alternately, you can try this. It should work, but it is far from elegant. DF$ANYEF - with(DF, ifelse( rowSums(cbind(PSOUGHT1, PSOUGHT2, PSOUGHT3)

Re: [R] ifelse() and missing values in test conditions

2010-07-20 Thread Hosack, Michael
...@gmail.com] Sent: Tuesday, July 20, 2010 1:41 PM To: Hosack, Michael Cc: r-help@r-project.org Subject: Re: [R] ifelse() and missing values in test conditions Hi Mike, Probably the simplest way from what you have done would be to just set any NA values in the column to 0: DF$ANYEF[is.na(DF$ANYEF