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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: