如何导入excel中的时间日期变量

9# baoaibaobao
能不能详解一下strip（）函数的用法哦？找了下没找到。。

11# sunquan3075 http://blog.sina.com.cn/s/blog_6e0a03730100mxsn.html

我也遇到相似的问题。后来找到了一个方法，你不妨试试看，用工具栏的图标导入，相信你这一点也试过，这里是关键在于在选择导入excel格式的时候，在下拉框中要选择excel5……7（大概是怎么个东东），不要选择excel2000……这一项。

9#baoaibaobao
could you tell me what type is the variable b in the put function?
I tried with the above code, but the log reported that my variable ‘rpt_pr' had already been defined as numeric, so that it cannot been changed to char.! but isn't put function used to do such transfer?

following is my code:
"year=input(substr(strip(put(rpt_pr,$12.)),1,4),4.);"

proc import out=a
datafile='f:\riqi.xls'
dbms=excel2010
replace;
run;

data c;
set a(keep=ri);
format ri yymmdd10.;
informat ri yymmdd10.;
run;
貌似这样就可以导入，注意输入输出格式

使用的是这个文件