excel - Error importing xlsx into SAS -


i trying import tab of spreadsheet sas. using code below.

proc import      datafile="[directories....]\4. media\2. campaign info\tracking_sheet_ja.xlsx"     out=test1      dbms=xlsx replace;     sheet="db_data";          run; 

and error message

error: xlsx file not exist -> [directories....]\4. media\2. campaign info\tracking_sheet_ja.xlsx

i thought might do spaces or . in directory, when pick random file directory , import using same code above works fine. example

proc import      datafile="[directories....]\4. media\2. campaign info\9feb.xlsx"     out=test1      dbms=xlsx replace;     sheet="uk";       run; 

i file extensions , tab references correct. there settings of excel file cause this?

thanks.

there few issues.. 1: else have file open (shared-drive.. assume @ work?). 2: have file open while trying import sas. 3: file name wrong. in excel, file saved underscores? 4: excel permissions can tricky @ work.. if other excel files importing, don't think there should issue, unless maybe has locked file? i'm not sure permissions stuff.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -

jdbc - Not able to establish database connection in eclipse -