建立数据集问题，高手请阅！

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

我用如下程序建立数据集a：

1. 
   
2. data a;
   
3. input name$ x1-x8@@;
   
4. cards;
   
5. 北  京 2808.92 654.36 1798.88 528.00 1132.09 960.41 867.87 147.06
   
6. 天  津 1848.11 324.63 674.67 187.83 481.27 371.85 299.79 85.01
   
7. 河  北 1195.65 217.82 796.62 170.40 350.92 263.53 289.27 65.55
   
8. 山  西 1224.60 283.20 584.07 156.27 324.89 416.94 240.94 73.85
   
9. 内蒙古 1578.57 271.88 609.29 148.03 466.34 390.85 416.87 86.59
   
10. 辽  宁 1563.33 335.93 793.91 185.50 416.41 437.79 409.64 111.53
    
11. 吉  林 1371.12 286.97 737.07 168.36 355.99 376.76 511.50 95.12
    
12. 黑龙江 1331.07 345.69 946.84 161.03 427.35 496.42 434.25 98.62
    
13. 上  海 3639.14 496.14 2102.96 480.62 1212.38 942.76 738.94 191.44
    
14. 江  苏 2275.28 306.62 969.76 286.37 691.56 818.45 322.99 133.42
    
15. 浙  江 2812.39 473.11 1488.95 374.31 968.17 843.34 609.07 162.36
    
16. 安  徽 1494.19 203.37 813.12 229.66 302.23 312.05 227.10 73.30
    
17. 福  建 2304.14 291.72 821.21 260.68 570.24 421.69 219.02 127.02
    
18. 江  西 1609.20 162.58 725.11 181.91 295.76 254.77 232.78 70.53
    
19. 山  东 1618.66 265.59 945.81 273.77 533.55 399.95 301.55 78.30
    
20. 河  南 1220.36 225.64 875.83 203.81 310.11 234.01 242.87 75.85
    
21. 湖  北 1668.35 195.45 702.62 229.32 307.22 281.68 236.31 104.29
    
22. 湖  南 1967.54 182.46 691.59 203.65 341.27 291.01 258.07 85.30
    
23. 广  东 2425.55 192.68 946.14 206.36 558.78 296.72 232.00 161.58
    
24. 广  西 1572.82 91.82 677.92 157.93 275.57 192.54 205.16 57.37
    
25. 海  南 1639.34 108.03 348.50 132.19 357.29 287.85 129.26 86.10
    
26. 重  庆 1542.12 198.60 406.36 209.37 260.33 237.38 242.60 45.38
    
27. 四  川 1740.59 197.06 1138.72 219.63 324.05 206.67 258.13 56.55
    
28. 贵  州 1093.94 125.35 588.42 115.39 175.08 151.59 133.15 39.03
    
29. 云  南 1410.00 137.19 496.66 147.80 313.26 177.66 197.55 44.73
    
30. 西  藏 1190.01 266.73 383.20 148.62 224.83 61.14 71.50 53.45
    
31. 陕  西 1175.29 208.00 697.43 195.92 300.32 380.38 329.26 62.63
    
32. 甘  肃 1142.05 157.29 648.63 142.72 237.92 217.35 180.09 40.40
    
33. 青  海 1164.07 224.73 820.84 132.54 341.13 173.75 291.34 61.00
    
34. 宁  夏 1395.42 256.26 501.75 169.01 365.59 217.21 356.39 86.32
    
35. 新  疆 1225.93 261.26 514.72 107.28 319.39 158.13 316.55 47.37
    
36. ;
    
37. run;

复制代码

可是没有建立成功。

log窗口里面说的是：
NOTE: Copyright (c) 2002 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Version 9.00 (TS M0)
      Licensed to SUNY AT STONY BROOK, Site 0013402001.
NOTE: This session is executing on the XP_PRO  platform.

NOTE: SAS initialization used:
      real time           0.67 seconds
      cpu time            0.57 seconds
