我有下表:
id comp1 comp2 comp3 comp4 comp5
1 12 14 45 78 74
2 25 45 36 88 45
如果任何comp1-comp10有36?
您可以使用WHICHN((
data want;
set have;
array comp(5) comp1-comp5;
if whichn(36, of comp(*))>0;
run;