This is my sample data
I wanted to keep all data whereby if filter ==1 for cadaidate__id==1. In other words if all observation should be kept if candidate__id==1 & filter==1 . the dataset is a long dataset and there are 11 candidate. So all observation for 11 candidates should be kept only if filter is 1 for candidate__1.
copy starting from the next line ------ ---------------
Thank you in advance
I wanted to keep all data whereby if filter ==1 for cadaidate__id==1. In other words if all observation should be kept if candidate__id==1 & filter==1 . the dataset is a long dataset and there are 11 candidate. So all observation for 11 candidates should be kept only if filter is 1 for candidate__1.
copy starting from the next line ------ ---------------
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str32 interview__id byte(candidate__id filter) "299d83f2c32f4ffea92ee8600c16f5c5" 1 2 "299d83f2c32f4ffea92ee8600c16f5c5" 2 1 "299d83f2c32f4ffea92ee8600c16f5c5" 3 1 "299d83f2c32f4ffea92ee8600c16f5c5" 4 1 "299d83f2c32f4ffea92ee8600c16f5c5" 5 1 "299d83f2c32f4ffea92ee8600c16f5c5" 6 1 "299d83f2c32f4ffea92ee8600c16f5c5" 7 1 "299d83f2c32f4ffea92ee8600c16f5c5" 8 1 "299d83f2c32f4ffea92ee8600c16f5c5" 9 1 "299d83f2c32f4ffea92ee8600c16f5c5" 10 1 "299d83f2c32f4ffea92ee8600c16f5c5" 11 1 "61b3b05e2b3c4427be27a1994c9db750" 1 1 "61b3b05e2b3c4427be27a1994c9db750" 2 1 "61b3b05e2b3c4427be27a1994c9db750" 3 1 "61b3b05e2b3c4427be27a1994c9db750" 4 1 "61b3b05e2b3c4427be27a1994c9db750" 5 1 "61b3b05e2b3c4427be27a1994c9db750" 6 1 "61b3b05e2b3c4427be27a1994c9db750" 7 1 "61b3b05e2b3c4427be27a1994c9db750" 8 1 "61b3b05e2b3c4427be27a1994c9db750" 9 1 "61b3b05e2b3c4427be27a1994c9db750" 10 1 "61b3b05e2b3c4427be27a1994c9db750" 11 1 "b51d7dcdb3034da9b3c55a5893c1375f" 1 2 "b51d7dcdb3034da9b3c55a5893c1375f" 2 1 "b51d7dcdb3034da9b3c55a5893c1375f" 3 2 "b51d7dcdb3034da9b3c55a5893c1375f" 4 2 "b51d7dcdb3034da9b3c55a5893c1375f" 5 2 "b51d7dcdb3034da9b3c55a5893c1375f" 6 2 "b51d7dcdb3034da9b3c55a5893c1375f" 7 2 "b51d7dcdb3034da9b3c55a5893c1375f" 8 1 "b51d7dcdb3034da9b3c55a5893c1375f" 9 2 "b51d7dcdb3034da9b3c55a5893c1375f" 10 2 "b51d7dcdb3034da9b3c55a5893c1375f" 11 2 "604b09f8ab5347a0845863703302b52f" 1 2 "604b09f8ab5347a0845863703302b52f" 2 2 "604b09f8ab5347a0845863703302b52f" 3 2 "604b09f8ab5347a0845863703302b52f" 4 2 "604b09f8ab5347a0845863703302b52f" 5 .a "604b09f8ab5347a0845863703302b52f" 6 2 "604b09f8ab5347a0845863703302b52f" 7 2 "604b09f8ab5347a0845863703302b52f" 8 1 "604b09f8ab5347a0845863703302b52f" 9 2 "604b09f8ab5347a0845863703302b52f" 10 1 "604b09f8ab5347a0845863703302b52f" 11 1 "3b2da007ef4a4382b9d3c3831f2b21b4" 1 1 "3b2da007ef4a4382b9d3c3831f2b21b4" 2 1 "3b2da007ef4a4382b9d3c3831f2b21b4" 3 1 "3b2da007ef4a4382b9d3c3831f2b21b4" 4 1 "3b2da007ef4a4382b9d3c3831f2b21b4" 5 1 "3b2da007ef4a4382b9d3c3831f2b21b4" 6 1 "3b2da007ef4a4382b9d3c3831f2b21b4" 7 2 "3b2da007ef4a4382b9d3c3831f2b21b4" 8 1 "3b2da007ef4a4382b9d3c3831f2b21b4" 9 2 "3b2da007ef4a4382b9d3c3831f2b21b4" 10 1 "3b2da007ef4a4382b9d3c3831f2b21b4" 11 2 "01f285f788d94528a6dc5a5c14f9959b" 1 2 "01f285f788d94528a6dc5a5c14f9959b" 2 2 "01f285f788d94528a6dc5a5c14f9959b" 3 1 "01f285f788d94528a6dc5a5c14f9959b" 4 2 "01f285f788d94528a6dc5a5c14f9959b" 5 1 "01f285f788d94528a6dc5a5c14f9959b" 6 1 "01f285f788d94528a6dc5a5c14f9959b" 7 2 "01f285f788d94528a6dc5a5c14f9959b" 8 1 "01f285f788d94528a6dc5a5c14f9959b" 9 2 "01f285f788d94528a6dc5a5c14f9959b" 10 2 "01f285f788d94528a6dc5a5c14f9959b" 11 1 "46b7064c5dd24d5ab017542975de670c" 1 2 "46b7064c5dd24d5ab017542975de670c" 2 2 "46b7064c5dd24d5ab017542975de670c" 3 1 "46b7064c5dd24d5ab017542975de670c" 4 2 "46b7064c5dd24d5ab017542975de670c" 5 1 "46b7064c5dd24d5ab017542975de670c" 6 2 "46b7064c5dd24d5ab017542975de670c" 7 1 "46b7064c5dd24d5ab017542975de670c" 8 1 "46b7064c5dd24d5ab017542975de670c" 9 2 "46b7064c5dd24d5ab017542975de670c" 10 1 "46b7064c5dd24d5ab017542975de670c" 11 1 "e999715bc23645b3ba6f359d2e0c5f1f" 1 2 "e999715bc23645b3ba6f359d2e0c5f1f" 2 2 "e999715bc23645b3ba6f359d2e0c5f1f" 3 2 "e999715bc23645b3ba6f359d2e0c5f1f" 4 2 "e999715bc23645b3ba6f359d2e0c5f1f" 5 1 "e999715bc23645b3ba6f359d2e0c5f1f" 6 2 "e999715bc23645b3ba6f359d2e0c5f1f" 7 2 "e999715bc23645b3ba6f359d2e0c5f1f" 8 1 "e999715bc23645b3ba6f359d2e0c5f1f" 9 2 "e999715bc23645b3ba6f359d2e0c5f1f" 10 2 "e999715bc23645b3ba6f359d2e0c5f1f" 11 2 "bf86be14b420406996138b60d8795f99" 1 1 "bf86be14b420406996138b60d8795f99" 2 1 "bf86be14b420406996138b60d8795f99" 3 1 "bf86be14b420406996138b60d8795f99" 4 1 "bf86be14b420406996138b60d8795f99" 5 1 "bf86be14b420406996138b60d8795f99" 6 1 "bf86be14b420406996138b60d8795f99" 7 1 "bf86be14b420406996138b60d8795f99" 8 1 "bf86be14b420406996138b60d8795f99" 9 1 "bf86be14b420406996138b60d8795f99" 10 1 "bf86be14b420406996138b60d8795f99" 11 1 "81634d704efa464eb77d718e1ecb67ec" 1 2 end label values candidate__id candidate__id label values filter filter
Thank you in advance
Comment