topic Re: File Does Not Exist But It does in SAS Enterprise Guide

File Does Not Exist But It does

mmagnuson — Fri, 06 Oct 2017 13:35:53 GMT

I needed to edit a dataset in a program so I imported an excel document called import then ran a query/join to query the data set. Then, I pointed that code to the next line of the program.

I imported it and under properties it shows GRIDWORK.IMPORT.

Proc SQL:

Create Table Gridwork.Query_B AS

SELECT t1.First_Name,

t1.Last_Name,

(Case when t1.First_Name=t2.First_Name then "Y" end)

AS 'Yes_or_No'n

FROM Girdwork.Query_A t1

LEFT JOIN GRIDWORK.IMPORT t2 ON (t1.First_Name=t2.First_Name);

quit;

When I run this code it says "File GRIDWORK.IMPORT.DATA does not exist.

I ran the import before running this line of code and it DOES exist. Why does it error?

Thank you.

Re: File Does Not Exist But It does

andreas_lds — Fri, 06 Oct 2017 13:38:20 GMT

Post the log, so that we can see what happened.

Re: File Does Not Exist But It does

RW9 — Fri, 06 Oct 2017 13:40:55 GMT

Yes, would need to see the log. I would also avoid using keywords, like import for your dataset names. It shouldn't make any difference, but you never know.

Re: File Does Not Exist But It does

mmagnuson — Fri, 06 Oct 2017 13:56:57 GMT

ERORR: File GRIDWORK.IMPORT.DATA does not exist.

Affected Code: LEFT JOIN GRIDWORK.IMPORT t2 ON (t1.FIrst_Name = t2. FIRST Name)

Re: File Does Not Exist But It does

RW9 — Fri, 06 Oct 2017 14:00:22 GMT

Sorry, is that to me? If so that is not the log, just the error. Can we see the run of it importing the data and showing the creation of the dataset. Also please try using another name for the dataset rather than import.

Re: File Does Not Exist But It does

mmagnuson — Fri, 06 Oct 2017 14:06:16 GMT

GOPTIONS ACCESSIBLE;

Proc SQL:

Create Table Gridwork.Query_B AS

SELECT t1.First_Name,

t1.Last_Name,

(Case when t1.First_Name=t2.First_Name then "Y" end)

AS 'Yes_or_No'n

FROM Girdwork.Query_A t1

LEFT JOIN GRIDWORK.NewDoc ON (t1.First_Name=t2.First_Name);

quit;

ERROR: File GRIDWORK.NewDoc does not exist.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. QUIT;

Re: File Does Not Exist But It does

ballardw — Fri, 06 Oct 2017 14:18:55 GMT

Run this code and post the result:

Proc sql;
   select memname
   from dictionary.tables
   where libname='GRIDWORK';
QUIT;

If Newdoc does not appear in the result it doesn't exist. You may have another file that isn't a SAS data set by that name, or perhaps the library Gridwork isn't assigned.

Re: File Does Not Exist But It does

mmagnuson — Fri, 06 Oct 2017 14:21:09 GMT

I ran the code and Newdoc came up in the result

Re: File Does Not Exist But It does

RW9 — Fri, 06 Oct 2017 14:24:02 GMT

Look at the word gridwork in the two lines:

FROM Girdwork.Query_A t1

LEFT JOIN GRIDWORK.NewDoc ON (t1.First_Name=t2.First_Name);

One of these is incorrect.

Re: File Does Not Exist But It does

mmagnuson — Fri, 06 Oct 2017 14:47:05 GMT

That was a typo on my part. After looking at it again they both say Gridwork

Re: File Does Not Exist But It does

RW9 — Fri, 06 Oct 2017 15:47:05 GMT

You will have to go via SAS Support I am afraid, if the library and dataset exists as you say, then there is nothing wrong.

Re: File Does Not Exist But It does

Reeza — Fri, 06 Oct 2017 15:50:25 GMT

Try running a proc contents and post the output.

proc contents data=<data name>;

run;

Re: File Does Not Exist But It does

mmagnuson — Fri, 06 Oct 2017 15:53:40 GMT

Turns out it was because it was saved on a different server. Thanks for the input!