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 Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

SAS Training: Just a Click Away

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

Browse our catalog!

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