BookmarkSubscribeRSS Feed
Ingrid88
Calcite | Level 5

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!

5 REPLIES 5
ballardw
Super User

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

Ingrid88
Calcite | Level 5

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.

ballardw
Super User

Are the dates SAS date variables?

Ingrid88
Calcite | Level 5

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

ballardw
Super User

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?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 983 views
  • 0 likes
  • 2 in conversation