Hello,

how can I drop a group if there is a missing value in any variable per group. In the example blow, my group is identified by "id". So, I would like to delete all 1, because there is one missing value for this group. Another condition is that it should only be excluded if the missing value for price is within the range (x,y) of var5.

Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input str10 date float(Price dividend id var5)
"01/01/2006" 5 . 1 -3
"02/01/2006" 3 . 1 -2
"03/01/2006" . 3 1 -1
"04/01/2006" 5 . 1  0
"05/01/2006" 2 . 1  1
"01/01/2006" 5 . 2 -2
"02/01/2006" 4 . 2 -1
"03/01/2006" 2 . 2  0
"04/01/2006" 1 2 2  1
"05/01/2006" 4 . 2  2
end
Thank you!