Solved: How to find even numbers in proc sql

BrahmanandaRao · Posted 09-16-2019 10:54 PM

How to find even numbers in proc sql

PGStats · Posted 09-16-2019 11:02 PM

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;

PG

PGStats · Posted 09-16-2019 11:02 PM

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;

PG

BrahmanandaRao · Posted 09-16-2019 11:27 PM

Thank you very much

How to find even numbers in proc sql