How to find even numbers in proc sql

[BrahmanandaRao]

How to find even numbers in proc sql

[PGStats · Accepted solution]

You can find if a number is even in SQL just like anywhere else in SAS: using the MOD function

title "Even aged students";
proc sql;
select *
from sashelp.class
where mod(age, 2) = 0;
quit;

[BrahmanandaRao]

Thank you very much