topic Re: CSV File Import in SAS Programming

CSV File Import

ayushupadhyay22 — Tue, 14 Mar 2017 22:43:42 GMT

I am trying to import an CSV into SAS university edition. I am using code as mentioned below.

/** FOR CSV Files uploaded from Windows **/

FILENAME CSV "/folders/myfolders/project/Full (6).csv" TERMSTR=CRLF;

/** Import the CSV file. **/

PROC IMPORT DATAFILE=CSV
OUT=orion.MYCSV
DBMS=CSV
REPLACE
RUN;

/** Unassign the file reference. **/

FILENAME CSV;

However the log is showing error I have atteched a screen shot of the log

Kurt_Bremser — Tue, 14 Mar 2017 23:01:49 GMT

The closing semicolon of the proc import statement is missing.

art297 — Tue, 14 Mar 2017 23:21:30 GMT

Like @Kurt_Bremser said rather than the line that says REPLACE it should say REPLACE;

Art, CEO, AnalystFinder.com