I am having the same problem. I have sas9.4 t1m4. New install on windows 8.1. MS office 64 bit, sas 64 bit. I can't get it to work with proc import at all. I have tried writing the code and using the wizard - same errors as person who asked first with both. OR, it "runs" w/ DBMS=xlsx and doesn't like any options "ERROR: Import unsuccessful. See SAS Log for details" PROC IMPORT DATAFILE= "path\file.xlsx" OUT= work.newsasfile DBMS=xlsx replace; RANGE="import_data$"; GETNAMES=YES; MIXED=YES; SCANTEXT=YES; RUN; If I take out everything from range down, it runs but can't obviously pick the sheet I need. The following code works, but I want to fix the above regardless. And for this code, I have to specify the range or it does not work... libname inc xlsx "path\file.xlsx"; data inc_area; set inc."import_data$A1:U52"n; run; any suggestions? Thanks!
... View more