SAS University proc import issue

sioux88 — Thu, 26 Feb 2015 15:18:40 GMT

I am struggling with this oft-asked question about importing a .csv into SAS University.

This works...

data _null_;

infile "/folders/myfolders/book.csv";

input;

put _infile_;

run;

BUT, this fails miserably!

proc import

DATAFILE="/folders/myfolders/book.csv"

OUT = book

DBMS = CSV

GETNAMES = yes;

run;

With this error...

NOTE: The SAS System stopped processing this step because of errors.

44 DATAFILE="/folders/myfolders/book.csv"

45 OUT = book

46 DBMS = CSV

47 GETNAMES = yes;

________

ERROR 22-322: Syntax error, expecting one of the following: ;, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE,

_DEBUG_.

ERROR 76-322: Syntax error, statement will be ignored.

Any help will be appreciated.

Let's Go Sioux!

Re: SAS University proc import issue

RW9 — Thu, 26 Feb 2015 15:35:08 GMT

Two things jump to view, firstly you have not finished the proc statement with a semicolon, second need quotes around yes:

proc import datafile="xyz" out=book dbms=csv;

getnames="yes";

run;

Also, why would you want to use import if the datastep works, you have more control, i.e. don't leave it to import to "guess" what you want to do.