1    data a;
2     input name$ x1-x8@@;
3    cards;
NOTE: Invalid data for x1 in line 4 6-7.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----
4           北  京 2808.92 654.36  1798.88 528.00  1132.09 960.41  867.87  147.06
name=北 x1=. x2=2808.92 x3=654.36 x4=1798.88 x5=528 x6=1132.09 x7=960.41 x8=867.87 _ERROR_=1 _N_=1
NOTE: Invalid data for x1 in line 5 2-3.
NOTE: Invalid data for x2 in line 5 6-7.
5           天  津 1848.11 324.63  674.67  187.83  481.27  371.85  299.79  85.01
name=147.06 x1=. x2=. x3=1848.11 x4=324.63 x5=674.67 x6=187.83 x7=481.27 x8=371.85 _ERROR_=1 _N_=2
NOTE: Invalid data for x2 in line 6 2-3.
NOTE: Invalid data for x3 in line 6 6-7.
6           河  北 1195.65 217.82  796.62  170.40  350.92  263.53  289.27  65.55
name=299.79 x1=85.01 x2=. x3=. x4=1195.65 x5=217.82 x6=796.62 x7=170.4 x8=350.92 _ERROR_=1 _N_=3
NOTE: Invalid data for x3 in line 7 2-3.
NOTE: Invalid data for x4 in line 7 6-7.
7           山  西 1224.60 283.20  584.07  156.27  324.89  416.94  240.94  73.85
name=263.53 x1=289.27 x2=65.55 x3=. x4=. x5=1224.6 x6=283.2 x7=584.07 x8=156.27 _ERROR_=1 _N_=4
NOTE: Invalid data for x4 in line 8 2-7.
8           内蒙古 1578.57 271.88  609.29  148.03  466.34  390.85  416.87  86.59
name=324.89 x1=416.94 x2=240.94 x3=73.85 x4=. x5=1578.57 x6=271.88 x7=609.29 x8=148.03 _ERROR_=1
_N_=5
NOTE: Invalid data for x4 in line 9 2-3.
NOTE: Invalid data for x5 in line 9 6-7.
9           辽  宁 1563.33 335.93  793.91  185.50  416.41  437.79  409.64  111.53
name=466.34 x1=390.85 x2=416.87 x3=86.59 x4=. x5=. x6=1563.33 x7=335.93 x8=793.91 _ERROR_=1 _N_=6
NOTE: Invalid data for x5 in line 10 2-3.
NOTE: Invalid data for x6 in line 10 6-7.
10          吉  林 1371.12 286.97  737.07  168.36  355.99  376.76  511.50  95.12
name=185.50 x1=416.41 x2=437.79 x3=409.64 x4=111.53 x5=. x6=. x7=1371.12 x8=286.97 _ERROR_=1 _N_=7
NOTE: Invalid data for x6 in line 11 2-7.
11          黑龙江 1331.07 345.69  946.84  161.03  427.35  496.42  434.25  98.62
name=737.07 x1=168.36 x2=355.99 x3=376.76 x4=511.5 x5=95.12 x6=. x7=1331.07 x8=345.69 _ERROR_=1
_N_=8
NOTE: Invalid data for x6 in line 12 2-3.
NOTE: Invalid data for x7 in line 12 6-7.
12          上  海 3639.14 496.14  2102.96 480.62  1212.38 942.76  738.94  191.44
name=946.84 x1=161.03 x2=427.35 x3=496.42 x4=434.25 x5=98.62 x6=. x7=. x8=3639.14 _ERROR_=1 _N_=9
NOTE: Invalid data for x7 in line 13 2-3.
NOTE: Invalid data for x8 in line 13 6-7.
13          江  苏 2275.28 306.62  969.76  286.37  691.56  818.45  322.99  133.42
name=496.14 x1=2102.96 x2=480.62 x3=1212.38 x4=942.76 x5=738.94 x6=191.44 x7=. x8=. _ERROR_=1 _N_=10
NOTE: Invalid data for x8 in line 14 2-3.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----
14          浙  江 2812.39 473.11  1488.95 374.31  968.17  843.34  609.07  162.36
name=2275.28 x1=306.62 x2=969.76 x3=286.37 x4=691.56 x5=818.45 x6=322.99 x7=133.42 x8=. _ERROR_=1
_N_=11
NOTE: Invalid data for x1 in line 15 6-7.
15          安  徽 1494.19 203.37  813.12  229.66  302.23  312.05  227.10  73.30
name=安 x1=. x2=1494.19 x3=203.37 x4=813.12 x5=229.66 x6=302.23 x7=312.05 x8=227.1 _ERROR_=1 _N_=13
NOTE: Invalid data for x1 in line 16 2-3.
NOTE: Invalid data for x2 in line 16 6-7.
16          福  建 2304.14 291.72  821.21  260.68  570.24  421.69  219.02  127.02
name=73.30 x1=. x2=. x3=2304.14 x4=291.72 x5=821.21 x6=260.68 x7=570.24 x8=421.69 _ERROR_=1 _N_=14
NOTE: Invalid data for x2 in line 17 2-3.
NOTE: Invalid data for x3 in line 17 6-7.
17          江  西 1609.20 162.58  725.11  181.91  295.76  254.77  232.78  70.53
name=219.02 x1=127.02 x2=. x3=. x4=1609.2 x5=162.58 x6=725.11 x7=181.91 x8=295.76 _ERROR_=1 _N_=15
NOTE: Invalid data for x3 in line 18 2-3.
NOTE: Invalid data for x4 in line 18 6-7.
18          山  东 1618.66 265.59  945.81  273.77  533.55  399.95  301.55  78.30
name=254.77 x1=232.78 x2=70.53 x3=. x4=. x5=1618.66 x6=265.59 x7=945.81 x8=273.77 _ERROR_=1 _N_=16
NOTE: Invalid data for x4 in line 19 2-3.
NOTE: Invalid data for x5 in line 19 6-7.
19          河  南 1220.36 225.64  875.83  203.81  310.11  234.01  242.87  75.85
name=533.55 x1=399.95 x2=301.55 x3=78.3 x4=. x5=. x6=1220.36 x7=225.64 x8=875.83 _ERROR_=1 _N_=17
NOTE: Invalid data for x5 in line 20 2-3.
NOTE: Invalid data for x6 in line 20 6-7.
20          湖  北 1668.35 195.45  702.62  229.32  307.22  281.68  236.31  104.29
name=203.81 x1=310.11 x2=234.01 x3=242.87 x4=75.85 x5=. x6=. x7=1668.35 x8=195.45 _ERROR_=1 _N_=18
NOTE: Invalid data for x6 in line 21 2-3.
NOTE: Invalid data for x7 in line 21 6-7.
21          湖  南 1967.54 182.46  691.59  203.65  341.27  291.01  258.07  85.30
name=702.62 x1=229.32 x2=307.22 x3=281.68 x4=236.31 x5=104.29 x6=. x7=. x8=1967.54 _ERROR_=1 _N_=19
NOTE: Invalid data for x7 in line 22 2-3.
NOTE: Invalid data for x8 in line 22 6-7.
22          广  东 2425.55 192.68  946.14  206.36  558.78  296.72  232.00  161.58
name=182.46 x1=691.59 x2=203.65 x3=341.27 x4=291.01 x5=258.07 x6=85.3 x7=. x8=. _ERROR_=1 _N_=20
NOTE: Invalid data for x8 in line 23 2-3.
ERROR: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
23          广  西 1572.82 91.82   677.92  157.93  275.57  192.54  205.16  57.37
name=2425.55 x1=192.68 x2=946.14 x3=206.36 x4=558.78 x5=296.72 x6=232 x7=161.58 x8=. _ERROR_=1
_N_=21
NOTE: LOST CARD.
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.A has 34 observations and 9 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.01 seconds

35   ;
36   run;


烦请高手指点一二！！！

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：数据集 observations observation Proprietary statement 高手 数据集

-INPUT 语句中@@没必要;
-去掉NAME值中的空格, 如改"北  京"成"北京"
-应该没问题,除非你的系统有毛病.

goldbaodi 发表于 2011-6-12 14:58
-INPUT 语句中@@没必要;
-去掉NAME值中的空格, 如改"北  京"成"北京"
-应该没问题,除非你的系统有毛病.

thaks  ,,00000000000000

将变量name的宽度设置为6，同时取消@@。
input name $6. x1-x8;