topic Re: ERROR: Physical file does not exist in SAS Procedures

ERROR: Physical file does not exist

Robert_Klein_ND — Wed, 14 Feb 2018 01:16:56 GMT

Hello all.

I am trying to import a .csv file using SAS 9.4 and very simple code:

PROC IMPORT
DATAFILE= "DATA combined.csv"
OUT= Work.ONe
REPLACE;
RUN;

I am receiving the following error:

ERROR: Physical file does not exist, G:\My Drive\Robinson Lab\4. THESIS PROJECT\Data
Results\DATA combined.csv.
ERROR: Import unsuccessful. See SAS Log for details.

Problematically, the file path is correct. I just started using Google Drive's "file stream" service, and maybe this makes a difference? If I copy the entire folder to my desktop, it imports without error.

Does anyone know how to fix this problem?

Thanks! Robbie

Re: ERROR: Physical file does not exist

Reeza — Wed, 14 Feb 2018 03:00:51 GMT

I don't have any issues with Box or Google Drive. Is that the G path on your drive? Best way to get it, is to navigate to file, hold down SHIFT and Right Click, then select Copy as Path and paste that into the Filename reference. This assumes that you've installed Google Drive within your OS. If you're using an Enterprise version that's more of a shared network it may be different.

filename myfile 'G:\My Drive\Robinson Lab\4. THESIS PROJECT\Data Results\DATA combined.csv';
PROC IMPORT OUT=One
DATAFILE= myfile
dbms=csv
REPLACE; 
RUN;

PS. Don't put period in your folder names, it's a recipe for issues down the road for a multitude of reasons.

Re: ERROR: Physical file does not exist

Robert_Klein_ND — Wed, 14 Feb 2018 16:20:12 GMT

Thanks! Nice fast solution. Works great.