I'm using SAS 9.4. I have a dataset with the following variables: IDnum, exposures, cost. I want to divide my dataset into 25 bins of equal exposures and then calculate the average cost of each of the 25 bins. I tried the following: proc hpbin data=TESTDATA output=out numbin=25 PSEUDO_QUANTILE; input exposures ; ID IDnum; run; PROC SORT DATA=TESTDATA; BY IDnum; PROC SORT DATA=OUT; BY IDnum; RUN; DATA ALL; MERGE TESTDATA OUT; BY IDnum; RUN; PROC MEANS DATA=ALL; BY BIN_EXPOSURES; VAR cost; WEIGHT exposures; OUTPUT OUT=TWO MEAN=AVG_cost; RUN; PROC HPBIN does not give the equal size exposure bins. Any suggestions?
... View more