ERROR: Physical file does not exist

[Robert_Klein_ND]

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

[Reeza · Accepted solution]

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.

[Robert_Klein_ND]

Thanks! Nice fast solution. Works great.