SELECT numbers dividable by 1000

[Ronein]

Hello

I want to select all numbers from have data set that meet following condition:

If number is lower than 10000 and dividable by 1000 then Ind=1

IF number higher than 10000 and dividable by 5000 then Ind=1

else Ind=0

At the end need to select only rows with Ind=1

Data have;
input X;
cards;
750
800
900
1000
1800
3000
2900
8000
8200
8500
43000
50000
90001
90000
95000
96000
;
Run;

[Kurt_Bremser · Accepted solution]

Use the MOD function, e.g.

if mod(x,1000) = 0

I leave the rest of the condition to you.

[Patrick]

@Kurt_Bremser 🤣

I'd really love sometimes to have more options than only a Thumbs Up Like as comment.

[Ronein]

if x<=10000 and mod(x,1000) = 0 then ind=1:
Else if x>10000 and mod(x,5000)=0 then ind=1:
Else ind=0;