topic Re: how to unselect records in data step in New SAS User

how to unselect records in data step

yuwda01 — Tue, 26 Mar 2019 18:21:39 GMT

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

Re: how to unselect records in data step

novinosrin — Tue, 26 Mar 2019 18:26:41 GMT

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');

Re: how to unselect records in data step

yuwda01 — Tue, 26 Mar 2019 18:27:26 GMT

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

Re: how to unselect records in data step

novinosrin — Tue, 26 Mar 2019 18:30:01 GMT

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');

Re: how to unselect records in data step

yuwda01 — Mon, 01 Apr 2019 15:16:17 GMT

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