Counting distinct variables in SQL with SAS

2009-10-26 • {"login"=>"Philihp", "email"=>"philihp@gmail.com", "display_name"=>"Philihp", "first_name"=>"", "last_name"=>""}

One way to get the count of distinct variables, which works in most flavors of SQL, is to use a subquery. For instance, in Oracle this is:

SELECT count(SELECT DISTINCT foo FROM table) FROM dual

In SAS, using PROC SQL, you can do that too, but you can also simply do this:

SELECT count(distinct foo) FROM table