紧急求助：SAS数据导入

一点喜悦

拜托看一下SAS的数据导入，txt文档

格式很多，不会做了，只要能读入就行，拜托大家帮忙。

                           e                                                                                                                                                                            m

                            x                                                                                                                                                                       o    p

                            e                                                                                                     i                                        s                        p    l

                            r                                                                                                     n                                        t                        e    _

                      e   i c                                                                                                     d                                        r                b       n    v

                      x   s i                                                                                                     e                                 l      i                e       _    o

                      c   s s              i                                                                                      x     o                           a      k         b      s       i    l

                      h   u e              n                                                                                      _     p                           s c    e         e      t s     n    a

                 t    a   e _              d                                        v     r                                       v     t        s         e        t p    _         s      _ s     t    t

   s             i    n   _ s i            e                               c        o     e     c   c             t   t   c c p p o     i        u         x        _ _    p         t      o _     e    i        d        g                   t

   e          d  c    g   t t s            x                       h       l        l     t     f o f    r        c   c   c c c c l     o     r  f         d        d f    r         _      f f     r    l        e        a          v        h

   c          a  k    e   y y s            n               l       i       o        u     u     a p r    a        v   o   v o v o u     n     o  f         a        a l    i         b      f l     e    i        l        m          e        e

   i          t  e    _   p l u            a               o       g       s        m     r     d e e    t        o   p   o p o p m     i     o  i         t        t a    c         i      e a     s    t        t        m          g        t

   d          e  r    d   e e e            m               w       h       e        e     n     j n t    e        l   i   l i l i e     d     t  x         e        e g    e         d      r g     t    y        a        a          a        a

101499 20070103 XMI 32768 A E   AMEX MAJOR MARKET INDEX 1239.06 1254.68 1244.60     0 -0.001124 1 0 1 2.08107     0 48082 . . . . 0 32345895 XMX LT 20071222        . C 1100000 182.90 192.90 0     0 0.15471  0.84473 0.001143 264.221   -44.47

101499 20070103 XMI 32768 A E   AMEX MAJOR MARKET INDEX 1239.06 1254.68 1244.60     0 -0.001124 1 0 1 2.08107     0 48082 . . . . 0 32346359 XMZ XO 20071222        . P 1175000  17.80  27.80 0     0 0.13309 -0.22569 0.001831 363.986   -15.08

101499 20070103 XMI 32768 A E   AMEX MAJOR MARKET INDEX 1239.06 1254.68 1244.60     0 -0.001124 1 0 1 2.08107     0 48082 . . . . 0 32345725 XMI LO 20071222        . C  975000 292.10 302.10 0     0 0.17512  0.93478 0.000444 116.121   -31.64

101499 20070103 XMI 32768 A E   AMEX MAJOR MARKET INDEX 1239.06 1254.68 1244.60     0 -0.001124 1 0 1 2.08107     0 48082 . . . . 0 32346920 XMW LT 20071222        . C  900000 361.20 371.20 0     0 0.18948  0.95775 0.000229  64.881   -24.75

101499 20070103 XMI 32768 A E   AMEX MAJOR MARKET INDEX 1239.06 1254.68 1244.60     0 -0.001124 1 0 1 2.08107     0 48082 . . . . 0 32216801 XMI UH 20070922        . P  940000   0.00   7.00 0     0  .        .       .          .         .

101499 20070103 XMI 32768 A E   AMEX MAJOR MARKET INDEX 1239.06 1254.68 1244.60     0 -0.001124 1 0 1 2.08107     0 48082 . . . . 0 32077475 XMI RD 20070616        . P  920000   0.00   0.50 0     0 0.18824 -0.00487 0.000090  11.743    -2.26

101499 20070103 XMI 32768 A E   AMEX MAJOR MARKET INDEX 1239.06 1254.68 1244.60     0 -0.001124 1 0 1 2.08107     0 48082 . . . . 0 32345901 XMX XT 20071222        . P 1100000   8.40  18.40 0     0 0.15270 -0.13274 0.001143 260.666   -14.73

101499 20070103 XMI 32768 A E   AMEX MAJOR MARKET INDEX 1239.06 1254.68 1244.60     0 -0.001124 1 0 1 2.08107     0 48082 . . . . 0 32299895 XMX NT 20070217        . P 1100000   0.00   0.50 0     0 0.16084 -0.01039 0.000396  11.899    -7.50

