https://communities.sas.com/t5/New-SAS-User/How-do-I-get-the-standard-deviation-for-my-sales-data-for-the/m-p/703863#M26062 <P>I have a data set. I am trying to get the standard deviation for the last ten years for each of my observations. For example, I have data from 1992-2009. So I gathered data from 10 years prior to 1992 to have sufficient data. How do I calculate the STD for each year starting with 1992-2009, by taking the 10 years prior of data? For example, for 1992, I need to see the data from 1983-1992, including data from 1983 and 1992. For 1993, I use data from 1984-1993, and so on. I am trying to do this for each firm, or GVKEY from Compustat. All help appreciated.&nbsp;</P> Sat, 05 Dec 2020 17:32:24 GMT gibsonrobb 2020-12-05T17:32:24Z https://communities.sas.com/t5/New-SAS-User/How-do-I-get-the-standard-deviation-for-my-sales-data-for-the/m-p/703863#M26062 <P>I have a data set. I am trying to get the standard deviation for the last ten years for each of my observations. For example, I have data from 1992-2009. So I gathered data from 10 years prior to 1992 to have sufficient data. How do I calculate the STD for each year starting with 1992-2009, by taking the 10 years prior of data? For example, for 1992, I need to see the data from 1983-1992, including data from 1983 and 1992. For 1993, I use data from 1984-1993, and so on. I am trying to do this for each firm, or GVKEY from Compustat. All help appreciated.&nbsp;</P> Sat, 05 Dec 2020 17:32:24 GMT https://communities.sas.com/t5/New-SAS-User/How-do-I-get-the-standard-deviation-for-my-sales-data-for-the/m-p/703863#M26062 gibsonrobb 2020-12-05T17:32:24Z https://communities.sas.com/t5/New-SAS-User/How-do-I-get-the-standard-deviation-for-my-sales-data-for-the/m-p/703865#M26063 <P>This is called a "moving standard deviaton". PROC EXPAND will calculate it for you. See this example (where you need to use MOVSTD in place of MOVAVE) <A href="https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.4&amp;docsetId=etsug&amp;docsetTarget=etsug_expand_examples04.htm&amp;locale=en" target="_blank">https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.4&amp;docsetId=etsug&amp;docsetTarget=etsug_expand_examples04.htm&amp;locale=en</A></P> Sat, 05 Dec 2020 18:12:10 GMT https://communities.sas.com/t5/New-SAS-User/How-do-I-get-the-standard-deviation-for-my-sales-data-for-the/m-p/703865#M26063 PaigeMiller 2020-12-05T18:12:10Z https://communities.sas.com/t5/New-SAS-User/How-do-I-get-the-standard-deviation-for-my-sales-data-for-the/m-p/703866#M26064 <P>Thank you, I will take a look and let you know how it goes.&nbsp;</P> Sat, 05 Dec 2020 18:15:00 GMT https://communities.sas.com/t5/New-SAS-User/How-do-I-get-the-standard-deviation-for-my-sales-data-for-the/m-p/703866#M26064 gibsonrobb 2020-12-05T18:15:00Z