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.