topic Re: Between operator to delted range of observations in datastep in SAS Programming

Between operator to delted range of observations in datastep

BrahmanandaRao — Fri, 06 Oct 2023 07:11:18 GMT

data YourDataSet; /* Replace YourDataSet with your actual dataset name */
   set sashelp.class;
   if age < 11 or age > 15; /* Keep only observations where age is not between 12 and 14 */
run;

Hi Guys ,

I want delete range of observations using Between operator in data step

between operator can works with IF and WHERE please

suppose i want to delete age between 11 to 15 in sashelp.class dataset

Re: Between operator to delted range of observations in datastep

Kurt_Bremser — Fri, 06 Oct 2023 07:15:15 GMT

Use a range comparison, and negate it:

where not (12 le age le 14)

Re: Between operator to delted range of observations in datastep

PaigeMiller — Fri, 06 Oct 2023 09:59:10 GMT

@BrahmanandaRao wrote:
I want delete range of observations using Between operator in data step

between operator can works with IF and WHERE please

SAS does not allow BETWEEN in a data step IF statement