101499 20070103 XMI 32768 A E   AMEX MAJOR MARKET INDEX 1239.06 1254.68 1244.60     0 -0.001124 1 0 1 2.08107     0 48082 . . . . 0 32345706 XMY XO 20071222        . P 1275000  44.80  54.80 0     0 0.11236 -0.44650 0.002830 474.944    -7.57

101507 20070207 MID 32768 A E MID S&P MIDCAP 400 INDEX-MID  846.56  851.33  850.55     0  0.003907 1 0 1 1.26914   396 15594 . . . . 0 32287944 MLT BR 20070217 20070131 C  890000   0.00   0.20 0   168 0.13114  0.01608 0.002295   5.369   -14.83

101507 20070207 MID 32768 A E MID S&P MIDCAP 400 INDEX-MID  846.56  851.33  850.55     0  0.003907 1 0 1 1.26914   396 15594 . . . . 0 32288834 MIZ BF 20070217        . C  630000 221.20 223.60 0     0 1.00990  0.97576 0.000418   7.524  -176.20

101507 20070207 MID 32768 A E MID S&P MIDCAP 400 INDEX-MID  846.56  851.33  850.55     0  0.003907 1 0 1 1.26914   396 15594 . . . . 0 32288843 MIZ BL 20070217        . C  660000 191.20 193.70 0     0 0.87644  0.97222 0.000540   8.446  -173.71

101507 20070207 MID 32768 A E MID S&P MIDCAP 400 INDEX-MID  846.56  851.33  850.55    55  0.003907 1 0 1 1.26914   396 15594 . . . . 0 32288787 MID NP 20070217 20070207 P  780000   0.05   0.30 0   225 0.25714 -0.01427 0.001056   4.844   -24.75

101507 20070207 MID 32768 A E MID S&P MIDCAP 400 INDEX-MID  846.56  851.33  850.55     0  0.003907 1 0 1 1.26914   396 15594 . . . . 0 32077323 MIZ FJ 20070616        . C  650000 209.10 211.80 0     0 0.25949  0.96835 0.000480  31.574   -34.47

101507 20070207 MID 32768 A E MID S&P MIDCAP 400 INDEX-MID  846.56  851.33  850.55     0  0.003907 1 0 1 1.26914   396 15594 . . . . 0 32288845 MIZ BN 20070217        . C  670000 181.20 183.70 0     0 0.83090  0.97109 0.000589   8.732  -171.23

101507 20070207 MID 32768 A E MID S&P MIDCAP 400 INDEX-MID  846.56  851.33  850.55     0  0.003907 1 0 1 1.26914   396 15594 . . . . 0 32077322 MIZ FL 20070616        . C  660000 199.40 202.00 0     0 0.24944  0.96628 0.000530  33.559   -35.18

102434 20070122 RUT 32768 A E     CBOE RUSSELL 2000 INDEX-RUT 775.83 785.04 777.96    5 -0.009170 1 0 1 1.79064 51020 411039 . . . . 0 32203429 RUY RH 20070616 20070122 P  640000   5.00   5.30 0   100 0.25814 -0.08370 0.001222  74.771   -21.99

102434 20070122 RUT 32768 A E     CBOE RUSSELL 2000 INDEX-RUT 775.83 785.04 777.96    0 -0.009170 1 0 1 1.79064 51020 411039 . . . . 0 31938369 RUY RJ 20070616 20070104 P  650000   5.90   6.20 0  3602 0.25468 -0.09680 0.001379  83.289   -24.02

102434 20070122 RUT 32768 A E     CBOE RUSSELL 2000 INDEX-RUT 775.83 785.04 777.96   10 -0.009170 1 0 1 1.79064 51020 411039 . . . . 0 32277072 RUW RL 20070616 20070122 P  560000   1.00   1.30 0  2300 0.28274 -0.02122 0.000369  24.763    -8.28

102434 20070122 RUT 32768 A E     CBOE RUSSELL 2000 INDEX-RUT 775.83 785.04 777.96    0 -0.009170 1 0 1 1.79064 51020 411039 . . . . 0 31938361 RUW RT 20070616 20070112 P  600000   2.40   2.70 0   429 0.27085 -0.04420 0.000707  45.429   -14.32

