https://communities.sas.com/t5/New-SAS-User/How-to-find-even-numbers-in-proc-sql/m-p/589233#M14877 <P>How to find even numbers in proc sql</P> Tue, 17 Sep 2019 02:54:27 GMT BrahmanandaRao 2019-09-17T02:54:27Z https://communities.sas.com/t5/New-SAS-User/How-to-find-even-numbers-in-proc-sql/m-p/589233#M14877 <P>How to find even numbers in proc sql</P> Tue, 17 Sep 2019 02:54:27 GMT https://communities.sas.com/t5/New-SAS-User/How-to-find-even-numbers-in-proc-sql/m-p/589233#M14877 BrahmanandaRao 2019-09-17T02:54:27Z https://communities.sas.com/t5/New-SAS-User/How-to-find-even-numbers-in-proc-sql/m-p/589234#M14878 <P>You can find if a number is even in SQL just like anywhere else in SAS: using the MOD function</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">title "Even aged students"; proc sql; select * from sashelp.class where mod(age, 2) = 0; quit;</CODE></PRE> Tue, 17 Sep 2019 03:02:49 GMT https://communities.sas.com/t5/New-SAS-User/How-to-find-even-numbers-in-proc-sql/m-p/589234#M14878 PGStats 2019-09-17T03:02:49Z https://communities.sas.com/t5/New-SAS-User/How-to-find-even-numbers-in-proc-sql/m-p/589239#M14879 <P>Thank you very much&nbsp;</P> Tue, 17 Sep 2019 03:27:44 GMT https://communities.sas.com/t5/New-SAS-User/How-to-find-even-numbers-in-proc-sql/m-p/589239#M14879 BrahmanandaRao 2019-09-17T03:27:44Z