topic Re: import excel file from iCloud in SAS Programming

import excel file from iCloud

vicdicenzo — Mon, 22 Jun 2020 13:59:46 GMT

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.

Re: import excel file from iCloud

Kurt_Bremser — Mon, 22 Jun 2020 14:42:35 GMT

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

Re: import excel file from iCloud

vicdicenzo — Mon, 22 Jun 2020 14:48:33 GMT

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.

Re: import excel file from iCloud

vicdicenzo — Mon, 22 Jun 2020 14:52:10 GMT

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

Re: import excel file from iCloud

Reeza — Mon, 22 Jun 2020 15:47:31 GMT

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

Re: import excel file from iCloud

ChrisNZ — Mon, 22 Jun 2020 21:20:11 GMT

> 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 ].