- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.