topic Re: Import CSV file on Mac in New SAS User

Import CSV file on Mac

Kadjere — Thu, 21 May 2020 16:41:39 GMT

I have reviewed many cases on the forum and none seems to solve my problem, Some Background:

1. I have a folder called my folders, defined as folder share

2. When I run this program

Proc import out=cars1
datafile= '//myfolders/cars1.csv' DBMS=CSV replace;
getnames=yes;
datarows = 9;

3. Here is what I get

ERROR: The path //myfolders/cars1.csv is not in the list of accessible paths when SAS is in the lockdown state.

4. Any help will be appreciated and thanks in advance

Re: Import CSV file on Mac

Kurt_Bremser — Thu, 21 May 2020 16:49:20 GMT

The shared folder in UE starts with /folders:

Proc import
  out=cars1
  datafile= '/folders/myfolders/cars1.csv'
  DBMS=CSV
  replace
;

Re: Import CSV file on Mac

Kadjere — Thu, 21 May 2020 17:13:26 GMT

No luck and thanks for your efforts, Here is the error I get :
1. Physical file does not exist, /folders/myfolders/cars1.csv.
2. This is how my shared file is titled on the shared page:
Machine Folders
Transient Folders
Myfolders /user/………………/cars1.csv
Hope this helps and once again thanks for helping. Lots of appreciations.
Bongs

Re: Import CSV file on Mac

Kurt_Bremser — Thu, 21 May 2020 17:38:59 GMT

How is the shared folder configured for the UE virtual machine?

Is the spelling of the filename correct (e.g. Cars1.csv is not equal to cars1.csv)?

Re: Import CSV file on Mac

Reeza — Thu, 21 May 2020 18:09:06 GMT

Go to the Server Folders and Files. Navigate to the file in that pane, right click and select the properties. That will give you the path.

From your recent post it seems like it's now under the 'user' folder, which was not mentioned previously. We cannot see your computer to see the correct path, but if you follow the steps above you should get the full path.

Re: Import CSV file on Mac

Kadjere — Thu, 21 May 2020 21:19:26 GMT

##- Please type your reply above this line. No attach

Re: Import CSV file on Mac

Reeza — Thu, 21 May 2020 21:21:22 GMT

@Kadjere if you intended to reply, it did not come through.