https://communities.sas.com/t5/SAS-Programming/Calculate-for-sum-of-a-variable-by-number-of-members-in-a/m-p/846751#M334726 <PRE><CODE class=" language-sas">proc sql; select sum(significant) / count(*) as percent format=percent7.2 from have; quit;</CODE></PRE> Tue, 29 Nov 2022 07:01:43 GMT Kurt_Bremser 2022-11-29T07:01:43Z https://communities.sas.com/t5/SAS-Programming/Calculate-for-sum-of-a-variable-by-number-of-members-in-a/m-p/846728#M334714 <P>I have a dataset with a variable called "SIGNIFICANT".&nbsp; The value for this variable is either 1 or 0.&nbsp; I want to sum the values for SIGNIFICANT and calculate the % of this sum by the total number of members in the dataset.&nbsp; For example, the following data has 10 observations.&nbsp; The sum of the SIGNIFICANT field is 3, so I am looking to calculate 30%.</P> <P>&nbsp;</P> <TABLE width="156"> <TBODY> <TR> <TD width="78">Model</TD> <TD width="78">significant</TD> </TR> <TR> <TD>Model1</TD> <TD>0</TD> </TR> <TR> <TD>Model2</TD> <TD>1</TD> </TR> <TR> <TD>Model3</TD> <TD>0</TD> </TR> <TR> <TD>Model4</TD> <TD>1</TD> </TR> <TR> <TD>Model5</TD> <TD>0</TD> </TR> <TR> <TD>Model6</TD> <TD>0</TD> </TR> <TR> <TD>Model7</TD> <TD>0</TD> </TR> <TR> <TD>Model8</TD> <TD>0</TD> </TR> <TR> <TD>Model9</TD> <TD>0</TD> </TR> <TR> <TD>Model10</TD> <TD>1</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Tue, 29 Nov 2022 03:12:59 GMT https://communities.sas.com/t5/SAS-Programming/Calculate-for-sum-of-a-variable-by-number-of-members-in-a/m-p/846728#M334714 texasmfp 2022-11-29T03:12:59Z https://communities.sas.com/t5/SAS-Programming/Calculate-for-sum-of-a-variable-by-number-of-members-in-a/m-p/846751#M334726 <PRE><CODE class=" language-sas">proc sql; select sum(significant) / count(*) as percent format=percent7.2 from have; quit;</CODE></PRE> Tue, 29 Nov 2022 07:01:43 GMT https://communities.sas.com/t5/SAS-Programming/Calculate-for-sum-of-a-variable-by-number-of-members-in-a/m-p/846751#M334726 Kurt_Bremser 2022-11-29T07:01:43Z