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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.