topic Re: Rolling Standard Deviation Calculation in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167231#M946 <HTML><HEAD></HEAD><BODY><P>There are lots of people who have "date" variables that are character and when you try to group those it gets very messy. For charting purposes I'm going to assume that you're willing to accept a summary and not try to have the graphing program calculate it. Is that correct?</P></BODY></HTML> Fri, 13 Feb 2015 00:02:22 GMT ballardw 2015-02-13T00:02:22Z Rolling Standard Deviation Calculation https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167226#M941 <HTML><HEAD></HEAD><BODY><P>I'm trying to create a bar/line chart by month. I need the caluclation to be a rolling Standard Deviation (uses previous X months as data points instead of the whole data set at once). Does anyone know a way to calculate this?</P><P></P><P>Also, is there a way to calculate standard deviation off an aggregated measure (percent) instead of just a measure?</P><P></P><P>Any help would be greatly appreciated!</P></BODY></HTML> Thu, 12 Feb 2015 22:12:03 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167226#M941 Ingrid88 2015-02-12T22:12:03Z Re: Rolling Standard Deviation Calculation https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167227#M942 <HTML><HEAD></HEAD><BODY><P>Are you data individual months or varying number of records per month?</P></BODY></HTML> Thu, 12 Feb 2015 22:23:08 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167227#M942 ballardw 2015-02-12T22:23:08Z Re: Rolling Standard Deviation Calculation https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167228#M943 <HTML><HEAD></HEAD><BODY><P>The number of records vary by each month. The records are of complaints and each complaint has an entered date. In the chart, they are grouped by month.</P></BODY></HTML> Thu, 12 Feb 2015 22:27:40 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167228#M943 Ingrid88 2015-02-12T22:27:40Z Re: Rolling Standard Deviation Calculation https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167229#M944 <HTML><HEAD></HEAD><BODY><P>Are the dates SAS date variables?</P></BODY></HTML> Thu, 12 Feb 2015 22:40:36 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167229#M944 ballardw 2015-02-12T22:40:36Z Re: Rolling Standard Deviation Calculation https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167230#M945 <HTML><HEAD></HEAD><BODY><P>Yes, the column is Entered Date and they are using the format MMMYYYY. Is this what you were asking?</P></BODY></HTML> Thu, 12 Feb 2015 22:44:19 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167230#M945 Ingrid88 2015-02-12T22:44:19Z Re: Rolling Standard Deviation Calculation https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167231#M946 <HTML><HEAD></HEAD><BODY><P>There are lots of people who have "date" variables that are character and when you try to group those it gets very messy. For charting purposes I'm going to assume that you're willing to accept a summary and not try to have the graphing program calculate it. Is that correct?</P></BODY></HTML> Fri, 13 Feb 2015 00:02:22 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Rolling-Standard-Deviation-Calculation/m-p/167231#M946 ballardw 2015-02-13T00:02:22Z