## Moving percentile not include current record

Solved
Super Contributor
Posts: 506

# Moving percentile not include current record

Hi Everyone,

I want to calculate moving quartile not include current record.

This post below is the moving including current record.

https://communities.sas.com/message/173630

I thought it could be a{1:252} but clearly, it doesn't work.

Can you fix it for me or can you suggest other method?

Thank you,

HHC

data have(drop=i);

do i=1 to 10000;

x=ranuni(-1);

output;

end;

run;

data want;

set have;

array a{0:251} _temporary_ ;

a{mod(_n_,252)}=x;

pct_20=pctl(20,of a{*});

run;

Accepted Solutions
Solution
‎06-17-2014 05:57 PM
Super User
Posts: 23,689

## Re: Moving percentile not include current record

Change the order perhaps? I would also set pct_20 to missing if you don't have 252 records so a full moving window.

data want2;

set have;

array a{0:251} aa1-aa252 ;

retain aa: ;

pct_20=pctl(20,of a(*));

a{mod(_n_,252)}=x;

if _n_ <252 then pct_20=.;

run;

All Replies
Solution
‎06-17-2014 05:57 PM
Super User
Posts: 23,689

## Re: Moving percentile not include current record

Change the order perhaps? I would also set pct_20 to missing if you don't have 252 records so a full moving window.

data want2;

set have;

array a{0:251} aa1-aa252 ;

retain aa: ;

pct_20=pctl(20,of a(*));

a{mod(_n_,252)}=x;

if _n_ <252 then pct_20=.;

run;

Super Contributor
Posts: 506

## Re: Moving percentile not include current record

Thank you, Reeza for correcting it.

HHC

🔒 This topic is solved and locked.