07-23-2016 06:52 AM
proc expand data=XXX out=XXX method=none;
convert BBB = CCC / transformin=(movmax 12 trimleft 10);
I want to find the Maximum number of the recent 12 observations (months) in the moving windows. For example, from 1,2,3,4,5,6,7,8,9,10,11,12/2000, but I want to skip 2000/12. How to code to skip the most recent obs.? Thanks.