Hello, I am trying to create 10 equal bins/deciles on my dataset by points. My data set is aggregated by week, customer, and points. I have tried using PROC RANK, however it does not create 10 equal bins every time by week because of the way that function uses Ties. I am trying to use the FLOOR function in a data step as it forces 10 bins everytime, the issues I am having with this way, is that i cannot get it to work to create to 10 bins for every week and it just does it on the entire data set. My question, is it possible to use the below FLOOR function in a PROC SQL statement that would allow me to use by GROUPS. (also, yes, i can add a by week to the below, but it doesnt acutally group it by week) data xx; set x nobs=numobs;
decile=floor(_n_*10/(numobs+1));
run;
... View more