BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Robert_Klein_ND
Fluorite | Level 6

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

2 REPLIES 2
Reeza
Super User

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
Fluorite | Level 6

Thanks! Nice fast solution. Works great.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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