如题。具体情况是，2000年1月1日——2010年12月31日的股票的日数据，由于Excel表容量有限，分成了4个表。因此要将这个表在SAS中合并。
形式如下

date        1         2        3        4        5
2000/1/4        98.250         29.500         5.363         16.734         97.693
2000/1/5        91.250         29.250         5.209         15.588         93.063
2000/1/6        86.750         28.833         5.183         14.304         90.285
2000/1/7        88.250         29.083         5.388         14.625         93.063
2000/1/10        89.500         29.417         5.491         15.083         92.369
2000/1/11        91.500         29.250         5.337         15.221         90.748
2000/1/12        90.000         29.250         5.234         15.267         89.128
2000/1/13        88.750         28.750         5.260         14.579         89.591
2000/1/14        87.750         28.833         5.414         14.717         89.359
2000/1/17        88.000         29.000         5.337         14.854         89.359
2000/1/18        93.000         28.750         5.337         15.404         88.896
2000/1/19        92.000         28.250         5.209         14.900         86.350
2000/1/20        92.250         28.083         5.286         14.854         84.961
2000/1/21        92.500         27.917         5.234         15.221         83.803
2000/1/24        94.000         27.833         5.209         15.038         85.887
2000/1/25        94.500         27.750         5.183         15.175         83.803
2000/1/26        98.000         27.750         5.209         14.808         84.498
2000/1/27        101.500         27.833         5.209         14.900         86.118
2000/1/28        103.000         27.500         5.157         14.625         87.739
2000/1/31        98.250         27.083         5.106         14.212         85.424
2000/2/1        99.000         26.750         5.132         14.304         85.192
2000/2/2        102.000         27.167         5.209         14.029         84.729


其中的1，2，3，4，5都是股票代码，合并时总出问题，说是
ERROR: Variable F3 has been defined as both character and numeric.
ERROR: Variable F6 has been defined as both character and numeric.
ERROR: Variable F7 has been defined as both character and numeric.
ERROR: Variable F10 has been defined as both character and numeric.
ERROR: Variable F12 has been defined as both character and numeric.
ERROR: Variable F15 has been defined as both character and numeric.
ERROR: Variable F16 has been defined as both character and numeric.
ERROR: Variable F19 has been defined as both character and numeric.
ERROR: Variable F21 has been defined as both character and numeric.
ERROR: Variable F24 has been defined as both character and numeric.
ERROR: Variable F26 has been defined as both character and numeric.
ERROR: Variable F27 has been defined as both character and numeric.
ERROR: Variable F28 has been defined as both character and numeric.


格式改了似乎也没用。
希望大虾帮助。

还是必须要存成
date        ticker       
2000/1/5        1        29.250        
2000/1/6        1        28.833        
2000/1/7        1        29.083        
2000/1/10        1         29.417        
2000/1/11        1         29.250          
2000/1/12        1         29.250        
2000/1/13        2        28.750        
2000/1/14        2        28.833        
2000/1/17  2         29.000        
2000/1/18        2        28.750        
2000/1/19        3         28.250          
2000/1/20        3        28.083        
2000/1/21        3        27.917        
2000/1/24        3        27.833        
2000/1/25        3        27.750        
2000/1/26        5        27.750        
2000/1/27        5        27.833        
2000/1/28        5        27.500        
2000/1/31        5        27.083        
2000/2/1        5        26.750        
2000/2/2        5        27.167