BookmarkSubscribeRSS Feed
vikramuc
Calcite | Level 5

Using the following code to import csv file in windows 10., Using University edition.

 

IMPORT DATAFILE="C:\Users\Vikram\Documents\Personal\Alabs\SAS\Week1\Class 1\Car_sales.csv"
OUT=WORK.MYCSV
DBMS=CSV
REPLACE;

 

Getting the error message -

ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\Vikram\Documents\Personal\Alabs\SAS\Week1\Class
1\Car_sales.csv.
ERROR: Import unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.13 seconds
cpu time 0.12 seconds
 
79
80 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
93
1 REPLY 1
Kurt_Bremser
Super User

University Edition is a minimal SAS server that runs in a UNIX virtual machine. The only connections to your desktop are the port 10080 (where you go with your browser for the SAS Studio interface) and the shared folder you defined when you set up the VM.

Use the internal UNIX path to that shared folder, which should by /folders/myfolders.

And, of course, place files in the Windows path for that shared folder. All other places are not accessible to UE.

This is covered very well in the tutorials, so work through them.

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

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1153 views
  • 0 likes
  • 2 in conversation