topic Re: Moving percentile not include current record in SAS Programming

Moving percentile not include current record

hhchenfx — Tue, 17 Jun 2014 21:35:10 GMT

Hi Everyone,

I want to calculate moving quartile not include current record.

This post below is the moving including current record.

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;

Reeza — Tue, 17 Jun 2014 21:57:00 GMT

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;

hhchenfx — Wed, 18 Jun 2014 02:18:10 GMT

Thank you, Reeza for correcting it.

HHC