https://communities.sas.com/t5/SAS-Programming/summarizing-data-with-a-different-calculation/m-p/564897#M158499 <P>Is there a way in Proc Report to distribute values by percentages but have a summary line to totals the n value in the same column.&nbsp; &nbsp;Something like this example (based on n=4, 2 values of A, and 1 value of B and C each).</P><P>&nbsp;</P><P>Category&nbsp; &nbsp; &nbsp; Distribution</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50%</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25%</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25%</P><P>Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4</P> Mon, 10 Jun 2019 14:08:46 GMT Batman 2019-06-10T14:08:46Z https://communities.sas.com/t5/SAS-Programming/summarizing-data-with-a-different-calculation/m-p/564897#M158499 <P>Is there a way in Proc Report to distribute values by percentages but have a summary line to totals the n value in the same column.&nbsp; &nbsp;Something like this example (based on n=4, 2 values of A, and 1 value of B and C each).</P><P>&nbsp;</P><P>Category&nbsp; &nbsp; &nbsp; Distribution</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50%</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25%</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25%</P><P>Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4</P> Mon, 10 Jun 2019 14:08:46 GMT https://communities.sas.com/t5/SAS-Programming/summarizing-data-with-a-different-calculation/m-p/564897#M158499 Batman 2019-06-10T14:08:46Z https://communities.sas.com/t5/SAS-Programming/summarizing-data-with-a-different-calculation/m-p/564926#M158512 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/9248">@Batman</a>&nbsp;wrote:<BR /> <P>Is there a way in Proc Report to distribute values by percentages but have a summary line to totals the n value in the same column.&nbsp; &nbsp;Something like this example (based on n=4, 2 values of A, and 1 value of B and C each).</P> <P>&nbsp;</P> <P>Category&nbsp; &nbsp; &nbsp; Distribution</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50%</P> <P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25%</P> <P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25%</P> <P>Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4</P> <HR /></BLOCKQUOTE> <P>Are you attempting to force a data distribution or only report something like&nbsp;PCTN or PCTSUM and&nbsp;a different value in the summary?</P> <P>The calculated distribution of existing values likely can be either of those statistics but if you need to force some distribution that is not the purview of Proc Report and (many) more details would be needed.</P> <P>A computer after block should be able to display a different value.</P> <P>&nbsp;</P> Mon, 10 Jun 2019 15:37:02 GMT https://communities.sas.com/t5/SAS-Programming/summarizing-data-with-a-different-calculation/m-p/564926#M158512 ballardw 2019-06-10T15:37:02Z