thanks for reply. still no luck. here is log below :- 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 PROC IMPORT OUT= WORK.EMPLOYEE 57 DATAFILE= "E:\LDATA\DATA1.xlsx" 58 DBMS=XLSX REPLACE ; NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 59 GETNAMES=YES; 60 MIXED=NO; _____ 180 61 SCANTEXT=YES; ________ 180 62 USEDATE=YES; _______ 180 63 SCANTIME=YES; ________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 64 RUN; ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/E:\LDATA\/DATA1.xlsx. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 65 66 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 78
... View more
