import excel file from iCloud

[vicdicenzo]

I am trying to import an Excel file.  The file is in this folder:

/Users/victordicenzo/Documents/SASUniversityEdition/myfolders/2019/RAND2011

This is my code:

/** Import an XLSX file.  **/

PROC IMPORT DATAFILE="/Users/victordicenzo/Documents/SASUniversityEdition/myfolders/2019/RAND2011/COVER11.XLSX"

   OUT=WORK.COVER11

   DBMS=XLSX

   REPLACE;

RUN;

This is my error message:

ERROR: The path

/Users/victordicenzo/Documents/SASUniversityEdition/myfolders/2019/RAND2011/EFFORT11.XLSX is

not in the list of accessible paths when SAS is in the lockdown state.

I have done this numerous times, did not change anything, but have never seen this error.  Is this because the files are now on iCloud?  I appreciate any help.

[Kurt_Bremser]

This can never have worked in University Edition. The path to the shared folder has always been /folders/myfolders.

[vicdicenzo]

Correct. When I tried to import a new Excel file from my MacBook, I went to Finder and right clicked to "Get Info" then copied that path into SAS which gave me that error message.  I realized that it was different and put the code as you suggested and it gave the same error.  Thats when I reached out to the community for assistance.

[ChrisNZ]

>  then copied that path into SAS 

The MacOS path and the path visible from inside the SAS UE VM are different.

Doing this will never work.

Which also means it cannot [have worked before and nothing changed ].

[vicdicenzo]

But your comment did help so thanks, I appreciate it.

[Reeza · Accepted solution]

If your question is answered, please post the solution and close this thread.