topic per year calculation in SAS Programming https://communities.sas.com/t5/SAS-Programming/per-year-calculation/m-p/290700#M60174 <P>&nbsp;</P><P>Thanks guys for solving <A href="https://communities.sas.com/t5/Base-SAS-Programming/Start-Period-and-End-Period-Calculation/m-p/286840#M58919" target="_blank">https://communities.sas.com/t5/Base-SAS-Programming/Start-Period-and-End-Period-Calculation/m-p/286840#M58919</A></P><P>refered from this question.</P><P>&nbsp;</P><P>how can i limit the calulation to just a year</P><P>ie i want to find out average of Cust_Left for that year only for each month.</P><P>Output I want is &lt;Avg_Left &gt;</P><P>for 11-Apr 22</P><P>for 11-May &gt; avg(apr+may)</P><P>for 11-Dec &gt; avg(apr+ may+ .. + dec)</P><P>for 12-Jan &gt; avg(jan)</P><P>for 12-Feb &gt; avg(jan+feb)</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Month</TD><TD>Project</TD><TD>Start_Period</TD><TD>New_Cust</TD><TD>Cust_Left</TD><TD>Avg_Left</TD><TD>End_Period</TD></TR><TR><TD>11-Apr</TD><TD>a</TD><TD>0</TD><TD>131</TD><TD>22</TD><TD>22</TD><TD>109</TD></TR><TR><TD>11-May</TD><TD>a</TD><TD>109</TD><TD>70</TD><TD>85</TD><TD>53.5</TD><TD>94</TD></TR><TR><TD>11-Jun</TD><TD>b</TD><TD>94</TD><TD>55</TD><TD>70</TD><TD>59</TD><TD>79</TD></TR><TR><TD>11-Jul</TD><TD>a</TD><TD>79</TD><TD>79</TD><TD>63</TD><TD>60</TD><TD>95</TD></TR><TR><TD>11-Aug</TD><TD>a</TD><TD>95</TD><TD>154</TD><TD>96</TD><TD>67.2</TD><TD>153</TD></TR><TR><TD>11-Sep</TD><TD>b</TD><TD>153</TD><TD>185</TD><TD>90</TD><TD>71</TD><TD>248</TD></TR><TR><TD>11-Oct</TD><TD>aa</TD><TD>248</TD><TD>181</TD><TD>103</TD><TD>75.571</TD><TD>326</TD></TR><TR><TD>11-Nov</TD><TD>a</TD><TD>326</TD><TD>161</TD><TD>114</TD><TD>80.375</TD><TD>373</TD></TR><TR><TD>11-Dec</TD><TD>s</TD><TD>373</TD><TD>231</TD><TD>97</TD><TD>82.222</TD><TD>7</TD></TR><TR><TD>12-Jan</TD><TD>aaaa</TD><TD>507</TD><TD>183</TD><TD>86</TD><TD>86</TD><TD>604</TD></TR><TR><TD>Feb-12</TD><TD>aa</TD><TD>604</TD><TD>86</TD><TD>24</TD><TD>55</TD><TD>666</TD></TR><TR><TD>Mar-12</TD><TD>a</TD><TD>666</TD><TD>24</TD><TD>20</TD><TD>43.333</TD><TD>&nbsp;</TD></TR><TR><TD>Apr-12</TD><TD>s</TD><TD>670</TD><TD>20</TD><TD>18</TD><TD>37</TD><TD>672</TD></TR><TR><TD>May-12</TD><TD>a</TD><TD>672</TD><TD>18</TD><TD>47</TD><TD>39</TD><TD>643</TD></TR><TR><TD>Jun-12</TD><TD>b</TD><TD>643</TD><TD>47</TD><TD>74</TD><TD>44.833</TD><TD>&nbsp;</TD></TR><TR><TD>Jul-12</TD><TD>a</TD><TD>616</TD><TD>74</TD><TD>49</TD><TD>45.428</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How should i approach this problem any suggestion?</P><P>thanks a ton in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 10 Aug 2016 12:54:17 GMT makarand 2016-08-10T12:54:17Z per year calculation https://communities.sas.com/t5/SAS-Programming/per-year-calculation/m-p/290700#M60174 <P>&nbsp;</P><P>Thanks guys for solving <A href="https://communities.sas.com/t5/Base-SAS-Programming/Start-Period-and-End-Period-Calculation/m-p/286840#M58919" target="_blank">https://communities.sas.com/t5/Base-SAS-Programming/Start-Period-and-End-Period-Calculation/m-p/286840#M58919</A></P><P>refered from this question.</P><P>&nbsp;</P><P>how can i limit the calulation to just a year</P><P>ie i want to find out average of Cust_Left for that year only for each month.</P><P>Output I want is &lt;Avg_Left &gt;</P><P>for 11-Apr 22</P><P>for 11-May &gt; avg(apr+may)</P><P>for 11-Dec &gt; avg(apr+ may+ .. + dec)</P><P>for 12-Jan &gt; avg(jan)</P><P>for 12-Feb &gt; avg(jan+feb)</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Month</TD><TD>Project</TD><TD>Start_Period</TD><TD>New_Cust</TD><TD>Cust_Left</TD><TD>Avg_Left</TD><TD>End_Period</TD></TR><TR><TD>11-Apr</TD><TD>a</TD><TD>0</TD><TD>131</TD><TD>22</TD><TD>22</TD><TD>109</TD></TR><TR><TD>11-May</TD><TD>a</TD><TD>109</TD><TD>70</TD><TD>85</TD><TD>53.5</TD><TD>94</TD></TR><TR><TD>11-Jun</TD><TD>b</TD><TD>94</TD><TD>55</TD><TD>70</TD><TD>59</TD><TD>79</TD></TR><TR><TD>11-Jul</TD><TD>a</TD><TD>79</TD><TD>79</TD><TD>63</TD><TD>60</TD><TD>95</TD></TR><TR><TD>11-Aug</TD><TD>a</TD><TD>95</TD><TD>154</TD><TD>96</TD><TD>67.2</TD><TD>153</TD></TR><TR><TD>11-Sep</TD><TD>b</TD><TD>153</TD><TD>185</TD><TD>90</TD><TD>71</TD><TD>248</TD></TR><TR><TD>11-Oct</TD><TD>aa</TD><TD>248</TD><TD>181</TD><TD>103</TD><TD>75.571</TD><TD>326</TD></TR><TR><TD>11-Nov</TD><TD>a</TD><TD>326</TD><TD>161</TD><TD>114</TD><TD>80.375</TD><TD>373</TD></TR><TR><TD>11-Dec</TD><TD>s</TD><TD>373</TD><TD>231</TD><TD>97</TD><TD>82.222</TD><TD>7</TD></TR><TR><TD>12-Jan</TD><TD>aaaa</TD><TD>507</TD><TD>183</TD><TD>86</TD><TD>86</TD><TD>604</TD></TR><TR><TD>Feb-12</TD><TD>aa</TD><TD>604</TD><TD>86</TD><TD>24</TD><TD>55</TD><TD>666</TD></TR><TR><TD>Mar-12</TD><TD>a</TD><TD>666</TD><TD>24</TD><TD>20</TD><TD>43.333</TD><TD>&nbsp;</TD></TR><TR><TD>Apr-12</TD><TD>s</TD><TD>670</TD><TD>20</TD><TD>18</TD><TD>37</TD><TD>672</TD></TR><TR><TD>May-12</TD><TD>a</TD><TD>672</TD><TD>18</TD><TD>47</TD><TD>39</TD><TD>643</TD></TR><TR><TD>Jun-12</TD><TD>b</TD><TD>643</TD><TD>47</TD><TD>74</TD><TD>44.833</TD><TD>&nbsp;</TD></TR><TR><TD>Jul-12</TD><TD>a</TD><TD>616</TD><TD>74</TD><TD>49</TD><TD>45.428</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How should i approach this problem any suggestion?</P><P>thanks a ton in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 10 Aug 2016 12:54:17 GMT https://communities.sas.com/t5/SAS-Programming/per-year-calculation/m-p/290700#M60174 makarand 2016-08-10T12:54:17Z Re: per year calculation https://communities.sas.com/t5/SAS-Programming/per-year-calculation/m-p/290718#M60185 <P>Data want (drop = sum_left cnt);</P><P>Retain sum_left cnt;</P><P>Set have;</P><P>If month =1 then do;</P><P><SPAN style="font-size: 14px; line-height: 20px;">&nbsp;sum_left =0; cnt=0;</SPAN></P><P>End;</P><P>sum_left + cust_left;</P><P>Cnt+1;</P><P>Avg_left= sum_left/cnt;</P><P>Run;</P><P>&nbsp;</P><P>You need to take care of extracting month value from date colum</P><P>&nbsp;</P> Wed, 10 Aug 2016 14:32:20 GMT https://communities.sas.com/t5/SAS-Programming/per-year-calculation/m-p/290718#M60185 RahulG 2016-08-10T14:32:20Z