thanks so much, the best thing s to run the dataset:) cus i have already confused here for like the whole morning. thanks so much. looking forward further information:)
用了一个比较笨的办法求出了时间间隔,大家可以看看code是否有问题:
data a;
set 'C:\Users\feng\Desktop\haw project\sas assi\rawdata8.sas7bdat';
data = compress(Capital_IQ_Transaction_Screening, '/');
date= input (Capital_IQ_Transaction_Screening, mmddyy10.) ;
informat date mmddyy10.;
drop Capital_IQ_Transaction_Screening;
run;
data a;
set a;
data1 = compress(var8, '/');
date1= input (var8, mmddyy10.) ;
informat date1 mmddyy10.;
drop var8;
run;
data a;
set a;
time=date1-date;
run;
但是还是有保留问题,怎么把01/02/2009保留成2009.
把6769 financial service这样的变量只保留前两位变成67?
谢谢各位牛牛:)