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.
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;
@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?
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.