Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Rolling Standard Deviation Calculation

Reply
Occasional Contributor
Posts: 5

Rolling Standard Deviation Calculation

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?

Also, is there a way to calculate standard deviation off an aggregated measure (percent) instead of just a measure?

Any help would be greatly appreciated!

Grand Advisor
Posts: 10,251

Re: Rolling Standard Deviation Calculation

Are you data individual months or varying number of records per month?

Occasional Contributor
Posts: 5

Re: Rolling Standard Deviation Calculation

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.

Grand Advisor
Posts: 10,251

Re: Rolling Standard Deviation Calculation

Are the dates SAS date variables?

Occasional Contributor
Posts: 5

Re: Rolling Standard Deviation Calculation

Yes, the column is Entered Date and they are using the format MMMYYYY. Is this what you were asking?

Grand Advisor
Posts: 10,251

Re: Rolling Standard Deviation Calculation

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?

Ask a Question
Discussion stats
  • 5 replies
  • 323 views
  • 0 likes
  • 2 in conversation