topic SELECT numbers dividable by 1000 in SAS Programming

SELECT numbers dividable by 1000

Ronein — Wed, 24 Jan 2024 12:44:23 GMT

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 — Wed, 24 Jan 2024 12:48:45 GMT

Use the MOD function, e.g.

if mod(x,1000) = 0

I leave the rest of the condition to you.

Patrick — Wed, 24 Jan 2024 13:05:34 GMT

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

Ronein — Wed, 24 Jan 2024 14:25:33 GMT

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;