I'm trying to import an Excel .xlsx file but keep running into a few problems. I didn't write this code and this is my first time using SAS so step by step instructions are the best for me. This code was written for an on computer version of SAS whereas I am using the University Edition. The PROC IMPORT code I'm using is as follows: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 42 ; 43 PROC IMPORT OUT= WORK.FUTURES REPLACE 44 DATAFILE= "/folders/myfolders/Sugar Beet Steers.xlsx" 45 DBMS=XLS REPLACE; NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 46 RANGE="Sheet1$"; 47 SCANTEXT=YES; ________ 180 48 USEDATE=YES; _______ 180 49 SCANTIME=YES; ________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 50 RUN; Spreadsheet isn't from Excel V5 or later. Please open it in Excel and Save as V5 or later Requested Input File Is Invalid ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.04 seconds cpu time 0.05 seconds 51 ; 52 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 62 ; And the log keeps showing me this: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 42 ; 43 PROC IMPORT OUT= WORK.FUTURES REPLACE 44 DATAFILE= "/folders/myfolders/Sugar Beet Steers.xlsx" 45 DBMS=XLS REPLACE; NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 46 RANGE="Sheet1$"; 47 SCANTEXT=YES; ________ 180 48 USEDATE=YES; _______ 180 49 SCANTIME=YES; ________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 50 RUN; Spreadsheet isn't from Excel V5 or later. Please open it in Excel and Save as V5 or later Requested Input File Is Invalid ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.04 seconds cpu time 0.05 seconds 51 quit; 52 ; 53 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 63 ;
... View more