102434 20070122 RUT 32768 A E     CBOE RUSSELL 2000 INDEX-RUT 775.83 785.04 777.96    5 -0.009170 1 0 1 1.79064 51020 411039 . . . . 0 31938351 RUZ FT 20070616 20070122 C  900000   3.10   3.50 0   441 0.15584  0.09619 0.002244  82.905   -19.02

102434 20070122 RUT 32768 A E     CBOE RUSSELL 2000 INDEX-RUT 775.83 785.04 777.96    0 -0.009170 1 0 1 1.79064 51020 411039 . . . . 0 31938342 RUW FJ 20070616 20070118 C  550000 234.70 235.60 0   437 0.29288  0.97348 0.000332  23.084   -23.33

102434 20070810 RUT 32768 A E   CBOE RUSSELL 2000 INDEX-RUT 768.47 800.15 788.78     0  0.004982 1 0 1 2.07541 298283 2202727 . . . . 0 32346521 RUZ XU 20071222 20070809 P  950000 155.40 158.00 0    194  .        .       .          .         .

102434 20070810 RUT 32768 A E   CBOE RUSSELL 2000 INDEX-RUT 768.47 800.15 788.78     0  0.004982 1 0 1 2.07541 298283 2202727 . . . . 0 32384766 RUZ XW 20071222 20070726 P  920000 129.60 132.70 0     42  .        .       .          .         .

102434 20070810 RUT 32768 A E   CBOE RUSSELL 2000 INDEX-RUT 768.47 800.15 788.78    18  0.004982 1 0 1 2.07541 298283 2202727 . . . . 0 32384771 RUZ XN 20071222 20070810 P  870000  92.50  94.30 0    414 0.25755 -0.67916 0.002889 167.409   -37.29

102434 20070810 RUT 32768 A E   CBOE RUSSELL 2000 INDEX-RUT 768.47 800.15 788.78    10  0.004982 1 0 1 2.07541 298283 2202727 . . . . 0 32384753 RUZ XF 20071222 20070810 P  830000  68.40  70.00 0   2242 0.27203 -0.55855 0.003031 185.493   -51.81

102442 20070726 SML 32768 A E SML CBOE S&P SMALLCAP 600 INDEX  411.28 426.83 416.35     0 -0.024576 1 0 1 0.00000  3099   3614 . . . . 0 32651339 SLK LC 20071222        . C 415000  27.40  29.30 0     0 0.22044  0.59711 0.00665 102.271   -39.67

102442 20070726 SML 32768 A E SML CBOE S&P SMALLCAP 600 INDEX  411.28 426.83 416.35     0 -0.024576 1 0 1 0.00000  3099   3614 . . . . 0 32650416 SLL LE 20071222        . C 425000  21.90  23.80 0     0 0.21544  0.52958 0.00699 105.120   -38.60

102442 20070726 SML 32768 A E SML CBOE S&P SMALLCAP 600 INDEX  411.28 426.83 416.35     0 -0.024576 1 0 1 0.00000  3099   3614 . . . . 0 32722551 SLL VG 20071020        . P 435000  28.50  30.00 0     0 0.27128 -0.57027 0.00725  78.443   -31.97

102442 20070726 SML 32768 A E SML CBOE S&P SMALLCAP 600 INDEX  411.28 426.83 416.35     0 -0.024576 1 0 1 0.00000  3099   3614 . . . . 0 32722530 SLK VC 20071020        . P 415000  18.60  19.90 0     0 0.28247 -0.42757 0.00695  78.365   -37.54

102442 20070726 SML 32768 A E SML CBOE S&P SMALLCAP 600 INDEX  411.28 426.83 416.35     0 -0.024576 1 0 1 0.00000  3099   3614 . . . . 0 32651341 SLK LS 20071222 20070619 C 395000  39.80  42.00 0     4 0.22729  0.72078 0.00560  88.823   -38.81

102456 20070418 DJX 32768 A E DJX CBOE DOW JONES INDL AVG INDE 127.30 128.38 128.04     0  0.002427 1 0 1 2.41617 107554  797644 . . . . 0 32210661 DJX IF 20070922 20070313 C  84000 44.40 44.90 0    95 0.25752  0.98604 0.00052  0.9321  -1.6074

