Cannot Import Data CSV file

vikramuc — Thu, 27 Sep 2018 09:45:00 GMT

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

80 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Cannot Import Data CSV file

Kurt_Bremser — Thu, 27 Sep 2018 10:21:10 GMT

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.

topic Re: Cannot Import Data CSV file in New SAS User

Cannot Import Data CSV file

Re: Cannot Import Data CSV file