Hi,
I am trying to import data from txt file or csv as follow.
Date Mkt-RF SMB HML RF 19260701 0.10 -0.24 -0.28 0.009 19260702 0.45 -0.32 -0.08 0.009 19260706 0.17 0.27 -0.35 0.009 19260707 0.09 -0.59 0.03 0.009 19260708 0.21 -0.36 0.15 0.009 19260709 -0.71 0.44 0.56 0.009
My code I tried is invalid data with date, even I try different formats for date but it can not run. And I am not sure for the format of mkt-rf, smb, hml, rf are right or not, they should be numeric as interest rate.
Please help. Thank you.
data fff ;
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
infile 'C:\Sirimon\ha\Data\F-F_Research_Data_Factors_daily_csv\F-F_Research_Data_Factors_daily.csv' delimiter=';' MISSOVER DSD lrecl=32767 firstobs=6 ;
informat Date yymmdd8.
mkt_rf $12.
smb $12.
rf $12. ;
format Date yymmdd8.
mkt_rf $12.
smb $12.
rf $12.;
input
Date
mkt_rf
smb
rf
;
if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
run;
... View more