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:
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