Help using Base SAS procedures

Proc tabulate from multiple tables

Reply
Contributor
Posts: 36

Proc tabulate from multiple tables

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

Super User
Posts: 19,815

Re: Proc tabulate from multiple tables

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 Smiley Happy

Ask a Question
Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation