topic Re: write correct code in New SAS User

write correct code

ridhhi — Thu, 18 Nov 2021 05:28:35 GMT

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.

Re: write correct code

andreas_lds — Thu, 18 Nov 2021 07:16:33 GMT

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.

Re: write correct code

Kurt_Bremser — Thu, 18 Nov 2021 08:39:25 GMT

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:

Re: write correct code

ridhhi — Thu, 18 Nov 2021 14:02:19 GMT

proc report

Re: write correct code

ballardw — Thu, 18 Nov 2021 17:02:01 GMT

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.