Hi I have data like this var1 var2 var3 a 16 10 a 6 19 a 8 9 a 7 13 b 14 14 b 10 11 a 14 16 b 16 12 c 13 12 b 10 11 c 7 18 a 11 7 b 13 7 c 14 10 c 15 13 b 17 15 c 14 11 and want to apply these 3 conditions 1: var2<10 var3>15 then the value in new final column should be = "a-1" (if var1=a), "1-b"(if var1=b), "c-1"(if var1=c) 2: var2>10 var3>15 then the value in new final column should be = "a-2" (if var1=a), "2-b"(if var1=b), "c-2"(if var1=c) 3: var2>10 var3<15 then the value in new final column should be = "a-3" (if var1=a), "3-b"(if var1=b), "c-3"(if var1=c) I want my output be like this var1 var2 var3 final a 16 10 a-3 a 6 19 a-1 a 8 9 a 7 13 b 14 14 3-b b 10 11 a 14 16 a-2 b 16 12 3-b c 13 12 c-3 b 10 11 c 7 18 c-1 a 11 7 a-3 b 13 7 3-b c 14 10 c-3 c 15 13 c-3 b 17 15 c 14 11 c-3 Please help me in code
... View more