topic ERROR: physical file does not exist: PROC IMPORT DATAFILE in SAS Procedures

ERROR: physical file does not exist: PROC IMPORT DATAFILE

mspswede — Wed, 14 Aug 2019 01:03:32 GMT

Hi, another Newbie here. Trying to import a csv file - I've checked other posts/solutions and verified filepath and that it has headings in row 1, data starts in row 2.

Here's my code:

PROC IMPORT DATAFILE="C:\Users\John\Desktop\MSDA\C744-Data Mining II\TelcoCustChurn.csv"
DBMS=CSV OUT=pg2.TelcoCustChurn REPLACE;
GUESSINGROWS=7045;
RUN;

I"m getting this in the log:

ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp

Thanks for any help and tips!

Re: ERROR: physical file does not exist: PROC IMPORT DATAFILE

Reeza — Wed, 14 Aug 2019 01:17:40 GMT

Are you using SAS UE?

Re: ERROR: physical file does not exist: PROC IMPORT DATAFILE

mspswede — Wed, 14 Aug 2019 01:19:12 GMT

No, SAS Studio - I should have noted that in my post!

Re: ERROR: physical file does not exist: PROC IMPORT DATAFILE

Reeza — Wed, 14 Aug 2019 01:25:29 GMT

SAS UE is also SAS Studio. Ok, it looks like you're using SAS on a server, so it will likely not have access to your local drive. You need to upload your files to the server and then use them. In Studio go to the files/folders/panes and upload your file and then get the path and try and import it again.

Re: ERROR: physical file does not exist: PROC IMPORT DATAFILE

mspswede — Wed, 14 Aug 2019 01:30:28 GMT

Fantastic - it worked! Thanks very much for your help.

Best regards