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
Post a Comment