topic Re: SAS query not counting null records in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-query-not-counting-null-records/m-p/155156#M12117 <HTML><HEAD></HEAD><BODY><P>Missing isn't a distinct value per se. Add a count(missing(col2)) as NullCount or similar (untested)</P><P>or count(distinct col2) + count(missing(col2)) as cnt.</P></BODY></HTML> Mon, 12 May 2014 15:26:32 GMT ballardw 2014-05-12T15:26:32Z SAS query not counting null records https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-query-not-counting-null-records/m-p/155155#M12116 <HTML><HEAD></HEAD><BODY><P>In this sas query:</P><P><STRONG>select col1, count(distinct col2) as cnt from table1 group by col1;</STRONG></P><P></P><P>If there are two values of col2 for the same col1, the cnt =2 which is correct. But if one of those 2 values is null, the cnt = 1. i.e it does not consider null as a distinct value. How to rewrite the query so null is considered a distinct value?</P></BODY></HTML> Mon, 12 May 2014 15:21:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-query-not-counting-null-records/m-p/155155#M12116 eagles_dare13 2014-05-12T15:21:15Z Re: SAS query not counting null records https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-query-not-counting-null-records/m-p/155156#M12117 <HTML><HEAD></HEAD><BODY><P>Missing isn't a distinct value per se. Add a count(missing(col2)) as NullCount or similar (untested)</P><P>or count(distinct col2) + count(missing(col2)) as cnt.</P></BODY></HTML> Mon, 12 May 2014 15:26:32 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-query-not-counting-null-records/m-p/155156#M12117 ballardw 2014-05-12T15:26:32Z