topic Determine odd/even numbers in SAS Procedures

Determine odd/even numbers

acairns — Tue, 21 Dec 2010 19:52:58 GMT

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

Re: Determine odd/even numbers

SPR — Tue, 21 Dec 2010 20:00:27 GMT

Hello Acaims,

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

Sincerely,
SPR

Re: Determine odd/even numbers

polingjw — Tue, 21 Dec 2010 20:01:29 GMT

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]

Re: Determine odd/even numbers

acairns — Tue, 21 Dec 2010 20:04:54 GMT

Thank you!!! That worked great!

Re: Determine odd/even numbers

Polina_UH — Tue, 21 Jan 2020 12:42:53 GMT

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