proc sql

[Thalitacosta]

I have 2 tables (A and B) with the columns:

In A: Leaf, Total, Prob_A

In B: Leaf, Total, Prob_B

I need to join these 2 tables (in C), but when I do "full join" by "proc sql", it's returning:

In C: Leaf, Total, Prob_A, Prob_B

But only the variable "Leaf" is the key, the "Total" has diferente values.

How to return the "Total" from th 2 tables? Thus:

C: Leaf, Total_A, Total_B, Prob_A, Prob_B

[Astounding · Accepted solution]

Your SELECT clause needs to be more specific, along the lines of:

select A.Total as Total_A, B.Total as Total_B, Prob_A, Prob_B, A.Leaf

from A, B