Hey! Thanks again for the help on this proc import statement. My only issue now is that with the guessing rows max statement, the running time is very very slow. Are there any alternatives? I tried instead going through the rows by the thousands always got the same error message. Here's my code again: /*import csrp dataset*/
PROC IMPORT out=paper.CSRP_Monthly_Stock
datafile="~/425/425_Final_Paper/CSRP_MonthlyStock.csv"
DBMS=CSV replace;
getnames= yes;
/*guessingrows=max;*/
run; I had the same issue with my other data set, but I fixed this by doing the following (again, this didn't work for the CSRP dataset): PROC IMPORT out=paper.CompuStat_Execucomp
datafile="~/425/425_Final_Paper/CompuStat_Execucomp.csv"
DBMS=CSV replace;
getnames= yes;
guessingrows=2000;
run;
... View more
