https://communities.sas.com/t5/New-SAS-User/how-to-count-the-number-of-subjects-in-a-recode/m-p/725839#M28078 <P>Take for instance the example data set SASHELP.SHOES.&nbsp; Imagine that the region column identifies your subjects.&nbsp; Then...</P> <PRE><CODE class=" language-sas">PROC SQL; SELECT COUNT(DISTINCT(Region))) AS COUNT_DISTINCT_of_Region FROM SASHELP.SHOES ; QUIT;</CODE></PRE> <P>We find with this that there are 10 regions (or imagined subjects).&nbsp;</P> <P>&nbsp;</P> <P>Related article:&nbsp;<A href="https://blogs.sas.com/content/sasdummy/2013/10/16/about-cardinality/" target="_blank" rel="noopener">Your data ain't good looking, but it has a nice cardinality - The SAS Dummy</A></P> <P>&nbsp;</P> Fri, 12 Mar 2021 19:05:39 GMT PhilC 2021-03-12T19:05:39Z https://communities.sas.com/t5/New-SAS-User/how-to-count-the-number-of-subjects-in-a-recode/m-p/725836#M28077 <P>How do you count the number of subjects in a big dataset? Each subject has serval records , is there a way to find the number of subjects in the dataset?</P> Fri, 12 Mar 2021 16:58:28 GMT https://communities.sas.com/t5/New-SAS-User/how-to-count-the-number-of-subjects-in-a-recode/m-p/725836#M28077 hjjijkkl 2021-03-12T16:58:28Z https://communities.sas.com/t5/New-SAS-User/how-to-count-the-number-of-subjects-in-a-recode/m-p/725839#M28078 <P>Take for instance the example data set SASHELP.SHOES.&nbsp; Imagine that the region column identifies your subjects.&nbsp; Then...</P> <PRE><CODE class=" language-sas">PROC SQL; SELECT COUNT(DISTINCT(Region))) AS COUNT_DISTINCT_of_Region FROM SASHELP.SHOES ; QUIT;</CODE></PRE> <P>We find with this that there are 10 regions (or imagined subjects).&nbsp;</P> <P>&nbsp;</P> <P>Related article:&nbsp;<A href="https://blogs.sas.com/content/sasdummy/2013/10/16/about-cardinality/" target="_blank" rel="noopener">Your data ain't good looking, but it has a nice cardinality - The SAS Dummy</A></P> <P>&nbsp;</P> Fri, 12 Mar 2021 19:05:39 GMT https://communities.sas.com/t5/New-SAS-User/how-to-count-the-number-of-subjects-in-a-recode/m-p/725839#M28078 PhilC 2021-03-12T19:05:39Z https://communities.sas.com/t5/New-SAS-User/how-to-count-the-number-of-subjects-in-a-recode/m-p/725870#M28081 Define big. <BR /><BR />If you get really, really big, you may want a hash solution. Otherwise, here are two ways to find the distinct counts;<BR /><A href="https://github.com/statgeek/SAS-Tutorials/blob/master/count_distinct_by_group.sas" target="_blank">https://github.com/statgeek/SAS-Tutorials/blob/master/count_distinct_by_group.sas</A> Fri, 12 Mar 2021 18:50:49 GMT https://communities.sas.com/t5/New-SAS-User/how-to-count-the-number-of-subjects-in-a-recode/m-p/725870#M28081 Reeza 2021-03-12T18:50:49Z