I am having difficulty finding a solution to devising an R code to do the following:
I have 5 numerical variables and I would like to create a new variable that is the sum of those 5 variables. However, there are many NA values throughout these 5 variables and everytime I run the following code new_variable=var1+var2+var3+var4+var5 I get NA as the sum whenever one of those 5 variables are NA. I cannot figure out a way to have new_variable represent the sum for only those values that are not NA. As an example, if var1=3 var2=3 var3=NA var4=NA var5=2 I would like new_variable to be 8 but I keep getting NA and I have unsuccessfully tried different methods to do so. I feel there is a simple method to solve my problem but I am unaware of such. I would appreciate any guidance! Thank you JC [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org 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.