Get standard deviation of sum using weights in PROC TABULATE

jsimmo02 — Tue, 13 Mar 2018 03:04:53 GMT

Hi there,

I was wondering if there is a way to add a column with the std dev next to the sum of certain variables in PROC TABULATE. I only seem to get the STD to work when i am calculating the mean value of variables but I use weights to calculate the sum of variables and I want to include the standard deviation of using those weights (basically the same standard deviation number you get when u use surveymeans to calculate the number of occurrences a variable appears).

I have tried putting the WEIGHT statement in various places, I've tried using the vardef=weight but nothing seems to work.

Here is my code

PROC TABULATE
DATA=kid.prs (where=(PRS=1));
   VAR total;
   CLASS FEMALE /   ORDER=UNFORMATTED MISSING;
   CLASS race /   ORDER=UNFORMATTED MISSING;
   CLASS hosp_division /   ORDER=UNFORMATTED MISSING;
   CLASS zipinc /   ORDER=UNFORMATTED MISSING;
   CLASS dispuniform /   ORDER=UNFORMATTED MISSING;
   CLASS hosp_locteach /   ORDER=UNFORMATTED MISSING;
   CLASS gtube /   ORDER=UNFORMATTED MISSING;
   CLASS MDO /   ORDER=UNFORMATTED MISSING;
   CLASS TLA /   ORDER=UNFORMATTED MISSING;
   CLASS Trach /   ORDER=UNFORMATTED MISSING;
   CLASS syndromic /   ORDER=UNFORMATTED MISSING;
   keyword all sum / style=[fontwidth=wide];
   keylabel all="Total";
   TABLE /* Row Dimension */
FEMALE RACE hosp_division zipinc dispuniform hosp_locteach,
/* Column Dimension */
Total*(gtube)*(Sum='N'*f=comma12.0 ColPctSum='%'*f=pctf.) / nocellmerge;

   ;
   WEIGHT DISCWT;
   Format race racef.;
   Format female femalef.;
   Format hosp_division divisionf.;
   Format zipinc zipincf.;
   Format dispuniform dispf.;
       Format hosp_locteach hosp_locteachf.;

RUN;

Re: Get standard deviation of sum using weights in PROC TABULATE

ballardw — Tue, 13 Mar 2018 15:14:20 GMT

Total*(gtube)*(Sum='N'*f=comma12.0 ColPctSum='%'*f=pctf.  std)

should give you the standard deviation of gtube using weights.

Re: Get standard deviation of sum using weights in PROC TABULATE

jsimmo02 — Sat, 17 Mar 2018 14:51:44 GMT

That doesn't work. It seems as if the STD only works for means/median calculations not the sum calculation

topic Re: Get standard deviation of sum using weights in PROC TABULATE in SAS Programming

Get standard deviation of sum using weights in PROC TABULATE

Re: Get standard deviation of sum using weights in PROC TABULATE

Re: Get standard deviation of sum using weights in PROC TABULATE