102456 20070418 DJX 32768 A E DJX CBOE DOW JONES INDL AVG INDE 127.30 128.38 128.04     0  0.002427 1 0 1 2.41617 107554  797644 . . . . 0 32348071 YDJ XF 20081220        . P  84000  0.35  0.45 0     0 0.20399 -0.02791 0.00189 10.5359  -0.5302

102456 20070418 DJX 32768 A E DJX CBOE DOW JONES INDL AVG INDE 127.30 128.38 128.04     0  0.002427 1 0 1 2.41617 107554  797644 . . . . 0 32439904 DJY RM 20070616        . P 143000 14.20 14.50 0     0  .        .       .        .        .

102456 20070418 DJX 32768 A E DJX CBOE DOW JONES INDL AVG INDE 127.30 128.38 128.04     0  0.002427 1 0 1 2.41617 107554  797644 . . . . 0 32439848 DJY RT 20070616        . P 150000 21.10 21.40 0     0  .        .       .        .        .

102480 20070206 NDX 32768 A E NDX CBOE NASDAQ 100 INDEX        1776.51 1800.05 1793.06     0 -0.001298 1 0 1 0.67359  44205 679332 . . . . 0 32375242 NDU PM 20070421        . P 1150000    0.00    0.20 0     0 0.34478 -0.00124 0.000015   3.291    -2.71

102480 20070206 NDX 32768 A E NDX CBOE NASDAQ 100 INDEX        1776.51 1800.05 1793.06     0 -0.001298 1 0 1 0.67359  44205 679332 . . . . 0 32375241 NDU PN 20070421        . P 1200000    0.00    0.20 0     0 0.31464 -0.00135 0.000018   3.558    -2.66

102480 20070206 NDX 32768 A E NDX CBOE NASDAQ 100 INDEX        1776.51 1800.05 1793.06     0 -0.001298 1 0 1 0.67359  44205 679332 . . . . 0 32375237 NDU PE 20070421        . P 1225000    0.00    0.25 0     0 0.30620 -0.00170 0.000022   4.377    -3.20

102480 20070206 NDX 32768 A E NDX CBOE NASDAQ 100 INDEX        1776.51 1800.05 1793.06     0 -0.001298 1 0 1 0.67359  44205 679332 . . . . 0 32375221 NDT PG 20070421 20070122 P 1325000    0.25    0.50 0    30 0.27924 -0.00509 0.000066  11.782    -7.74

102480 20070206 NDX 32768 A E NDX CBOE NASDAQ 100 INDEX        1776.51 1800.05 1793.06     0 -0.001298 1 0 1 0.67359  44205 679332 . . . . 0 32375239 NDU PO 20070421        . P 1250000    0.05    0.30 0     0 0.30108 -0.00236 0.000031   5.939    -4.22

109764 20071231 OEX 32768 A A   S&P 100 INDEX 684.46 689.43 685.65     0 -0.008187 1 0 2 1.95378  17584 216881 . . . . 0 33034304 YOL XE 20101218        . P 600000  56.30  58.30 0     0 0.24995 -0.26118 0.001165 371.623    -8.00

109764 20071231 OEX 32768 A A   S&P 100 INDEX 684.46 689.43 685.65     0 -0.008187 1 0 2 1.95378  17584 216881 . . . . 0 33034306 YOL XH 20101218        . P 640000  69.30  71.30 0     0 0.24013 -0.31509 0.001354 402.884    -7.32

109764 20071231 OEX 32768 A A   S&P 100 INDEX 684.46 689.43 685.65     0 -0.008187 1 0 2 1.95378  17584 216881 . . . . 0 33034309 YOL XO 20101218        . P 660000  76.70  78.70 0     0 0.23564 -0.34452 0.001449 415.639    -6.82

109764 20071231 OEX 32768 A A   S&P 100 INDEX 684.46 689.43 685.65     0 -0.008187 1 0 2 1.95378  17584 216881 . . . . 0 33034318 YOL XY 20101218        . P 680000  84.50  86.50 0     0 0.23091 -0.37576 0.001549 426.484    -6.20

109764 20071231 OEX 32768 A A   S&P 100 INDEX 684.46 689.43 685.65     0 -0.008187 1 0 2 1.95378  17584 216881 . . . . 0 33034314 YOL XU 20101218        . P 720000 102.00 104.00 0     0 0.22194 -0.44322 0.001749 438.378    -4.58

yuanxn

如果是向SAS导数据

