how to unselect records in data step

[yuwda01]

Hi,

How to un-select (delete) records in data step?

I have 100 records type in input and I want to skip any data with name started with ABC or DEF or GHI. 

Thanks David

[novinosrin]

data have;
input var $10.;
cards;
ABCrwe
DEFte
GHIgteg
dfserg
bfgdxbh
vxfgnb
vsdrgf
;

data want;
set have;
if var not in :('ABC','DEF','GHI');
run;

 You could use WHERE as well

where var not in :('ABC','DEF','GHI');

[yuwda01]

Sorry, the input are done on the previous step and it created temp data.

Now I need to use temp data to create another temp1 data without those data I want to skip.



Thanks David

[novinosrin · Accepted solution]

HAVE is the input sample I created for demonstration

You could also use boring substr function to achieve the same

data want;
set have;
where substr(var,1,3) not in ('ABC','DEF','GHI');
run;

if substr(var,1,3) not in ('ABC','DEF','GHI');

[yuwda01]

yes, it works...   Thanks for the advice.