SAS University proc import issue

Accepted Solution Solved
Reply
N/A
Posts: 1
Accepted Solution

SAS University proc import issue

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;

  ________

  22

  76

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!


Accepted Solutions
Solution
‎02-26-2015 10:35 AM
Esteemed Advisor
Esteemed Advisor
Posts: 7,253

Re: SAS University proc import issue

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.

View solution in original post


All Replies
Solution
‎02-26-2015 10:35 AM
Esteemed Advisor
Esteemed Advisor
Posts: 7,253

Re: SAS University proc import issue

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 414 views
  • 0 likes
  • 2 in conversation