就请吧虚线之间的文本先放在记事本里，存了，再把该文件改名，后缀是CSV，这样excel 就可以读入。以后，你可以在excel 里整理一下我给你转换的数据（因为我觉得有些地方转换得不太对，但纠正起来不难），以后在用sas读取这个CSV格式文件，大概就不用我来说了。另外你的变量名我猜不出，因此用x1,.... 替代了。另外这个格式的数据导入其他软件也可以。其实它是逗号分隔型取值格式（英文全称为Comma Separated Values），这个格式R也可读。

----------------------------------------------

x1,x2,x3,x4,x5,x6,x7,x8,x9,x10,x11,x12,x13,x14,x15,x16,x17,x18,x19,x20,x21,x22,x23,x24,x25,x26,x27,x28,x29,x30,x31,x32,x33,x34,x35,x36,x37,x38,x39,x40,x41,x42,x43,x44,x45,x46

101499,20070103,XMI,32768,A,E,AMEX,MAJOR,MARKET,INDEX,1239.06,1254.68,1244.6,0,-0.001124,1,0,1,2.08107,0,48082,.,.,.,.,0,32345895,XMX,LT,20071222,.,C,1100000,182.9,192.9,0,0,0.15471,0.84473,0.001143,264.221,-44.47,,,,

101499,20070103,XMI,32768,A,E,AMEX,MAJOR,MARKET,INDEX,1239.06,1254.68,1244.6,0,-0.001124,1,0,1,2.08107,0,48082,.,.,.,.,0,32346359,XMZ,XO,20071222,.,P,1175000,17.8,27.8,0,0,0.13309,-0.22569,0.001831,363.986,-15.08,,,,

101499,20070103,XMI,32768,A,E,AMEX,MAJOR,MARKET,INDEX,1239.06,1254.68,1244.6,0,-0.001124,1,0,1,2.08107,0,48082,.,.,.,.,0,32345725,XMI,LO,20071222,.,C,975000,292.1,302.1,0,0,0.17512,0.93478,0.000444,116.121,-31.64,,,,

101499,20070103,XMI,32768,A,E,AMEX,MAJOR,MARKET,INDEX,1239.06,1254.68,1244.6,0,-0.001124,1,0,1,2.08107,0,48082,.,.,.,.,0,32346920,XMW,LT,20071222,.,C,900000,361.2,371.2,0,0,0.18948,0.95775,0.000229,64.881,-24.75,,,,

101499,20070103,XMI,32768,A,E,AMEX,MAJOR,MARKET,INDEX,1239.06,1254.68,1244.6,0,-0.001124,1,0,1,2.08107,0,48082,.,.,.,.,0,32216801,XMI,UH,20070922,.,P,940000,0,7,0,0,.,.,.,.,.,,,,

101499,20070103,XMI,32768,A,E,AMEX,MAJOR,MARKET,INDEX,1239.06,1254.68,1244.6,0,-0.001124,1,0,1,2.08107,0,48082,.,.,.,.,0,32077475,XMI,RD,20070616,.,P,920000,0,0.5,0,0,0.18824,-0.00487,0.00009,11.743,-2.26,,,,

101499,20070103,XMI,32768,A,E,AMEX,MAJOR,MARKET,INDEX,1239.06,1254.68,1244.6,0,-0.001124,1,0,1,2.08107,0,48082,.,.,.,.,0,32345901,XMX,XT,20071222,.,P,1100000,8.4,18.4,0,0,0.1527,-0.13274,0.001143,260.666,-14.73,,,,

101499,20070103,XMI,32768,A,E,AMEX,MAJOR,MARKET,INDEX,1239.06,1254.68,1244.6,0,-0.001124,1,0,1,2.08107,0,48082,.,.,.,.,0,32299895,XMX,NT,20070217,.,P,1100000,0,0.5,0,0,0.16084,-0.01039,0.000396,11.899,-7.5,,,,

101499,20070103,XMI,32768,A,E,AMEX,MAJOR,MARKET,INDEX,1239.06,1254.68,1244.6,0,-0.001124,1,0,1,2.08107,0,48082,.,.,.,.,0,32345706,XMY,XO,20071222,.,P,1275000,44.8,54.8,0,0,0.11236,-0.4465,0.00283,474.944,-7.57,,,,

