Proc tabulate from multiple tables

zetter — Tue, 07 Oct 2014 19:51:15 GMT

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

Re: Proc tabulate from multiple tables

Reeza — Tue, 07 Oct 2014 20:15:42 GMT

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

topic Proc tabulate from multiple tables in SAS Procedures

Proc tabulate from multiple tables

Re: Proc tabulate from multiple tables