01-21-2015 12:55 PM
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;
proc print data=auto_excel;
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.
01-21-2015 02:24 PM
When prompted whether you want to provide access to local drives did you click "yes"?.
Here is one faq that might help:
01-21-2015 03:24 PM
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.
01-21-2015 03:53 PM
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.