07-24-2017 10:06 AM - last edited on 07-24-2017 11:20 AM by ChrisHemedinger
I am trying to import a CSV file, here's the code I used
proc import datafile="\\Mac\Home\Downloads\cars_novname.csv"
out=mydata dbms=csv replace;
When I execute I get this error message "Physical file does not exist........." import unsuccessful.
The file is very much there in the path.
07-24-2017 10:11 AM
When SAS says "physical file does not exist", then it isn't there, period.
You may have a situation where you can "see" the file from your desktop, but the SAS process on the SAS server can't.
Tell us a little about your SAS setup (servers, operating systems)
07-24-2017 10:54 AM
Are you using SAS UE? If so, please read the instructions on how to access a CSV file from University Edition.
You have to kind of follow the links to get to the solution but it's buried here:
In general, place the file in your myfolders created at set up, then navigate to that folder in SAS UE using Server Files & Folders Pane. Then right click the file and under properties it will have the full path.
07-25-2017 07:01 AM
Just to clarify ai am not accessing a CSV file fro UE, I pasted the code I found on google.
I tweaked the code to pick the file from Shared drive
Then we need the answer to my previous post.