|
On Nov 8, 2007 3:21 PM, Long, Stuart (NIH/NIEHS) [C]
<long3@niehs.nih.gov> wrote:
> Hi Jane:
>
> I know you don't want the IF statement, but maybe this will simplify
> things for you? It is how I would perform this selection.
>
> DATA testit;
> INPUT a $ 1-3 b c d e f h ;
> IF INDEX(CATS(a,b,c,d,e,f,h),"7") NE 0;
> CARDS;
> aaa 1 3 4 5 6 7
> bbb 3 5 . . . .
> ccc 4 7 9 . . .
> ddd 2 6 7 . . .
> eee 1 5 . . . .
> fff 1 . 6 . 5 .
> ;
>
if one of the b,c,d,e,f,h has value of 17 or 71 or some big number
with 7 in it will break this program.
|
