topic Re: Can't import Excel file into SAS 9.4 in SAS Programming

Can't import Excel file into SAS 9.4

Dozel — Wed, 21 Jan 2015 17:55:45 GMT

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.

Re: Can't import Excel file into SAS 9.4

art297 — Wed, 21 Jan 2015 18:56:04 GMT

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?

Re: Can't import Excel file into SAS 9.4

Dozel — Wed, 21 Jan 2015 19:02:17 GMT

Hi Arthur,

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

Re: Can't import Excel file into SAS 9.4

art297 — Wed, 21 Jan 2015 19:24:42 GMT

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

Re: Can't import Excel file into SAS 9.4

BurntDirt — Wed, 21 Jan 2015 19:59:19 GMT

Using SAS 9.4 on a 64-bit server, try

dbms=excelcs

Re: Can't import Excel file into SAS 9.4

Dozel — Wed, 21 Jan 2015 20:24:41 GMT

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.

Re: Can't import Excel file into SAS 9.4

SASKiwi — Wed, 21 Jan 2015 20:53:20 GMT

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.