topic Re: IMPORT EXCEL FILE USING PROC IMPORT in SAS Procedures

IMPORT EXCEL FILE USING PROC IMPORT

AlexeyS — Thu, 10 Jan 2019 12:19:41 GMT

Hello, I want to import xls/xlsx file using proc import.

PROC IMPORT OUT= WORK.auto1 DATAFILE= "C:\test.xls" 
            DBMS=xls REPLACE; 
            GETNAMES=YES;
	    GUESSINGROWS=100;
            SCANTEXT=YES;                                                                                                                                                                   
RUN;

My question is why I can't use options SCANTEXT / USEDATA / SCANTIME ?

I want to read excel formats.

Thank you

Re: IMPORT EXCEL FILE USING PROC IMPORT

Kurt_Bremser — Thu, 10 Jan 2019 13:01:52 GMT

From the documentation I take it that those are not stand-alone statements, but options that have to be part of the proc import statement.

Re: IMPORT EXCEL FILE USING PROC IMPORT

Tom — Thu, 10 Jan 2019 13:12:21 GMT

Because you not reading from a text file.