topic Sum data from different tables in SAS Enterprise Guide

Sum data from different tables

hk2013 — Wed, 14 Mar 2018 22:42:30 GMT

i have two tables in sas ed which have the same columns and I need to sum variable

table 1:

Id Name count

1 A 20

2 B 45

3 C 56

4 D 10

table 2 :

Id Name count

1 A 7

2 B 15

3 C 75

4 D 80

output i want:

Id Name count

1 A 27

2 B 60

3 C 131

4 D 90

Re: Sum data from different tables

Reeza — Wed, 14 Mar 2018 22:51:07 GMT

Append the tables and use proc means?

Note that this creates a view which means the table doesn't really exist but is just used for the calculation. If you want a real combined table delete the view portion.

data combined / view=combined;
set table1 table2;
run;

proc means data=combined nway;
class name;
var count;
run;

@hk2013 wrote:

i have two tables in sas ed which have the same columns and I need to sum variable

table 1:

Id Name count

1 A 20

2 B 45

3 C 56

4 D 10

table 2 :

Id Name count

1 A   7

2 B   15

3 C 75

4 D   80

output i want:

Id Name count

1 A 27

2 B 60

3 C 131

4 D 90

Re: Sum data from different tables

Reeza — Wed, 14 Mar 2018 23:00:18 GMT

If you're using the GUI then you should use the Append Task to combine the data and then a query or summarize task.

Not sure if you can do unions via the query builder, if you can that's another viable approach.