https://communities.sas.com/t5/SAS-Enterprise-Guide/Countif-equivalent/m-p/334452#M22239 <P>I have a dataset consiting of 40 rows (ResInd_1 - ResInd_40) each with a combination of one or more of the numbers 1-19.</P><P>Example</P><P><SPAN>ssid &nbsp;ResInd_1 &nbsp;ResInd_2 &nbsp;ResInd_3 &nbsp;ResInd_4 &nbsp;...</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4,8,10,11 &nbsp; &nbsp; 2,19</SPAN></P><P><SPAN>2 &nbsp; &nbsp; &nbsp; &nbsp;2,3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</SPAN></P><P><SPAN>...</SPAN></P><P>&nbsp;</P><P><SPAN>I'd like to count the number of times each number occurs in total</SPAN></P><P><SPAN>Example</SPAN></P><P><SPAN>obs &nbsp;occuring</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; 4</SPAN></P><P><SPAN>2 &nbsp; &nbsp; &nbsp; 3</SPAN></P><P><SPAN>3 &nbsp; &nbsp; &nbsp; 1</SPAN></P><P><SPAN>...</SPAN></P><P>&nbsp;</P> Mon, 20 Feb 2017 20:06:35 GMT THelmig 2017-02-20T20:06:35Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Countif-equivalent/m-p/334452#M22239 <P>I have a dataset consiting of 40 rows (ResInd_1 - ResInd_40) each with a combination of one or more of the numbers 1-19.</P><P>Example</P><P><SPAN>ssid &nbsp;ResInd_1 &nbsp;ResInd_2 &nbsp;ResInd_3 &nbsp;ResInd_4 &nbsp;...</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4,8,10,11 &nbsp; &nbsp; 2,19</SPAN></P><P><SPAN>2 &nbsp; &nbsp; &nbsp; &nbsp;2,3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</SPAN></P><P><SPAN>...</SPAN></P><P>&nbsp;</P><P><SPAN>I'd like to count the number of times each number occurs in total</SPAN></P><P><SPAN>Example</SPAN></P><P><SPAN>obs &nbsp;occuring</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; 4</SPAN></P><P><SPAN>2 &nbsp; &nbsp; &nbsp; 3</SPAN></P><P><SPAN>3 &nbsp; &nbsp; &nbsp; 1</SPAN></P><P><SPAN>...</SPAN></P><P>&nbsp;</P> Mon, 20 Feb 2017 20:06:35 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Countif-equivalent/m-p/334452#M22239 THelmig 2017-02-20T20:06:35Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Countif-equivalent/m-p/334455#M22240 <P>Your best bet is to restructure your data using PROC TRANSPOSE&nbsp;and SCAN() it so that you only have one value per cell.&nbsp;</P> <P>Then PROC FREQ will do the counts.&nbsp;</P> Mon, 20 Feb 2017 20:30:05 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Countif-equivalent/m-p/334455#M22240 Reeza 2017-02-20T20:30:05Z