topic Re: Not able to view the table in library but able to read data using Proc Sql code. in SAS Programming

Not able to view the table in library but able to read data using Proc Sql code.

ASHISH2525 — Sat, 07 Sep 2019 08:43:16 GMT

Hi All,

i am able to read the data using SAS code but the table doesn't appear under library.

also in SAS SMC while i try to register the table it doesn't appear there.

LIBNAME MX ODBC DSN="UAT01"

USER="uatxyz" PASSWORD="Uat@abc" SCHEMA="uat01";

proc sql;

connect to odbc(user=uatsuper password=Uat@abc dsn=UAT01);

create table work.job204 as

select * from connection to odbc

(select * from TANGOUAT.UAT01.JNL_ACQ);

quit;

what can be the reason behind this ?

Regards,

Ashish

Re: Not able to view the table in library but able to read data using Proc Sql code.

hashman — Sat, 07 Sep 2019 09:02:24 GMT

@ASHISH2525:

>but table doesn't appear under library<

What library?

The MX library pointing to the external data base?

It cannot appear there since you are writing the data set to the SAS WORK library.

Change WORK.job204 to MX.job204, and you'll see it under MX - provided, of course, that you have a write access to the data base schema defined in your LIBNAME statement and your query actually runs.

If you expect to see it in the SAS WORK library, it should be there with your code as is, as long as your query runs error-free.

Kind regards

Paul D.

Re: Not able to view the table in library but able to read data using Proc Sql code.

ASHISH2525 — Sat, 07 Sep 2019 09:52:41 GMT

Yes, The MX library pointing to the external data base. Job204 is already exists in external DB schema. Once we execute Libname statement have external data sources references it executed successfully. But still data set in MX library is not visible. Ideally it should visible post assigning libref MX.

Secondly when we execute following command:

data work.abc;

set MX.job204;

run;

it also executed successfully.

Re: Not able to view the table in library but able to read data using Proc Sql code.

hashman — Sat, 07 Sep 2019 10:07:06 GMT

@ASHISH2525:

Define "visible".

What kind of SAS user interface (UI) do you use to make it "visible"?

Native DMS? EGuide? SAS Studio?

In any case, if the data set in the library with the libref MX is visible to your SAS program (i.e. it can read it), as it appears to be the case, but not visible through the UI, it's an issue to be raised with your SAS admin or DBA or both.

Kind regards

Paul D.

Re: Not able to view the table in library but able to read data using Proc Sql code.

ASHISH2525 — Sat, 07 Sep 2019 10:18:34 GMT

Thanks Paul for your prompt response..

Yes data set appears as you mentioned, but through UI it doesn't appear.

I am raising a ticket for the same in SAS support.

Regards,

Ashish

Re: Not able to view the table in library but able to read data using Proc Sql code.

SASKiwi — Sun, 08 Sep 2019 04:14:56 GMT

I can't see anywhere in your LIBNAME where you are defining the database TANGOUAT. Is that defined in your DSN? If not then you might need to add a database = TANGOUAT parameter to your LIBNAME.

Re: Not able to view the table in library but able to read data using Proc Sql code.

ASHISH2525 — Sun, 08 Sep 2019 04:28:02 GMT

Yes database has been defined in DSN.

Re: Not able to view the table in library but able to read data using Proc Sql code.

_AS — Tue, 11 Aug 2020 08:46:35 GMT

Have you got the solution for the issue ?

We are facing the same in our environment.

Re: Not able to view the table in library but able to read data using Proc Sql code.

MariaD — Tue, 29 Sep 2020 17:58:41 GMT

Hi folks,

You have the solution for this issue? We have the same problem on our new environment.

Regards,