https://communities.sas.com/t5/SAS-Programming/Most-efficient-way-to-get-subtotals/m-p/759213#M239869 <P>Suppose the following:</P> <PRE><CODE class=" language-sas">Apples 30 Peaches 15 Apples 27 Peaches 12 Apples 19 </CODE></PRE> <P>We want to get the subtotals for the items above.</P> <P>How best to do that?</P> <P>Thanks!</P> <P>(p.s. -- in the meantime I'll be trying to find the solution.&nbsp; my hunch is to use Proc Freq.&nbsp; but not sure....)</P> <P>&nbsp;</P> Wed, 04 Aug 2021 06:28:28 GMT NKormanik 2021-08-04T06:28:28Z https://communities.sas.com/t5/SAS-Programming/Most-efficient-way-to-get-subtotals/m-p/759213#M239869 <P>Suppose the following:</P> <PRE><CODE class=" language-sas">Apples 30 Peaches 15 Apples 27 Peaches 12 Apples 19 </CODE></PRE> <P>We want to get the subtotals for the items above.</P> <P>How best to do that?</P> <P>Thanks!</P> <P>(p.s. -- in the meantime I'll be trying to find the solution.&nbsp; my hunch is to use Proc Freq.&nbsp; but not sure....)</P> <P>&nbsp;</P> Wed, 04 Aug 2021 06:28:28 GMT https://communities.sas.com/t5/SAS-Programming/Most-efficient-way-to-get-subtotals/m-p/759213#M239869 NKormanik 2021-08-04T06:28:28Z https://communities.sas.com/t5/SAS-Programming/Most-efficient-way-to-get-subtotals/m-p/759219#M239874 <P>proc summary is probably the best way to sum by group.</P> Wed, 04 Aug 2021 06:34:37 GMT https://communities.sas.com/t5/SAS-Programming/Most-efficient-way-to-get-subtotals/m-p/759219#M239874 ChrisNZ 2021-08-04T06:34:37Z