101507,20070207,MID,32768,A,E,MID,S&P,MIDCAP,400,INDEX-MID,846.56,851.33,850.55,0,0.003907,1,0,1,1.26914,396,15594,.,.,.,.,0,32287944,MLT,BR,20070217,20070131,C,890000,0,0.2,0,168,0.13114,0.01608,0.002295,5.369,-14.83,,,

101507,20070207,MID,32768,A,E,MID,S&P,MIDCAP,400,INDEX-MID,846.56,851.33,850.55,0,0.003907,1,0,1,1.26914,396,15594,.,.,.,.,0,32288834,MIZ,BF,20070217,.,C,630000,221.2,223.6,0,0,1.0099,0.97576,0.000418,7.524,-176.2,,,

101507,20070207,MID,32768,A,E,MID,S&P,MIDCAP,400,INDEX-MID,846.56,851.33,850.55,0,0.003907,1,0,1,1.26914,396,15594,.,.,.,.,0,32288843,MIZ,BL,20070217,.,C,660000,191.2,193.7,0,0,0.87644,0.97222,0.00054,8.446,-173.71,,,

101507,20070207,MID,32768,A,E,MID,S&P,MIDCAP,400,INDEX-MID,846.56,851.33,850.55,55,0.003907,1,0,1,1.26914,396,15594,.,.,.,.,0,32288787,MID,NP,20070217,20070207,P,780000,0.05,0.3,0,225,0.25714,-0.01427,0.001056,4.844,-24.75,,,

101507,20070207,MID,32768,A,E,MID,S&P,MIDCAP,400,INDEX-MID,846.56,851.33,850.55,0,0.003907,1,0,1,1.26914,396,15594,.,.,.,.,0,32077323,MIZ,FJ,20070616,.,C,650000,209.1,211.8,0,0,0.25949,0.96835,0.00048,31.574,-34.47,,,

101507,20070207,MID,32768,A,E,MID,S&P,MIDCAP,400,INDEX-MID,846.56,851.33,850.55,0,0.003907,1,0,1,1.26914,396,15594,.,.,.,.,0,32288845,MIZ,BN,20070217,.,C,670000,181.2,183.7,0,0,0.8309,0.97109,0.000589,8.732,-171.23,,,

101507,20070207,MID,32768,A,E,MID,S&P,MIDCAP,400,INDEX-MID,846.56,851.33,850.55,0,0.003907,1,0,1,1.26914,396,15594,.,.,.,.,0,32077322,MIZ,FL,20070616,.,C,660000,199.4,202,0,0,0.24944,0.96628,0.00053,33.559,-35.18,,,

102434,20070122,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,775.83,785.04,777.96,5,-0.00917,1,0,1,1.79064,51020,411039,.,.,.,.,0,32203429,RUY,RH,20070616,20070122,P,640000,5,5.3,0,100,0.25814,-0.0837,0.001222,74.771,-21.99,,,,

102434,20070122,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,775.83,785.04,777.96,0,-0.00917,1,0,1,1.79064,51020,411039,.,.,.,.,0,31938369,RUY,RJ,20070616,20070104,P,650000,5.9,6.2,0,3602,0.25468,-0.0968,0.001379,83.289,-24.02,,,,

102434,20070122,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,775.83,785.04,777.96,10,-0.00917,1,0,1,1.79064,51020,411039,.,.,.,.,0,32277072,RUW,RL,20070616,20070122,P,560000,1,1.3,0,2300,0.28274,-0.02122,0.000369,24.763,-8.28,,,,

102434,20070122,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,775.83,785.04,777.96,0,-0.00917,1,0,1,1.79064,51020,411039,.,.,.,.,0,31938361,RUW,RT,20070616,20070112,P,600000,2.4,2.7,0,429,0.27085,-0.0442,0.000707,45.429,-14.32,,,,

102434,20070122,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,775.83,785.04,777.96,5,-0.00917,1,0,1,1.79064,51020,411039,.,.,.,.,0,31938351,RUZ,FT,20070616,20070122,C,900000,3.1,3.5,0,441,0.15584,0.09619,0.002244,82.905,-19.02,,,,

102434,20070122,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,775.83,785.04,777.96,0,-0.00917,1,0,1,1.79064,51020,411039,.,.,.,.,0,31938342,RUW,FJ,20070616,20070118,C,550000,234.7,235.6,0,437,0.29288,0.97348,0.000332,23.084,-23.33,,,,

