两个表的sql合并，自己写程序了，结果不是想要的。

stock	edate
7	20001221
9	20060107

stock	date	r
7	2001215	0.007692
7	2001216	-0.00509
7	2001217	0.033248
7	2001218	-0.01485
7	200123	-0.01759
7	2001224	0.015345
7	2001225	0.007556
9	20060101	0
9	20060102	-0.0025
9	20060103	0.005012
9	20060104	0
9	20060105	0
9	20060106	0.002493
9	20060107	0.002487
9	20060108	-0.00745
9	20060109	0
9	20060110	0.044736
9	20060111	-0.02267
9	20060112	0.015463
9	20060113	-0.00762
10	20060101	0.058823
10	20060102	0.024154
10	20060103	-0.04245
10	20060104	0.014778
10	20060105	-0.00971
10	20060106	0.142156

通过上面的两个表格，合并为下边的表格：
向高手致敬先！

stock	date	r	edate
7	2001215	0.007692
7	2001216	-0.00509
7	2001217	0.033248
7	2001218	-0.01485
7			20001221
7	200123	-0.01759
7	2001224	0.015345
7	2001225	0.007556
9	20060101	0
9	20060102	-0.0025
9	20060103	0.005012
9	20060104	0
9	20060105	0
9	20060106	0.002493
9	20060107	0.002487	20060107
9	20060108	-0.00745
9	20060109	0
9	20060110	0.044736
9	20060111	-0.02267
9	20060112	0.015463
9	20060113	-0.00762

1. data one;
   
2.         input stock edate yymmdd8.;
   
3.         format edate yymmdd10.;
   
4. datalines;
   
5. 7 20001221
   
6. 9 20060107
   
7. ;
   
8. data two;
   
9.         input stock date yymmdd8. r;
   
10.         format date yymmdd10.;
    
11. datalines;
    
12. 7 20001215 0.007692
    
13. 7 20001216 -0.00509
    
14. 7 20001217 0.033248
    
15. 7 20001218 -0.01485
    
16. 7 20001223 -0.01759
    
17. 7 20001224 0.015345
    
18. 7 20001225 0.007556
    
19. 9 20060101 0
    
20. 9 20060102 -0.0025
    
21. 9 20060103 0.005012
    
22. 9 20060104 0
    
23. 9 20060105 0
    
24. 9 20060106 0.002493
    
25. 9 20060107 0.002487
    
26. 9 20060108 -0.00745
    
27. 9 20060109 0
    
28. 9 20060110 0.044736
    
29. 9 20060111 -0.02267
    
30. 9 20060112 0.015463
    
31. 9 20060113 -0.00762
    
32. 10 20060101 0.058823
    
33. 10 20060102 0.024154
    
34. 10 20060103 -0.04245
    
35. 10 20060104 0.014778
    
36. 10 20060105 -0.00971
    
37. 10 20060106 0.142156
    
38. ;
    
39. proc sql;
    
40.         create table three(drop=temp) as
    
41.                 select coalesce(a.stock,b.stock) as stock, coalesce(a.edate,b.date) as temp,
    
42.                                 b.date, b.r, a.edate
    
43.                         from one a full join two b
    
44.                                 on a.stock=b.stock and a.edate = b.date
    
45.                         order by stock, temp;
    
46. quit;

复制代码

proc sql;
create table ccc as
select b.stock, a.stock as stock_, date, r, edate from
aaa as a full join bbb as b on a.stock=b.stock and b.date=a.edate
;
quit;
data ccc;
set ccc;
if stock=. then stock=stock_;
drop stock_;
run;

but not sorted as in your final dataset...waiting for better solution...

鼓掌！学习了！