https://communities.sas.com/t5/SAS-Programming/Aggregate-quarter-data-and-create-a-new-row-on-year-wise-sum/m-p/386010#M92415 <P>Or adapt the solution from&nbsp;<A href="https://communities.sas.com/t5/Base-SAS-Programming/add-new-row-which-will-aggregate-product-subcategory/m-p/379670" target="_blank">https://communities.sas.com/t5/Base-SAS-Programming/add-new-row-which-will-aggregate-product-subcategory/m-p/379670</A>, but omit the first output statement.</P> Mon, 07 Aug 2017 13:45:57 GMT Kurt_Bremser 2017-08-07T13:45:57Z https://communities.sas.com/t5/SAS-Programming/Aggregate-quarter-data-and-create-a-new-row-on-year-wise-sum/m-p/385986#M92400 <P>i have my input data like shown below, i want to sum quarter level data (q1 , q2, q3, q4) and create a new row on yearwise</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>Region</STRONG></TD><TD><STRONG>Country</STRONG></TD><TD><STRONG>Product</STRONG></TD><TD><STRONG>SubProduct</STRONG></TD><TD><STRONG>Scenario</STRONG></TD><TD><STRONG>Time Period</STRONG></TD><TD><STRONG>Net Loss Incured</STRONG></TD><TD><STRONG>Net Premium Earned</STRONG></TD><TD><STRONG>Net Commissions</STRONG></TD><TD><STRONG>CAT Losses</STRONG></TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Auto</TD><TD>Auto Non-PCG</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014Q1</TD><TD>$68</TD><TD>$68</TD><TD>($17)</TD><TD>($17)</TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Auto</TD><TD>Auto Non-PCG</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014Q2</TD><TD>($19)</TD><TD>$68</TD><TD>$68</TD><TD>($17)</TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Auto</TD><TD>Auto Non-PCG</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014Q3</TD><TD>($17)</TD><TD>($17)</TD><TD>($17)</TD><TD>($17)</TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Auto</TD><TD>Auto Non-PCG</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014Q4</TD><TD>($89)</TD><TD>$68</TD><TD>($17)</TD><TD>($17)</TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Other</TD><TD>Other</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014Q1</TD><TD>$2</TD><TD>$0</TD><TD>$0</TD><TD>$1</TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Other</TD><TD>Other</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014Q2</TD><TD>$0</TD><TD>$5</TD><TD>$6</TD><TD>$2</TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Other</TD><TD>Other</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014Q3</TD><TD>$0</TD><TD>$5</TD><TD>$7</TD><TD>$0</TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Other</TD><TD>Other</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014Q4</TD><TD>$0</TD><TD>$0</TD><TD>$0</TD><TD>$0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want my output to be :</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>Region</STRONG></TD><TD><STRONG>Country</STRONG></TD><TD><STRONG>Product</STRONG></TD><TD><STRONG>SubProduct</STRONG></TD><TD><STRONG>Scenario</STRONG></TD><TD><STRONG>Time Period</STRONG></TD><TD><STRONG>Net Loss Incured</STRONG></TD><TD><STRONG>Net Premium Earned</STRONG></TD><TD><STRONG>Net Commissions</STRONG></TD><TD><STRONG>CAT Losses</STRONG></TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Auto</TD><TD>Auto Non-PCG</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014</TD><TD>($58)</TD><TD>$187</TD><TD>$17</TD><TD>($69)</TD></TR><TR><TD>APAC</TD><TD>Australia</TD><TD>Other</TD><TD>Other</TD><TD>REPORTED ACTUALS/FORECAST</TD><TD>2014</TD><TD>2</TD><TD>10</TD><TD>13</TD><TD>3</TD></TR></TBODY></TABLE> Mon, 07 Aug 2017 13:11:44 GMT https://communities.sas.com/t5/SAS-Programming/Aggregate-quarter-data-and-create-a-new-row-on-year-wise-sum/m-p/385986#M92400 subrat1 2017-08-07T13:11:44Z https://communities.sas.com/t5/SAS-Programming/Aggregate-quarter-data-and-create-a-new-row-on-year-wise-sum/m-p/386009#M92414 <P>Create a new variable (substr(time_period,1,4)), and use that (along with the other group columns) in a class or by with proc summary.</P> Mon, 07 Aug 2017 13:44:34 GMT https://communities.sas.com/t5/SAS-Programming/Aggregate-quarter-data-and-create-a-new-row-on-year-wise-sum/m-p/386009#M92414 Kurt_Bremser 2017-08-07T13:44:34Z https://communities.sas.com/t5/SAS-Programming/Aggregate-quarter-data-and-create-a-new-row-on-year-wise-sum/m-p/386010#M92415 <P>Or adapt the solution from&nbsp;<A href="https://communities.sas.com/t5/Base-SAS-Programming/add-new-row-which-will-aggregate-product-subcategory/m-p/379670" target="_blank">https://communities.sas.com/t5/Base-SAS-Programming/add-new-row-which-will-aggregate-product-subcategory/m-p/379670</A>, but omit the first output statement.</P> Mon, 07 Aug 2017 13:45:57 GMT https://communities.sas.com/t5/SAS-Programming/Aggregate-quarter-data-and-create-a-new-row-on-year-wise-sum/m-p/386010#M92415 Kurt_Bremser 2017-08-07T13:45:57Z