DATA Step, Macro, Functions and more

Can't import Excel file into SAS 9.4

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Can't import Excel file into SAS 9.4

Hi,

I created an excel (.xlsx) file with Office 360. I tried to import this file with the wizard, but the file doesn't show in the saved folder after clicking the browse, even I selected "all files" as the file type.

I also tried to used the code

proc import out=auto_excel

datafile = "D:\Users\xxxxxx\Desktop\school\intro_auto.xlsx"

dbms=excel replace; getnames=yes;

run;

proc print data=auto_excel;

run;


It shows "It does not  exist or it is already opened

       exclusively by another user, or you need permission to view its data."

I unblocked this file in the properties of the file.

What can I do? Help please. 



Accepted Solutions
Solution
‎06-30-2017 12:26 PM
Super User
Posts: 3,260

Re: Can't import Excel file into SAS 9.4

If you are remoting into a server with Citrix then running SAS directly on that server then your spreadsheet would have to sit on a drive accessible by that server.

View solution in original post


All Replies
PROC Star
Posts: 7,487

Re: Can't import Excel file into SAS 9.4

Out of curiosity: are you running SAS on a server and are you referring to the same D drive as the one (if any) that the server recognizes?

New Contributor
Posts: 4

Re: Can't import Excel file into SAS 9.4

Hi Arthur,

I'm running SAS on CitrixReceiver through school's account.

PROC Star
Posts: 7,487

Re: Can't import Excel file into SAS 9.4

When prompted whether you want to provide access to local drives did you click "yes"?.

Here is one faq that might help:

Connecting from Home – WebFAS | Computing @ York

New Contributor
Posts: 4

Re: Can't import Excel file into SAS 9.4

I think I know what the problem is now.

I didn't pay attention last time. When I click browse, it shows the directory of my school id account. i.e. It's the student's account under school's server (windows server 12). Thus, I wasn't browsing local directory. And I couldn't figure out a way to do that yet.

Arthur, I think your input is very relevant. However, I didn't see that prompt. I re-installed CitrixReceiver just in case I missed that part, still no.

Thank you.

Solution
‎06-30-2017 12:26 PM
Super User
Posts: 3,260

Re: Can't import Excel file into SAS 9.4

If you are remoting into a server with Citrix then running SAS directly on that server then your spreadsheet would have to sit on a drive accessible by that server.

Occasional Contributor
Posts: 15

Re: Can't import Excel file into SAS 9.4

Using SAS 9.4 on a 64-bit server, try

dbms=excelcs


🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 2561 views
  • 0 likes
  • 4 in conversation