topic Re: Sum the charge amount based on the class? in SAS Programming

Sum the charge amount based on the class?

ybz12003 — Thu, 14 Jul 2022 17:12:02 GMT

Hello,

I have a sample dataset containing ID/Charge_class/Charge_amount. Could anyone let me know how to sum up each ID's charge_amount based on the charge_class? Thanks.

Re: Sum the charge amount based on the class?

PaigeMiller — Thu, 14 Jul 2022 17:16:51 GMT

@ybz12003 wrote:

I have a sample dataset containing ID/Charge_class/Charge_amount. Could anyone let me know how to sum up each ID's charge_amount based on the charge_class? Thanks.

Well, I find that sentence to be quite unclear. What does "based on the charge class" mean?

Re: Sum the charge amount based on the class?

ballardw — Thu, 14 Jul 2022 17:18:22 GMT

If wanting a data set I would start with

Proc summary data=have nway;
   class id charge_class;
   var charge_amount;
   output out=want Sum=;
run;

Or if a report just to read

proc tabulate data=have;
   class id charge_class;
   var charge_amount;
   table id*charge_class,
         charge_amount
   ;
run;