topic Why do I keep getting this error message when I try to import my data? in SAS Programming

Why do I keep getting this error message when I try to import my data?

khalillx — Fri, 22 Feb 2019 19:19:15 GMT

I used this command which I always do to import my data:

PROC IMPORT OUT = WORK.one;
DATAFILE= "C:\Users\laura\OneDrive\Documents\econ485\project1data.csv";
DBMS=csv REPLACE;
RUN;

But I'm getting this error message: PROC IMPORT OUT = WORK.one;
ERROR: FILE= or TABLE= is required and must be specified.

But I have specified my file so I'm not sure why I'm getting this error message. I successfully created a libname with my pathway so I know my pathway is fine.

Re: Why do I keep getting this error message when I try to import my data?

VDD — Fri, 22 Feb 2019 19:28:54 GMT

try this

PROC IMPORT DATAFILE= "C:\Users\laura\OneDrive\Documents\econ485\project1data.csv" OUT = WORK.one;
DBMS=csv REPLACE;
RUN;

Re: Why do I keep getting this error message when I try to import my data?

khalillx — Fri, 22 Feb 2019 19:31:28 GMT

it didn't work

Why do I keep getting this error message when I try to import my data? Please help

khalillx — Fri, 22 Feb 2019 19:35:41 GMT

libname session1 "C:\Users\laura\OneDrive\Documents\econ485";

PROC IMPORT OUT= SESSION1;
DATAFILE= "C:\Users\laura\OneDrive\Documents\econ485\project1data.csv";
DBMS=csv REPLACE;
RUN;

ERROR: FILE= or TABLE= is required and must be specified.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

What does this mean? I've used this command so many times and never had this issue. Please help.

Re: Why do I keep getting this error message when I try to import my data?

Kurt_Bremser — Fri, 22 Feb 2019 19:41:39 GMT

WHAT did not work? Please post the log; use the {i} button for this.

Re: Why do I keep getting this error message when I try to import my data?

Kurt_Bremser — Fri, 22 Feb 2019 19:46:40 GMT

You have too many semicolons:

PROC IMPORT
  OUT=WORK.one
  DATAFILE= "C:\Users\laura\OneDrive\Documents\econ485\project1data.csv"
  DBMS=csv
  REPLACE
;
RUN;

Re: Why do I keep getting this error message when I try to import my data? Please help

VDD — Fri, 22 Feb 2019 19:48:42 GMT

writing the code in the expected order would help

please look at this link

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000314361.htm

PROC IMPORT 
DATAFILE= "C:\Users\laura\OneDrive\Documents\econ485\project1data.csv"
OUT= SESSION1
DBMS=csv 
REPLACE;
RUN;

Re: Why do I keep getting this error message when I try to import my data? Please help

Kurt_Bremser — Fri, 22 Feb 2019 19:47:48 GMT

I merged the two identical questions into one thread.