BookmarkSubscribeRSS Feed
khalillx
Fluorite | Level 6

This is all my code: 

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

 

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

 

proc print data=one;
run;

 

I tried doing this:

proc contents data=WORK.one;

run;

 

But I got an error message saying that work.one.data does not exist.

I have no idea what to do.

10 REPLIES 10
PaigeMiller
Diamond | Level 26

@khalillx wrote:

This is all my code: 

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

 

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

 

proc print data=one;
run;

 

I tried doing this:

proc contents data=WORK.one;

run;

 

But I got an error message saying that work.one.data does not exist.

I have no idea what to do.


Perhaps there's an error in the SASLOG, indicating that work.one did not get created??

--
Paige Miller
Reeza
Super User


Check your full log. Most likely you have another warning or error further up that is causing the issue. You should be testing your code step by step.

 

 

khalillx
Fluorite | Level 6
I am testing it step by step and there have been no errors up until now.
SASKiwi
PROC Star

Please post the complete log of your program.

khalillx
Fluorite | Level 6
I did.
khalillx
Fluorite | Level 6
haha relax are you serious? why would I be unwilling to help when I want help. I'm new to SAS so I clearly don't know what I'm doing.
PaigeMiller
Diamond | Level 26

At least four people have asked to see your LOG. You haven't shown it to us, despite you saying that you did. This prevents us from helping you further.

 

Here is my earlier request in this thread, where specific instructions are given for how to provide the LOG to us.

Please show us the entire SASLOG for this program. Click on the {i} icon and paste the SASLOG into the window that appears. Do not skip this step.

--
Paige Miller
PaigeMiller
Diamond | Level 26

@khalillx wrote:
I am testing it step by step and there have been no errors up until now.

Please show us the entire SASLOG for this program. Click on the {i} icon and paste the SASLOG into the window that appears. Do not skip this step.

--
Paige Miller
Satish_Parida
Lapis Lazuli | Level 10

As mentioned in a earlier thread your proc import procedure is failing ERROR: file in Use.
So I will suggest you to close the file is opened by any other user or by your self in any other application, or may be restart SAS session and check again.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 10 replies
  • 1029 views
  • 0 likes
  • 6 in conversation