topic Re: SUM by GROUPS in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/SUM-by-GROUPS/m-p/383638#M65606 <P>Use proc summary with class group grade;</P> <P>Then remerge the results with your dataset, and set variables according to def.</P> <P>If you want fitting code, please post your dataset <A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">in a data step</A> so we can fit the code to the data.</P> Fri, 28 Jul 2017 11:39:10 GMT Kurt_Bremser 2017-07-28T11:39:10Z SUM by GROUPS https://communities.sas.com/t5/SAS-Procedures/SUM-by-GROUPS/m-p/383632#M65604 <P>Hello everyone,</P><P>I am beginner in SAS</P><P>I have this table</P><TABLE><TBODY><TR><TD>SNAPSHOT</TD><TD>COUNT</TD><TD>SEGMENT</TD><TD>GROUP</TD><TD>def</TD><TD>GRADE</TD></TR><TR><TD>201401</TD><TD>4472</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>1</TD></TR><TR><TD>201401</TD><TD>8691</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>2</TD></TR><TR><TD>201401</TD><TD>8289</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>3</TD></TR><TR><TD>201401</TD><TD>2209</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>4</TD></TR><TR><TD>201401</TD><TD>1450</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>5</TD></TR><TR><TD>201401</TD><TD>1333</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>6</TD></TR><TR><TD>201401</TD><TD>364</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>7</TD></TR><TR><TD>201401</TD><TD>133</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>8</TD></TR><TR><TD>201401</TD><TD>4</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>201401</TD><TD>22</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>2</TD></TR><TR><TD>201401</TD><TD>81</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>3</TD></TR><TR><TD>201401</TD><TD>61</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>4</TD></TR><TR><TD>201401</TD><TD>67</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>5</TD></TR><TR><TD>201401</TD><TD>161</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>6</TD></TR><TR><TD>201401</TD><TD>122</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>7</TD></TR><TR><TD>201401</TD><TD>130</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>8</TD></TR><TR><TD>201401</TD><TD>11642</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>201401</TD><TD>19361</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>2</TD></TR><TR><TD>201401</TD><TD>15284</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>3</TD></TR><TR><TD>201401</TD><TD>3463</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>4</TD></TR><TR><TD>201401</TD><TD>2056</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>5</TD></TR><TR><TD>201401</TD><TD>1895</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>6</TD></TR><TR><TD>201401</TD><TD>490</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>7</TD></TR><TR><TD>201401</TD><TD>153</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>8</TD></TR><TR><TD>201401</TD><TD>9</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>201401</TD><TD>59</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>2</TD></TR><TR><TD>201401</TD><TD>141</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>3</TD></TR><TR><TD>201401</TD><TD>98</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>4</TD></TR><TR><TD>201401</TD><TD>114</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>5</TD></TR><TR><TD>201401</TD><TD>218</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>6</TD></TR><TR><TD>201401</TD><TD>189</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>7</TD></TR><TR><TD>201401</TD><TD>180</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>8</TD></TR></TBODY></TABLE><P>I want this table</P><TABLE><TBODY><TR><TD>SNAPSHOT</TD><TD>COUNT</TD><TD>SEGMENT</TD><TD>GROUP</TD><TD>def</TD><TD>GRADE</TD><TD>SUM</TD><TD>DR</TD></TR><TR><TD>201401</TD><TD>4472</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>4476</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>8691</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>8713</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>8289</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>3</TD><TD>8370</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>2209</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>4</TD><TD>2270</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>1450</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>5</TD><TD>1517</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>1333</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>6</TD><TD>1494</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>364</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>7</TD><TD>486</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>133</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>0</TD><TD>8</TD><TD>263</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>4</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>&nbsp;</TD><TD>0,089%</TD></TR><TR><TD>201401</TD><TD>22</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>2</TD><TD>&nbsp;</TD><TD>0,252%</TD></TR><TR><TD>201401</TD><TD>81</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>3</TD><TD>&nbsp;</TD><TD>0,968%</TD></TR><TR><TD>201401</TD><TD>61</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>4</TD><TD>&nbsp;</TD><TD>2,687%</TD></TR><TR><TD>201401</TD><TD>67</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>5</TD><TD>&nbsp;</TD><TD>4,417%</TD></TR><TR><TD>201401</TD><TD>161</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>6</TD><TD>&nbsp;</TD><TD>10,776%</TD></TR><TR><TD>201401</TD><TD>122</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>7</TD><TD>&nbsp;</TD><TD>25,103%</TD></TR><TR><TD>201401</TD><TD>130</TD><TD>PRK_LNPL</TD><TD>0</TD><TD>1</TD><TD>8</TD><TD>&nbsp;</TD><TD>49,430%</TD></TR><TR><TD>201401</TD><TD>11642</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>11651</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>19361</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>2</TD><TD>19420</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>15284</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>3</TD><TD>15425</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>3463</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>4</TD><TD>3561</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>2056</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>5</TD><TD>2170</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>1895</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>6</TD><TD>2113</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>490</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>7</TD><TD>679</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>153</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>0</TD><TD>8</TD><TD>333</TD><TD>&nbsp;</TD></TR><TR><TD>201401</TD><TD>9</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>&nbsp;</TD><TD>0,077%</TD></TR><TR><TD>201401</TD><TD>59</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>2</TD><TD>&nbsp;</TD><TD>0,304%</TD></TR><TR><TD>201401</TD><TD>141</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>3</TD><TD>&nbsp;</TD><TD>0,914%</TD></TR><TR><TD>201401</TD><TD>98</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>4</TD><TD>&nbsp;</TD><TD>2,752%</TD></TR><TR><TD>201401</TD><TD>114</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>5</TD><TD>&nbsp;</TD><TD>5,253%</TD></TR><TR><TD>201401</TD><TD>218</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>6</TD><TD>&nbsp;</TD><TD>10,317%</TD></TR><TR><TD>201401</TD><TD>189</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>7</TD><TD>&nbsp;</TD><TD>27,835%</TD></TR><TR><TD>201401</TD><TD>180</TD><TD>PRK_LNPL</TD><TD>1</TD><TD>1</TD><TD>8</TD><TD>&nbsp;</TD><TD>54,054%</TD></TR></TBODY></TABLE><P>In column SUM i need to sum values&nbsp;in&nbsp;column COUNT&nbsp;for each grade and group seperatedly example 4476=4472+4.</P><P>In column DR i need to divide value from column COUNT and SUM for each grade and group seperatedly and only there where is in column DEF value=1. example 0,089%=4/4476.</P><P>Is here anybody who can solve my problem?</P> Fri, 28 Jul 2017 11:27:02 GMT https://communities.sas.com/t5/SAS-Procedures/SUM-by-GROUPS/m-p/383632#M65604 jopo12345678 2017-07-28T11:27:02Z Re: SUM by GROUPS https://communities.sas.com/t5/SAS-Procedures/SUM-by-GROUPS/m-p/383638#M65606 <P>Use proc summary with class group grade;</P> <P>Then remerge the results with your dataset, and set variables according to def.</P> <P>If you want fitting code, please post your dataset <A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">in a data step</A> so we can fit the code to the data.</P> Fri, 28 Jul 2017 11:39:10 GMT https://communities.sas.com/t5/SAS-Procedures/SUM-by-GROUPS/m-p/383638#M65606 Kurt_Bremser 2017-07-28T11:39:10Z