Accumulating INVOICE values from SASHELP.CARS dataset for each MAKE and for each TYPE within that MAKE.
There are various makes like TOYOTA, HONDA etc. present in SASHELP.CARS dataset and each of these MAKES have various types like SEDAN, SUV etc.; Now lets consider our requirement is to calculate the total of INVOICE amount for each type under each make and total of INVOICE amount for each MAKE as well.
Sounds a lot like you may be in the same class as the OP for this: https://communities.sas.com/t5/SAS-Programming/proc-tabulate-SUM-row/m-p/781038
@ridhhi wrote:
Accumulating INVOICE values from SASHELP.CARS dataset for each MAKE and for each TYPE within that MAKE.
There are various makes like TOYOTA, HONDA etc. present in SASHELP.CARS dataset and each of these MAKES have various types like SEDAN, SUV etc.; Now lets consider our requirement is to calculate the total of INVOICE amount for each type under each make and total of INVOICE amount for each MAKE as well.
What have you tried so far?
What do you need as result? A report or a dataset?
If you need a report, have a look at "proc report"
If you need a dataset, "proc summary" is my first choice.
Keep in mind that we're not here to do your homework for you, but we're glad to help when you run into problems.
So we need to see the cause for your problems, so show us your code and the log from it.
Use the button indicated for posting logs, and the "little running man" right next to it for code:
Sounds a lot like you may be in the same class as the OP for this: https://communities.sas.com/t5/SAS-Programming/proc-tabulate-SUM-row/m-p/781038
@ridhhi wrote:
Accumulating INVOICE values from SASHELP.CARS dataset for each MAKE and for each TYPE within that MAKE.
There are various makes like TOYOTA, HONDA etc. present in SASHELP.CARS dataset and each of these MAKES have various types like SEDAN, SUV etc.; Now lets consider our requirement is to calculate the total of INVOICE amount for each type under each make and total of INVOICE amount for each MAKE as well.
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!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.