05-22-2016 03:31 PM
I am novice to SAS.Though have seen same post earlier but didn't helped me.
/** FOR CSV Files uploaded from Windows **/
FILENAME CSV "/folders/myfolders/Study1/wine.csv" TERMSTR=CRLF;
/** Import the CSV file. **/
PROC IMPORT DATAFILE=CSV
/** Print the results. **/
PROC PRINT DATA=WORK.MYCSV; RUN;
/** Unassign the file reference. **/
According to me everything is same as in video tutorial explained but am getting error message
Please note: i am using the most recent version of virtualBox.
05-22-2016 04:33 PM
05-22-2016 04:34 PM
Try the following, also make sure that the case of the file is all lower case as Unix is case sensitive.
/** Import the CSV file. **/ PROC IMPORT DATAFILE="/folders/myfolders/Study1/wine.csv" OUT=WORK.MYCSV DBMS=CSV REPLACE; RUN; /** Print the results. **/ PROC PRINT DATA=WORK.MYCSV; RUN;
05-24-2016 02:13 PM
I get the error shown in your attachment when I try to read a file with unix end of line characters, LF, with windows end of lines, CRLF. I would try TERMSTR=LF in the filename.