topic Re: How to delete observations outside of a specified range in SAS Procedures

How to delete observations outside of a specified range

ccox4682 — Tue, 28 Jan 2014 20:43:05 GMT

Hello, hoping someone here can help. I think I'm missing something deceptively simple and obvious in my if-then statement. In short, I want to delete all observations outside of a specified range (e.g. 'value' ge 'varA' ge value;) dependent upon the conditions of another variable (varB = '2', for instance). I think I'm close, but I've wasted two days trying to get it to work to no avail. Can someone help?

Re: How to delete observations outside of a specified range

CTorres — Tue, 28 Jan 2014 21:01:12 GMT

Try this:

data class;

set sashelp.class;

if (13 <= age <= 15) and sex='F' then delete;

run;

Re: How to delete observations outside of a specified range

ccox4682 — Wed, 29 Jan 2014 19:15:02 GMT

Thanks for the suggestion. It didn't work for my particular purposes but I figured out something that did. Here's the code in case anyone's interested:

proc sql;

delete from lib.dataset

where varA not between 'value' and 'value' and varB eq value;

quit;