Miary pozycyjne, sas, teradata
Saturday, November 21st, 2009 | SAS
Dla sasa gotowy do odpalenia kod:
* SAS
data baza;
input x best12.;
cards;
2
3
1
4
5
6
7
8
9
10
;run;
proc sort data = baza; by x; run;
data baza_pozycja;
set baza NOBS=count;
kwantyl = round(_n_/(count/4) + 0.4999, 1);
decyl = round(_n_/(count/10)+ 0.4999,1);
run;
Dla teradaty, wymagana teabelka o nazwie baza, zaierająca kolumny id int, x int.
* TERADATA
alter table baza add kwantyl_ncr byteint;
alter table baza add decyl_ncr byteint;update baza from
(sel
a.id
quantile(4,x) as kwantyl,
quantile(10, x) as decyl
from baza a)u
set kwantyl_ncr = u.kwantyl, decyl_ncr = u.decyl
where baza .id= u.id
No comments yet.