Hi, I tried exactly the same syntax that you posted and got error messages highlighting the "=" in the "dbms=excel" Would appreciate help with what I need to change. Thank you! NOTE 137-205: Line generated by the invoked macro "IMPORT". 35 proc import datafile="&&filename&i" out=&&dsn&i dbms=excel replace; - 22 35 ! getnames=yes; mixed=yes; 35 ! run; ERROR 22-322: Syntax error, expecting one of the following: DATAFILE, DATATABLE, DBMS, FILE, OUT, TABLE. NOTE: Line generated by the invoked macro "IMPORT". 35 proc import datafile="&&filename&i" out=&&dsn&i dbms=excel replace; - 76 35 ! getnames=yes; mixed=yes; 35 ! run; ERROR 76-322: Syntax error, statement will be ignored.
... View more