Data subsetting

jacksonan123 — Mon, 30 Dec 2019 18:40:30 GMT

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;

Re: Data subsetting

novinosrin — Mon, 30 Dec 2019 18:51:51 GMT

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

topic Data subsetting in SAS Programming

Data subsetting

Re: Data subsetting