https://communities.sas.com/t5/SAS-Programming/how-to-compute-average-of-the-given-values-for-the-last-three/m-p/580624#M164949 You likely want an array but the coding should be pretty straightforward with an array. Have you tried an array solution yet? It would help if you can provide some data as a data step. <BR /><BR /><A href="https://stats.idre.ucla.edu/sas/seminars/sas-arrays/arrays-in-sas/" target="_blank">https://stats.idre.ucla.edu/sas/seminars/sas-arrays/arrays-in-sas/</A> Mon, 12 Aug 2019 18:14:14 GMT Reeza 2019-08-12T18:14:14Z https://communities.sas.com/t5/SAS-Programming/how-to-compute-average-of-the-given-values-for-the-last-three/m-p/580621#M164948 <P>Dear all,</P><P>Greetings of the day</P><P>&nbsp;</P><P>I have&nbsp; the quarterly data of a variable from june,2009 to march, 2018.&nbsp;&nbsp;</P><P>with those values, i have to compute the average value of the variable for the previous three years.&nbsp;</P><P>&nbsp;</P><P>For example, at the end of march, 2012, i have to compute the average value of the variable from june,2009 to march,2012.</P><P>Next at the end of march, 2013,&nbsp;i have to compute the average value of the variable from june,2010 to march,2013. and so on&nbsp; till march, 2018.&nbsp;</P><P>&nbsp;</P><P>the format of my dataset is as follows</P><TABLE><TBODY><TR><TD>Company Name</TD><TD>var_june2009</TD><TD>var_sept2009</TD><TD>var_dec2009</TD><TD>var_march2010</TD><TD>................</TD><TD>var_march2018</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2.05</TD><TD>2.05</TD><TD>0.46</TD><TD>0.29</TD><TD>..............</TD><TD>0.29</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>4.41</TD><TD>7.74</TD><TD>16.59</TD><TD>8.08</TD><TD>...............</TD><TD>8.22</TD></TR><TR><TD>3M India Ltd.</TD><TD>5.92</TD><TD>5.88</TD><TD>5.42</TD><TD>5.33</TD><TD>...............</TD><TD>5.14</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please help me writing the SAS code to perform the above mentioned calculation.&nbsp;</P><P>&nbsp;</P><P>thanks in advance.&nbsp;</P> Mon, 12 Aug 2019 18:08:00 GMT https://communities.sas.com/t5/SAS-Programming/how-to-compute-average-of-the-given-values-for-the-last-three/m-p/580621#M164948 srikanthyadav44 2019-08-12T18:08:00Z https://communities.sas.com/t5/SAS-Programming/how-to-compute-average-of-the-given-values-for-the-last-three/m-p/580624#M164949 You likely want an array but the coding should be pretty straightforward with an array. Have you tried an array solution yet? It would help if you can provide some data as a data step. <BR /><BR /><A href="https://stats.idre.ucla.edu/sas/seminars/sas-arrays/arrays-in-sas/" target="_blank">https://stats.idre.ucla.edu/sas/seminars/sas-arrays/arrays-in-sas/</A> Mon, 12 Aug 2019 18:14:14 GMT https://communities.sas.com/t5/SAS-Programming/how-to-compute-average-of-the-given-values-for-the-last-three/m-p/580624#M164949 Reeza 2019-08-12T18:14:14Z