topic Re: Similar to moving percentile question in SAS Programming

Re: Similar to moving percentile question

Haikuo — Mon, 08 Dec 2014 20:50:53 GMT

I think you mean 25th largest?

data have;

do value=1 to 1000;

output;

end;

;

run;

data want;

array t(0:499) _temporary_;

set have;

t(mod(_n_,500))=value;

if _n_>499 then

_25th=largest(25,of t(*));

run;

Haikuo

Re: Similar to moving percentile question

hhchenfx — Mon, 08 Dec 2014 21:18:04 GMT

Hi,

It is almost what I want.

However, the first record value for _25th should be 476.

file want should look like:

value _25th

1 476

2 477

...

HHC

Re: Similar to moving percentile question

Haikuo — Mon, 08 Dec 2014 21:30:31 GMT

This?

data want;

array t(0:499) _temporary_;

set have;

t(mod(_n_,500))=value;

if _n_>499 then do;

_25th=largest(25,of t(*));

n+1;

output;

end;

drop value;

rename n=value;

run;

Re: Similar to moving percentile question

hhchenfx — Mon, 08 Dec 2014 21:55:58 GMT

Yes it is the what I want. But I want to keep the original 1000 records. Right now the last 499 records are gone.

If I have to do DO LOOP through this code, each time, the data is reduced by 499.

HHC

Re: Similar to moving percentile question

Ksharp — Sun, 14 Dec 2014 10:46:33 GMT

You mean look forward ?

data have;
     do value=1 to 1000;
           output;
     end;
     ;
run;

data want;
 set have nobs=nobs;
 array x{99999} _temporary_;
 do i=_n_+1 to min(nobs,_n_+499);
  set have(rename=(value=v)) point=i;
  x{i}=v;
 end;
 _25th=largest(25,of x{*});
 call missing(of x{*});
 drop i v;
run;

Xia Keshan