topic WHERE IN (number - another number) in New SAS User

WHERE IN (number - another number)

Jens89 — Tue, 14 Jan 2020 12:29:36 GMT

I'm looking for a way to add number ranges in the where statement instead of adding them individually.

the below would be ideal but that doesn't work

data mydataset;
     set mydata;
     where var IN(1-20, 30-33, 50-65);
quit;

I have quite many ranges, I could work around it with defining the ranges individually but I am hoping there is a more efficient way.

thanks

Re: WHERE IN (number - another number)

PeterClemmensen — Tue, 14 Jan 2020 12:34:10 GMT

Remember, a data step end with a Run;. Not Quit;

You can do this

data mydata;
var=20; output;
var=21; output;
run;

data mydataset; 
    set mydata; 
    where var in (1:20, 30:33, 50:65);
run;

Re: WHERE IN (number - another number)

Jens89 — Tue, 14 Jan 2020 12:42:35 GMT

run indeed, I've been using too much proc sql I'd say!

I'm not sure if I understand the code you've written. if I have var = 20 in the first datastep, how can I then use 1:20 in the second part and why would you write var = 21 in the first step, I don't see how that fits in?

thanks

Re: WHERE IN (number - another number)

PeterClemmensen — Tue, 14 Jan 2020 12:48:27 GMT

@Jens89, I just created a simple data set so you can see how the code works. ,

The only thing you should change in your code really is - to :

Re: WHERE IN (number - another number)

Jens89 — Tue, 14 Jan 2020 13:27:20 GMT

thanks, it worked. I had some error but it was unrelated to your solution.