Your question doesn't seem to match your title, so I'll answer the question, or try, I'm not 100% sure what you're after. I think you're doing some sort of time series analysis and that looking into PROC EXPAND might be worthwhile. See the last tip/trick on this page http://www.sas.com/offices/NA/canada/downloads/presentations/Vansug-Nov2011/1111Newsletter.pdf ... View more