Data subsetting

[jacksonan123]

I have the following data:

a                        b                       c

nrename        test1.nm7      0test1.nm7

nrename        test2.nm7      1test2.nm7

nrename        test3.nm7       0test3.nm7

What type of keep statement do I need that will allow me to keep only those rows which contain 1testi.nm7?

I plan to handle the i with a do loop but not sure how to keep a  character statement.

I saw a post that gave the statement ,if sym_suffix in ('A', ' ');

When I tried 

 
     
data new;    
SET NEWB;
 if prefix in (1, ' '); 
 run;

I get the following error.  What statement can I use to keep character data with the 1 prefix?

74 data new;

75 SET NEWB;

76 if prefix in (1, ' ');

ERROR: All variables in array list must be the same type, i.e., all numeric or character.

77 run;

[novinosrin · Accepted solution]

data have;
input (a                        b                       c) (:$10.);
cards;
nrename        test1.nm7      0test1.nm7
nrename        test2.nm7      1test2.nm7
nrename        test3.nm7       0test3.nm7
;

data want;
set have;
array t b--c;
do over t;
 if first(t) in (' ', '1') then f=1;
end;
if f;
drop f; 
run;

array t b--c;

This means we are grouping variables starting from b and anything between b and c, including c. HTH