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.
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.
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?
Hi Arthur,
I'm running SAS on CitrixReceiver through school's account.
When prompted whether you want to provide access to local drives did you click "yes"?.
Here is one faq that might help:
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.
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.
Using SAS 9.4 on a 64-bit server, try
dbms=excelcs
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.