topic Re: How to get the percent for the total charge column? in SAS Programming

How to get the percent for the total charge column?

ybz12003 — Fri, 19 Aug 2022 15:34:20 GMT

Hello,

I'm curious how to get the percent for the total amount of in the 'Charge' column. Thanks.

data dataIN;
   infile datalines dsd;
   input PT_class : $50.  Charge;
   datalines;
	ICU, 100,
	Lab, 200,
	Radiology, 300,
	PF fee, 500,
;

Re: How to get the percent for the total charge column?

PaigeMiller — Fri, 19 Aug 2022 15:38:54 GMT

proc sql;
    create table want as select
        pt_class
        ,charge
        ,100*charge/sum(charge) as percent
    from datain;
quit;

Re: How to get the percent for the total charge column?

ballardw — Fri, 19 Aug 2022 15:40:59 GMT

ANY time you discuss percent, or other rates for that matter, you need to define what value is used for the numerator and what value is used for the denominator.

So since I don't see anything clearly labeled as "total charge" I have no confidence what a percentage would be with that data.

And do you want a data set, for further manipulation, or a report, for people to see?

A report might be:

proc tabulate data=datain;
  var charge;
  class pt_class;
  table pt_class,
        charge*pctsum
  ;
run;

Re: How to get the percent for the total charge column?

japelin — Fri, 19 Aug 2022 15:42:51 GMT

how about this code?

proc sql;
  create table want as
    select PT_class, Charge, round(charge/sum(Charge)*100,0.01) as perc 
    from dataIN
  ;
quit;

Re: How to get the percent for the total charge column?

ybz12003 — Fri, 19 Aug 2022 15:45:59 GMT

I apologize for the confusion. I would like to get the percent = each PT_class / sum(Charge) , is it that clear?

Re: How to get the percent for the total charge column?

PaigeMiller — Fri, 19 Aug 2022 15:47:43 GMT

Alternative solution:

proc freq data=datain;
    tables pt_class/out=want noprint;
    weight charge;
run;