求助

数据集1

hop	no	sex	rbc0	wbc0	rbc1	wbc1
1	1	1	3	5	2	8
1	2	2	2.5	.	.	13
1	3	1	5	12	7	5
2	4	1	2	8	3	5
2	5	2	.	13	2.5	.
2	6	1	7	5	5	12

数据集2

hop	sex	vname	l	u
1	1	rbc	4	6
1	2	rbc	3.5	5.5
1		wbc	4	10
2		rbc	3.5	5.5
2		wbc	4	10

注：l和u分别是下限和上限
hop=1 时rbc的上下限是分性别的

如何根据数据2给的上下限挑选出数据集1中rbc0 wbc0 rbc1 wbc1不在上下限内的no？

tempfile tmp
use 数据集2, clear
expand 2 if sex==.
bysort hop vname: replace sex=_n
reshape wide l u, i(hop sex) j(vname) string
isid hop sex, sort
save `tmp',replace

use 数据集1, clear
sort hop sex
merge hop sex using `tmp', uniqusing
drop if _merge==2
drop _merge

foreach x of varlist rbc0 wbc0 rbc1 wbc1{
    local var=substr("`x'",1,3)
    gen `x'_out=(`x'>u`var' | `x'<l`var' )
        disp in yellow "******* Record no. with `x' out of range ********"
        list no if `x'_out==1
}