102434,20070810,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,768.47,800.15,788.78,0,0.004982,1,0,1,2.07541,298283,2202727,.,.,.,.,0,32346521,RUZ,XU,20071222,20070809,P,950000,155.4,158,0,194,.,.,.,.,.,,,,

102434,20070810,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,768.47,800.15,788.78,0,0.004982,1,0,1,2.07541,298283,2202727,.,.,.,.,0,32384766,RUZ,XW,20071222,20070726,P,920000,129.6,132.7,0,42,.,.,.,.,.,,,,

102434,20070810,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,768.47,800.15,788.78,18,0.004982,1,0,1,2.07541,298283,2202727,.,.,.,.,0,32384771,RUZ,XN,20071222,20070810,P,870000,92.5,94.3,0,414,0.25755,-0.67916,0.002889,167.409,-37.29,,,,

102434,20070810,RUT,32768,A,E,CBOE,RUSSELL,2000,INDEX-RUT,768.47,800.15,788.78,10,0.004982,1,0,1,2.07541,298283,2202727,.,.,.,.,0,32384753,RUZ,XF,20071222,20070810,P,830000,68.4,70,0,2242,0.27203,-0.55855,0.003031,185.493,-51.81,,,,

102442,20070726,SML,32768,A,E,SML,CBOE,S&P,SMALLCAP,600,INDEX,411.28,426.83,416.35,0,-0.024576,1,0,1,0,3099,3614,.,.,.,.,0,32651339,SLK,LC,20071222,.,C,415000,27.4,29.3,0,0,0.22044,0.59711,0.00665,102.271,-39.67,,

102442,20070726,SML,32768,A,E,SML,CBOE,S&P,SMALLCAP,600,INDEX,411.28,426.83,416.35,0,-0.024576,1,0,1,0,3099,3614,.,.,.,.,0,32650416,SLL,LE,20071222,.,C,425000,21.9,23.8,0,0,0.21544,0.52958,0.00699,105.12,-38.6,,

102442,20070726,SML,32768,A,E,SML,CBOE,S&P,SMALLCAP,600,INDEX,411.28,426.83,416.35,0,-0.024576,1,0,1,0,3099,3614,.,.,.,.,0,32722551,SLL,VG,20071020,.,P,435000,28.5,30,0,0,0.27128,-0.57027,0.00725,78.443,-31.97,,

102442,20070726,SML,32768,A,E,SML,CBOE,S&P,SMALLCAP,600,INDEX,411.28,426.83,416.35,0,-0.024576,1,0,1,0,3099,3614,.,.,.,.,0,32722530,SLK,VC,20071020,.,P,415000,18.6,19.9,0,0,0.28247,-0.42757,0.00695,78.365,-37.54,,

102442,20070726,SML,32768,A,E,SML,CBOE,S&P,SMALLCAP,600,INDEX,411.28,426.83,416.35,0,-0.024576,1,0,1,0,3099,3614,.,.,.,.,0,32651341,SLK,LS,20071222,20070619,C,395000,39.8,42,0,4,0.22729,0.72078,0.0056,88.823,-38.81,,

102456,20070418,DJX,32768,A,E,DJX,CBOE,DOW,JONES,INDL,AVG,INDE,127.3,128.38,128.04,0,0.002427,1,0,1,2.41617,107554,797644,.,.,.,.,0,32210661,DJX,IF,20070922,20070313,C,84000,44.4,44.9,0,95,0.25752,0.98604,0.00052,0.9321,-1.6074,

102456,20070418,DJX,32768,A,E,DJX,CBOE,DOW,JONES,INDL,AVG,INDE,127.3,128.38,128.04,0,0.002427,1,0,1,2.41617,107554,797644,.,.,.,.,0,32348071,YDJ,XF,20081220,.,P,84000,0.35,0.45,0,0,0.20399,-0.02791,0.00189,10.5359,-0.5302,

102456,20070418,DJX,32768,A,E,DJX,CBOE,DOW,JONES,INDL,AVG,INDE,127.3,128.38,128.04,0,0.002427,1,0,1,2.41617,107554,797644,.,.,.,.,0,32439904,DJY,RM,20070616,.,P,143000,14.2,14.5,0,0,.,.,.,.,.,

