Determine odd/even numbers

[acairns]

I need to create a dataset of only odd account numbers from a larger data set. Any suggestions?

[SPR]

Hello Acaims,

A possible solution:
[pre]
data r;
set i;
if MOD(AccountNo,2)=1 then output;
run;
[/pre]

Sincerely,
SPR

[acairns]

Thank you!!! That worked great!

[polingjw]

Consider using the mod function. Assuming there is an integer variable in your dataset called ACCOUNT, odd numbered accounts could be selected with the following where statement.
[pre]
where mod(account, 2)=1;
[/pre]

[Polina_UH]

Thank you so much! I also just figured that I can merge all the datasets and it will give me my desired dataset.