topic Counting the number of distinct values of a variable in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153446#M12042 <HTML><HEAD></HEAD><BODY><P>What's the most efficient way to count the no. of distinct values of a particular variable in SAS EG? Google brings up the Data Exploration tool, but it seems to only work for datasets that aren't already in the SAS project. The dataset that I want to count is in the WORK library and is a product of a table join by the query builder.</P><P></P><P>Thank you!</P></BODY></HTML> Sun, 11 May 2014 13:44:51 GMT misaochan 2014-05-11T13:44:51Z Counting the number of distinct values of a variable https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153446#M12042 <HTML><HEAD></HEAD><BODY><P>What's the most efficient way to count the no. of distinct values of a particular variable in SAS EG? Google brings up the Data Exploration tool, but it seems to only work for datasets that aren't already in the SAS project. The dataset that I want to count is in the WORK library and is a product of a table join by the query builder.</P><P></P><P>Thank you!</P></BODY></HTML> Sun, 11 May 2014 13:44:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153446#M12042 misaochan 2014-05-11T13:44:51Z Re: Counting the number of distinct values of a variable https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153447#M12043 <HTML><HEAD></HEAD><BODY><P>Proc Freq nlevels option is the fastest that I know. </P></BODY></HTML> Sun, 11 May 2014 16:30:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153447#M12043 Reeza 2014-05-11T16:30:22Z Re: Counting the number of distinct values of a variable https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153448#M12044 <HTML><HEAD></HEAD><BODY><P>Is that available as a task in EG? I meant a method specific to the UI in EG, if possible.</P></BODY></HTML> Sun, 11 May 2014 16:53:42 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153448#M12044 misaochan 2014-05-11T16:53:42Z Re: Counting the number of distinct values of a variable https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153449#M12045 <HTML><HEAD></HEAD><BODY><P>If you only want EG then I suggest the summarize task twice. First time will get you the different counts of each level, the second will count the number of levels. </P><P></P><P>A different way is through a QUERY using count Distinct as a calculated variable.</P></BODY></HTML> Sun, 11 May 2014 18:22:01 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153449#M12045 Reeza 2014-05-11T18:22:01Z Re: Counting the number of distinct values of a variable https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153450#M12046 <HTML><HEAD></HEAD><BODY><P>There is a custom task that you can download.&nbsp; It calculates the cardinality -- or number of distinct levels -- of each variable in your data set.</P><P></P><P><A href="http://blogs.sas.com/content/sasdummy/2013/10/18/a-custom-task-to-check-your-data-cardinality/" title="http://blogs.sas.com/content/sasdummy/2013/10/18/a-custom-task-to-check-your-data-cardinality/"><STRONG> LINK: </STRONG>A custom task to check your data cardinality - The SAS Dummy</A></P><P></P><P>The UI looks like this:</P><P><IMG alt="http://blogs.sas.com/content/sasdummy/files/2013/10/cardtask.png" class="jive-image" src="http://blogs.sas.com/content/sasdummy/files/2013/10/cardtask.png" /></P><P>Chris</P></BODY></HTML> Sun, 11 May 2014 21:35:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153450#M12046 ChrisHemedinger 2014-05-11T21:35:45Z Re: Counting the number of distinct values of a variable https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153451#M12047 <HTML><HEAD></HEAD><BODY><P>Thank you all. <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /> I did not want to install the custom task as sometimes I work on a machine that isn't mine. But COUNT DISTINCT works well.</P></BODY></HTML> Mon, 12 May 2014 05:58:40 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Counting-the-number-of-distinct-values-of-a-variable/m-p/153451#M12047 misaochan 2014-05-12T05:58:40Z