Help using Base SAS procedures

ERROR: Physical file does not exist

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

ERROR: Physical file does not exist

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

 

 


Accepted Solutions
Solution
‎02-14-2018 11:19 AM
Super User
Posts: 23,776

Re: ERROR: Physical file does not exist

Posted in reply to Robert_Klein_ND

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.

View solution in original post


All Replies
Solution
‎02-14-2018 11:19 AM
Super User
Posts: 23,776

Re: ERROR: Physical file does not exist

Posted in reply to Robert_Klein_ND

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.

Occasional Contributor
Posts: 7

Re: ERROR: Physical file does not exist

Thanks! Nice fast solution. Works great.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 298 views
  • 0 likes
  • 2 in conversation