Proc Expand: Skip the most recent obs. in moving window

Reply
Contributor ZZB
Contributor
Posts: 40

Proc Expand: Skip the most recent obs. in moving window

proc expand data=XXX out=XXX method=none;
by AAA;
convert BBB = CCC / transformin=(movmax 12 trimleft 10);
run;

 

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.

Ask a Question
Discussion stats
  • 0 replies
  • 176 views
  • 0 likes
  • 1 in conversation