05-13-2016 10:17 AM
Yes, with the Excel engine, the syntax is:
libname xl Excel "c:\yourdir\yourFile.xlsx" access=readonly header=no;
05-13-2016 11:50 AM
With the Excel engine, no (things might be different with the new xlsx engine, which I haven't tested.) The type of data columns is based on a scan to the first few lines of data. Assigning a format, even to empty cells, is often enough to get the correct column type.
05-23-2016 06:28 PM
Another related question,
I have imported xls workbooks (the same one) a number of times sucessfully and now I am getting the following message:
ERROR: File _IMEX_.'a$a27:r3000'n.DATA does not exist.
ERROR: Import unsuccessful. See SAS Log for details.
It does not happen all the time but sometimes. Any thoughts as to the cause? Network communication issues, perhaps?
Need further help from the community? Please ask a new question.