topic Re: How do I run a proc contents here in SAS Programming

How do I run a proc contents here

khalillx — Fri, 22 Feb 2019 20:29:54 GMT

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.

Re: How do I run a proc contents here

PaigeMiller — Fri, 22 Feb 2019 20:36:20 GMT

@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??

Re: How do I run a proc contents here

Reeza — Fri, 22 Feb 2019 20:52:02 GMT

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.

Re: How do I run a proc contents here

khalillx — Fri, 22 Feb 2019 20:52:54 GMT

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

Re: How do I run a proc contents here

SASKiwi — Fri, 22 Feb 2019 20:58:43 GMT

Please post the complete log of your program.

Re: How do I run a proc contents here

khalillx — Fri, 22 Feb 2019 20:59:25 GMT

I did.

Re: How do I run a proc contents here

PaigeMiller — Fri, 22 Feb 2019 20:59:59 GMT

@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.

Re: How do I run a proc contents here

Kurt_Bremser — Sat, 23 Feb 2019 07:49:25 GMT

@khalillx wrote:
I did.

No, you did not. You just posted code, not logs.

If you are unwilling to help us, how shall we help you?

Re: How do I run a proc contents here

khalillx — Sat, 23 Feb 2019 17:52:41 GMT

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.

Re: How do I run a proc contents here

PaigeMiller — Sat, 23 Feb 2019 19:23:12 GMT

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.

Re: How do I run a proc contents here

Satish_Parida — Mon, 25 Feb 2019 09:06:29 GMT

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.