有谁知道怎么把 character 8. 转换到 numberical date9.,
我用了
effectiveDate2=input(effectiveDate,date9.);
为什么出这个ERROR 48-59: The format $DATE was not found or could not be loaded.
data a;
input effectiveDate $8.;
cards;
20120229
;
run;
data a;
set a;
format effectiveDate2 date9.;
effectiveDate2=mdy(substr(effectiveDate,5,2),substr(effectiveDate,7,2),substr(effectiveDate,1,4));
run;