SAS 跑数据遇到问题 ，NOTE: Invalid numeric data，

这是我的log， 里面的“NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.…… 是什么意思？怎么改好？请大虾们帮帮忙：
1024  data car.stkret;
1025  set car.stkret ;
1026  stkr=stkr+0;
1027  run;

NOTE: Character values have been converted to numeric values at the places given by:
      (Line):(Column).
      1026:6
NOTE: Numeric values have been converted to character values at the places given by:
      (Line):(Column).
      1026:10
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503103
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503104
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503105
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503106
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503107
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503108
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503109
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503110
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503111
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503112
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503113
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503114
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503115
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503116
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503117
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503118
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503119
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503120
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503121
NOTE: Invalid numeric data, stkr='Dretnd' , at line 1026 column 6.
ERROR: Limit set by ERRORS= option reached.  Further errors of this type will not be
       printed.
stkcd=Stkcd trddt=Trddt stkret=Dretnd mkttype=Markettype stkr=. _ERROR_=1 _N_=3503122
NOTE: Missing values were generated as a result of performing an operation on missing
      values.
      Each place is given by: (Number of times) at (Line):(Column).
      174 at 1026:10
NOTE: There were 3503276 observations read from the data set CAR.STKRET.
NOTE: The data set CAR.STKRET has 3503276 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           14.04 seconds
      cpu time            13.23 seconds

程序在哪里，我看一下你的程序

suzhzh 发表于 2012-2-19 11:18
程序在哪里，我看一下你的程序

data car.stkret;
set car.stkret ;
stkr=stkr+0;
run;
原先stkr是一个字符型的变量，我想把它变成数值型的，就用了上面的土办法。
当然，归根结底，是为了改变变量的类型，
请问还有什么方法可以实现这个目的？？

你确定stkr这个变量是一定可以转换成数字的？

456852 发表于 2012-2-19 11:46
你确定stkr这个变量是一定可以转换成数字的？

它原来是character。

input函数，讲字符转换成数值

data car.stkret;
set car.stkret ;
stkr_tmp=stkr+0;
rename stkr_tmp=stkr;
run;

这个字段是字符型的，全是字母，为什么考虑把它转成数值型哪，无法理解。。。

一般情况下，比如stkr的值是001,002,003之类的，你转换一下可以成为1,2,3..但是假如这个变量的值是aaa,bbb这种的，没法变成数值，那就只有出缺失值了。这就是楼主为啥看到一大堆note的原因。

freerunning_sky 发表于 2012-2-20 18:43
data car.stkret;
set car.stkret ;
stkr_tmp=stkr+0;

以字符形式存在的数字，明白？