03-09-2015 02:35 PM
I just started my new job and they only use SAS EG on a UNIX server there. The first challenge I met is failure in using proc export/import to/from PC server. The weird thing is the same codes successfully worked on one of my coworkers' computer, and I can export/import without problem if I use wizard.
The error I got for EXPORT is:
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver] The Microsoft Access database engine cannot open or
write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write
ERROR: Error in the LIBNAME statement.
Error: Unable to open file filedirectory\filenname.xlsx.
The error I got for IMPORT is:
It does not exist or it is already opened exclusively by another user or you need permission to view its data.
Anyone who have ran into similar situation or have a clue about this? Thanks!
03-09-2015 02:46 PM
To understand this, you need to understand what runs where.
PROC IMPORT runs in the SAS server session, typically named SASApp. That is probably a remote host session.
Import/export tasks are executed on the EG client.
You need to fins out what's the difference how your colleague EG/server/authisraztion/etc setup differs from yours.
03-09-2015 02:53 PM
One possible explanation is your Unix user account does not have the same permissions as your co-worker. Check with your Unix admin.