I have over 10000 excel files with only one column. Each file starts with:
{\rtf1\ansi {\fonttbl
{\f0\fcharset1 \fnil Times New Roman;}
{\f1\fcharset1 Tahoma;}
}
The first and second row are blank. I am having trouble with "proc import" to read them into SAS. The command I use is:
PROC IMPORT OUT= WORK.step2
DATAFILE= "c:\file1.xls"
DBMS=EXCEL REPLACE;
SHEET="Sheet1$";
GETNAMES=NO;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
I always got missing values. I also tried "libname" and it didn't work. Any suggestions are really appreciated.
... View more
