topic Re: File xyz.data does not exist in New SAS User

File xyz.data does not exist

lucazanotti — Thu, 04 Oct 2018 08:46:29 GMT

Hi community,

hope you can help this, as I am a bit of a newbie. I have the following statement that was working, and now it doesn't.

libname xyz odbc dsn=abc_prod user=**** password=**** schema=*** preserve_tab_names=yes;

which correctly from the LOG assign the library

Libref xyz was successfully assigned as follows:
Engine: ODBC
Physical Name: abc_prod

The problem is that afterwards it try a

ERROR: File XYZ.FILE.DATA does not exist.

Do you know what reason may have occured to stop working? i can see from other db tools that the data are there and table names are spell correctly.

Many thanks in advance

Luca

Re: File xyz.data does not exist

RW9 — Thu, 04 Oct 2018 08:47:31 GMT

Whats the name of the dataset on the database? What does the log say, exactly not just part of it. Does the SAS system have access to the database?

Re: File xyz.data does not exist

Kurt_Bremser — Thu, 04 Oct 2018 08:47:41 GMT

You tried to use a dataset xyz.file, but no table named "file" is present in your odbc database.

Re: File xyz.data does not exist

lucazanotti — Thu, 04 Oct 2018 08:53:45 GMT

Hi Kurt,

apologies, i just mock the names for security reasons: indeed is

xyz.table_1.data

the related proc sql reference the table into:

xyz.table_1

Checked also the spelling and there are not mistakes in this sense.

Thank you

Luca

Re: File xyz.data does not exist

Kurt_Bremser — Thu, 04 Oct 2018 08:57:55 GMT

If you did something like

set xyz.table_1;

in SAS, and received the not found ERROR, you may have a permission problem via ODBC. If the ODBC connection actually points to the correct database schema in the RDBMS.

Run a proc datasets on library xyz to see which tables are there.

Re: File xyz.data does not exist

lucazanotti — Thu, 04 Oct 2018 11:20:08 GMT

Yes that indeed was the problem: our DB Admin check the ODBC SAS server and the dsn was the wrong one.

now is sorted. Thanks a lot to point in the right direction

Much appreciated

Luca