1 PROC IMPORT OUT= WORK.b1 2 DATAFILE= "D:\Pap10501_CGMA\test\dRI1.xlsx" 3 DBMS=EXCEL REPLACE; 4 RANGE="Sheet1$"; 5 GETNAMES=NO; 6 MIXED=NO; 7 SCANTEXT=YES; 8 USEDATE=YES; 9 SCANTIME=YES; 10 RUN; NOTE: create WORK.B1 dataset。 NOTE: dataset WORK.B1 has 3693 observations and 255 variables. Actually, excel file has 2000 columns.
... View more