SAS Support Communities

INSUR_LEVEL should be weighted(analytic weight) by POPULATION. After that, I should compute fractional rank with the syntax that I wrote. ... View more

This: proc means data = &xvar.ranka noprint; var wealthrank; /* wealthrank_max*/ output out = wealthrank_max max = wealthrank_max; run; /* wealthrank _ max，wealthrank_max*/ data &xvar.rank; set &xvar.ranka ; if _n_ = 1 then set wealthrank_max; wealthrank_frac = wealthrank/wealthrank_max; run; can be done in a single SQL: proc sql; create table &xvar.rank as select *, wealthrank / max(wealthrank) as wealthrank_frac from &xvar.ranka ; quit;   PS: you must test this with your real data to see which of the two methods performs better. If the two-step PROC MEANS / DATA is significantly better, keep it.   ... View more

I attached the file that I found below and contents below are the calculations of Concentration index and HIwv.   This is about Concentration Index.   This is about HIwv index. HIwv index is calculated by ‘the difference between the concentration index for actual utilization and that for need-predicted utilization’ and this is the 'indirect standardization with nonlinear models'.     ... View more