Did you know that: There is something you can do to improve the performance of using count(distinct xxxx) in proc sql?
Came across the following this morning: http://support.sas.com/techsup/unotes/SN/019/019372.html
Art