102456,20070418,DJX,32768,A,E,DJX,CBOE,DOW,JONES,INDL,AVG,INDE,127.3,128.38,128.04,0,0.002427,1,0,1,2.41617,107554,797644,.,.,.,.,0,32439848,DJY,RT,20070616,.,P,150000,21.1,21.4,0,0,.,.,.,.,.,

102480,20070206,NDX,32768,A,E,NDX,CBOE,NASDAQ,100,INDEX,1776.51,1800.05,1793.06,0,-0.001298,1,0,1,0.67359,44205,679332,.,.,.,.,0,32375242,NDU,PM,20070421,.,P,1150000,0,0.2,0,0,0.34478,-0.00124,0.000015,3.291,-2.71,,,

102480,20070206,NDX,32768,A,E,NDX,CBOE,NASDAQ,100,INDEX,1776.51,1800.05,1793.06,0,-0.001298,1,0,1,0.67359,44205,679332,.,.,.,.,0,32375241,NDU,PN,20070421,.,P,1200000,0,0.2,0,0,0.31464,-0.00135,0.000018,3.558,-2.66,,,

102480,20070206,NDX,32768,A,E,NDX,CBOE,NASDAQ,100,INDEX,1776.51,1800.05,1793.06,0,-0.001298,1,0,1,0.67359,44205,679332,.,.,.,.,0,32375237,NDU,PE,20070421,.,P,1225000,0,0.25,0,0,0.3062,-0.0017,0.000022,4.377,-3.2,,,

102480,20070206,NDX,32768,A,E,NDX,CBOE,NASDAQ,100,INDEX,1776.51,1800.05,1793.06,0,-0.001298,1,0,1,0.67359,44205,679332,.,.,.,.,0,32375221,NDT,PG,20070421,20070122,P,1325000,0.25,0.5,0,30,0.27924,-0.00509,0.000066,11.782,-7.74,,,

102480,20070206,NDX,32768,A,E,NDX,CBOE,NASDAQ,100,INDEX,1776.51,1800.05,1793.06,0,-0.001298,1,0,1,0.67359,44205,679332,.,.,.,.,0,32375239,NDU,PO,20070421,.,P,1250000,0.05,0.3,0,0,0.30108,-0.00236,0.000031,5.939,-4.22,,,

109764,20071231,OEX,32768,A,A,S&P,100,INDEX,684.46,689.43,685.65,0,-0.008187,1,0,2,1.95378,17584,216881,.,.,.,.,0,33034304,YOL,XE,20101218,.,P,600000,56.3,58.3,0,0,0.24995,-0.26118,0.001165,371.623,-8,,,,,

109764,20071231,OEX,32768,A,A,S&P,100,INDEX,684.46,689.43,685.65,0,-0.008187,1,0,2,1.95378,17584,216881,.,.,.,.,0,33034306,YOL,XH,20101218,.,P,640000,69.3,71.3,0,0,0.24013,-0.31509,0.001354,402.884,-7.32,,,,,

109764,20071231,OEX,32768,A,A,S&P,100,INDEX,684.46,689.43,685.65,0,-0.008187,1,0,2,1.95378,17584,216881,.,.,.,.,0,33034309,YOL,XO,20101218,.,P,660000,76.7,78.7,0,0,0.23564,-0.34452,0.001449,415.639,-6.82,,,,,

109764,20071231,OEX,32768,A,A,S&P,100,INDEX,684.46,689.43,685.65,0,-0.008187,1,0,2,1.95378,17584,216881,.,.,.,.,0,33034318,YOL,XY,20101218,.,P,680000,84.5,86.5,0,0,0.23091,-0.37576,0.001549,426.484,-6.2,,,,,

109764,20071231,OEX,32768,A,A,S&P,100,INDEX,684.46,689.43,685.65,0,-0.008187,1,0,2,1.95378,17584,216881,.,.,.,.,0,33034314,YOL,XU,20101218,.,P,720000,102,104,0,0,0.22194,-0.44322,0.001749,438.378,-4.58,,,,,

---------------------------------------------

yuanxn

看你数据的变量名的写法，我猜你的数据原来是SAS里 OUT 命令输出的数据。

但上述方法依然不影响数据的转换导出。

secid , date ,.............................

tangyh

数据虽然复杂,不过仔细的观察数据格式,还是可以用简单的input语句读入的. yuanxn 提供的曲线救国方法也可以.