Oops, forgot the initial and closing |. data out; set in; array values value1-value45; if find('|'||catx('|', of value1-value45), '|82962|')||'|' then found_82962=1; if (found_82962 and type=2 and source in ('2','3')); run;

On Tue, Oct 4, 2011 at 8:29 PM, Joe Matise <snoopy369@gmail.com> wrote: > data out; > set in; > array values value1-value45; > if find(catx('|', of value1-value45), '|82962|') then found_82962=1; > if (found_82962 and type=2 and source in ('2','3')); > run; > > -Joe > > > On Tue, Oct 4, 2011 at 5:10 PM, Subscribe Sas-L Jkr > <jayakumarreddy@gmail.com> wrote: >> I am trying to check for Variable Name Range list to see if it is equal to a >> value and also have a where clause in my statement >> >> >> data out; >> set in; >> array X (45) value1-value45; >> do i = 1 to 45; >> do while >> ( >> value(i) = '82962' >> ); >> end; >> end; >> TOB = catt( of A B C) >> where Type = '2' >> and (source = '2' or source = '3'); >> run; >> >> i want to see if one of value1 to value45 have 82962 and where type is 2 and >> source is 2 or 3 >> >> is my above program correct? >> >> is it efficient? >> >> i appreciate assistance >> >> thanks >> >> >> thanks >> >> JKR >> >