topic Re: LIBNAME BASE | Tables does not appears in Administration and Deployment

LIBNAME BASE | Tables does not appears

MariaD — Tue, 08 Sep 2020 18:36:09 GMT

Hi folks,

We have a really bizarre situation. We create a libname using SAS code, a simple BASE libname. When open the LIBANME o SAS EG (7.15) (SAS9.4M6 on Solaris) only a few tables appears. All the tables have the same OS permission.

If we execute a proc contents or execute a data step with the table on set statement, works. But we can't see it on SAS EG interface. Any idea?

Regards

Re: LIBNAME BASE | Tables does not appears

Reeza — Tue, 08 Sep 2020 19:09:12 GMT

Are the table names over 32 characters? Are you on unix, if so are all the table names are lower case?

Re: LIBNAME BASE | Tables does not appears

MariaD — Tue, 08 Sep 2020 20:49:01 GMT

Yes, our server is Unix (Solaris). All table names have less than 32 characters and are in lowercase.

Re: LIBNAME BASE | Tables does not appears

Tom — Tue, 08 Sep 2020 20:58:13 GMT

Not sure why it would impact the Entriprise Guide's ability to show a list of table, but check the setting of the FMTERR option. If it is set to FMTERR trying changing it to NOFMTERR. Other options to check VALIDVARNAME, VALIDMEMNAME. If you have VALIDVARNAME set to V6 then names longer than 8 characters will be ignored. Make sure none of the filenames start with a digit.

Also check results of running PROC CONTENTS on the libref. Check that the libref is not pointing to the folder you think it is pointing to. Also perhaps some of the datasets have zero variables?

Re: LIBNAME BASE | Tables does not appears

Reeza — Tue, 08 Sep 2020 22:20:44 GMT

Given that it works via code but not the GUI I think you should raise a ticket with Tech Support.

Re: LIBNAME BASE | Tables does not appears

SASKiwi — Tue, 08 Sep 2020 23:10:22 GMT

What happens if you read one of the tables that doesn't show and overwrite it like so:

data MyLib.MyTable;
  set MyLib.MyTable;
run;

Then refresh your EG server list, does the overwritten table now show?

Re: LIBNAME BASE | Tables does not appears

MariaD — Wed, 09 Sep 2020 00:01:40 GMT

Hi @SASKiwi ,

I tried it but still no show...

Thanks

Re: LIBNAME BASE | Tables does not appears

SASKiwi — Wed, 09 Sep 2020 00:14:38 GMT

@MariaD - OK, try a copy to the WORK library, then refresh the WORK library in the server list - does it show?

data WORK.MyTable;
  set MyLib.MyTable;
run;

Re: LIBNAME BASE | Tables does not appears

JuanS_OCS — Wed, 09 Sep 2020 08:57:31 GMT

Hi @MariaD ,

if you enable SAS EG Project Logging, the resulting log after you expand this library should give more information about the issue. When you run proc contents data=lib._all_; can you see any noticeable difference amongst the properties/attributes of the tables that appear, and the ones that cannot?

Reasons can be many. As an example, the last time I saw this kind of behavior was cause due to the fact that the workspace server is in a specific locale/encoding, and then some tables were created with a compatible encoding/locale, but some others were generated using a different encoding/locale.

Re: LIBNAME BASE | Tables does not appears

MariaD — Wed, 09 Sep 2020 15:57:08 GMT

Thanks all for your answers. We compare the results of proc contents and all the results are the same.

If we copy or create a new table to work area, for example, the new table opens fine and we can visualize it ok.

All the tables, and folders, have 777 permission... Any idea?

Re: LIBNAME BASE | Tables does not appears

JuanS_OCS — Thu, 10 Sep 2020 07:04:19 GMT

Hello @MariaD ,

thank you for the checks. Did you have the chance to look at the SAS EG logging, right after you expand "Libraries"?

Otherwise, I would suggest to open a ticket with SAS Tech Support, as suggested earlier.