Moving percentile not include current record

Accepted Solution Solved
Reply
Super Contributor
Posts: 371
Accepted Solution

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: 17,737

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;

View solution in original post


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

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: 371

Re: Moving percentile not include current record

Thank you, Reeza for correcting it.

HHC

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 260 views
  • 0 likes
  • 2 in conversation