How to sum of column values

[PaigeMiller · Accepted solution]

---

@jgos wrote:

Hi PaigeMiller,

I replace have2 with my input data and it returned with an error

Variable date is not on file WORK.QUERY_FOR_ACTS_MONTHLYTOTALS

My input data has following columns for date :

YR : e.g 2019

MT : e.g 10

Month : e.g October

Quarter : e.g 2019-q4

---

But you have to create data set HAVE2, because in the creation of HAVE2, variable DATE is created. You can't leave out that important step.

[jgos]

Thank you PaigeMiller. I modified it a little and it works the way I want it.

[Reeza]

I would not do this in SQL at all, why not use PROC MEANS which could do this by default without all of the manual coding here. What happens when new quarters are added? You'll need to update this code for each iteration.

PROC TABULATE will create this very nicely for you without all of this and will scale as the data changes. Ideal if you need a report especially and not a data set. If you need a data set I'd still use PROC TABULATE and store the results and then transpose them so it's still dynamic.

[jgos]

Hi Reeza,

As per you proc means will be more suitable based on my requirement? Can you show me what would code look like in my case?

Thanks