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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.