SAS中文论坛

标题: how to convert character date values into numeric in sas [打印本页]

作者: shiyiming    时间: 2009-3-26 11:38
标题: how to convert character date values into numeric in sas
data a;
  input adate $9.;
   datalines;
19-jan-08
12-sep-08
;
run;
  
  data convert;
      set a;
     date = input(adate,anydtdte9.);
    format date date7.;
  run;

/* you can modify it by your date type
作者: Qiong    时间: 2009-3-27 17:22
标题: Re: how to convert character date values into numeric in sas
第二段里把format语句去掉。
或者直接

data convert;
set a;
date = input(adate,date9.);
run;
作者: shiyiming    时间: 2009-3-28 20:51
标题: Re: how to convert character date values into numeric in sas
data a;
input adate $9.;
datalines;
19-jan-08
12-sep-08
;
run;

data convert(drop=ccc);
set a(rename=(adate=ccc);
adate=input(ccc,anydtdte9.);
run;




欢迎光临 SAS中文论坛 (https://mysas.net/forum/) Powered by Discuz! X3.2