Proc tabulate from multiple tables

[zetter]

How do I  proc tabulate from  multiple tables but report results on a single table?

I have got 3 tables like this:

Table A

Id      item   opinionscore

11        car      1

12        car      3

Table B

Id      item   opinionscore

11        plate     1

12       plate     1

Table c

Id      item   opinionscore

11        cup     1

12       cup 4

I want to create a combined by proc tabulate and report on excel as follows.

Item	Total Score
car	4
plate	2
cup	5
total	11

[Reeza]

You'll have to combine the tables somehow first or combine the results at the end, I'd suggest combining the tables first. You could also create a view if your tables are big and you don't want to take up the storage space.

data all;

set tablea tableb tablec;

run;

And then run your proc tabulate