Essentially, you have poorly structured and poorly named data, and there is no obvious and easy method of getting from where you are to what you want, as far as I can see.   For maximum efficiency in SAS, you would want your data structured like this:   NAME DATE NET ABANO 2/1/2005 5.882 ABANO 3/1/2005 8.333 ... ACURITY 2/1/2005 6.644   etc.   How to get there is not easy. This would require lots of SAS programming to take the Excel file and obtain a workable data file where you can then compute 12month standard deviations.   My advice is to find some SAS expert at your company or university who can help you with this. Or maybe someone here has an idea. At this time, I do not have a good idea about how to proceed in SAS.   It might be much easier to do this in Excel.   ... View more