Sudhi.Upadhyaya
2011-Dec-13 16:12 UTC
[R] Generating weights based on certain condition in the dataset
Dear all, My goal is to create weights. I have three covariates x1 x2 x3 These three covariates are discrete, they can only store either 1 or 0. So x1 x2 x3 ---------- 0 1 0 0 0 1 1 0 0 1 1 0 1 0 1 0 1 1 ...... Sometimes they have missing data x1 x2 x3 ---------- 0 1 - 0 0 1 1 - 0 1 1 0 - 0 1 0 - - ...... I need help to generate the following situation a) If there is a missing data then it can either be 0 0r 1. So lets consider the first row. The new program should create 2 new rows because x13 is missing. The two new rows should be like this x1 x2 x3 weight ---------------- 0 1 0 w1=0.5 0 1 0 w2=0.5 0 0 1 1 - 0 1 1 0 - 0 1 0 - - ...... Consider the last row. The last row contains two missing data. So the new program should create 4 new rows. The new rows should be like this. x1 x2 x3 weight ---------------- 0 1 0 w1=0.5 0 1 0 w2=0.5 0 0 1 1 - 0 1 1 0 - 0 1 0 0 0 w1 =0.25 0 1 1 w2 =0.25 0 0 1 w3 =0.25 0 1 0 w4 =0.25 ...... Also please see the image attached. Please let me know if you have more questions. Sincerely Sudhi Upadhyaya http://r.789695.n4.nabble.com/file/n4190948/weights.png weights.png -- View this message in context: http://r.789695.n4.nabble.com/Generating-weights-based-on-certain-condition-in-the-dataset-tp4190948p4190948.html Sent from the R help mailing list archive at Nabble.com.