BookmarkSubscribeRSS Feed
u64147357
Calcite | Level 5

Hi SAS Community,

 

I'm new to SAS University Edition and I'm having trouble importing a CSV file. I keep getting the error message "ERROR: Physical file does not exist" even though I've confirmed that the file exists at the specified location.

Here's the code I'm using:

SAS
 
PROC IMPORT DATAFILE="C:\Users\rakes\OneDrive\Desktop\mydata.csv"
    OUT=mydata 
    DBMS=CSV REPLACE;
    GETNAMES=YES;
RUN;

I've double-checked the file path and made sure the file is not read-only. I've also tried running SAS as administrator, but the error persists.

I noticed that the error message shows a different path (/pbr/biconfig/940/Lev1/SASApp/...) which I believe is related to the virtual machine environment. I'm not sure how to access or modify files in that location.

Could someone please help me understand why this error is occurring and how to resolve it? Do I need to configure something in the virtual machine settings or is there a different way to specify the file path?

Any guidance would be greatly appreciated!

Thanks,

Rakesh

1 REPLY 1
Tom
Super User Tom
Super User

SAS University Edition no longer exists.

Are talking about using SAS ODA?  That runs on a server at SAS.COM and you interface with it using a browser.  The SAS server cannot see files on your PC.  You will need to upload the file and then use the path it has on the SAS server in your code.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 628 views
  • 3 likes
  • 2 in conversation