Can't import Excel file into SAS 9.4

[Dozel]

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. 

[art297]

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?

[Dozel]

Hi Arthur,

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

[art297]

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

[Dozel]

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.

[SASKiwi · Accepted solution]

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.

[BurntDirt]

Using SAS 9.4 on a 64-bit server, try

dbms=excelcs