How to find even numbers in proc sql
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;
View solution in original post
Thank you very much
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
View the full agenda.
Register now!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.