c****y 发帖数: 584 | 1 I have two tables A and B and want to creat a new table C. C contains all
obs in B except those also contained in A. | R*********i 发帖数: 7643 | | c*****a 发帖数: 808 | 3 you mean something like this? right joining tables?
data A;
input year qtr budget;
datalines;
2001 3 500
2001 4 400
2002 1 700
;
data B;
input year qtr sales;
datalines;
2001 4 300
2002 1 600
;
proc sql;
select A.budget, B.*
from A right join B on A.year=B.year;
quit; |
|