topic Downloading a table in Enterprise Guide where the physical library name is off. in SAS Data Management

Downloading a table in Enterprise Guide where the physical library name is off.

DavidPhillips2 — Thu, 10 May 2018 14:53:34 GMT

I’m trying to use the tasks > data > download feature of Enterprise Guide to download a table. However the physical name of the library the table points to is not the same thing as the library name (the table use to be in another library) , so when I cannot locate the table to export it. When I tried changing the physical name to match I can see the table however Enterprise Gide throws the error

ERROR: File EAARL.PUBLIC.DATA does not exist.

ERROR: The metadata for the table/view EAARL.PUBLIC does not exist.

Re: Downloading a table in Enterprise Guide where the physical library name is off.

SASKiwi — Fri, 11 May 2018 23:09:42 GMT

Do you register your SAS tables in SAS metadata, because that is what your error is suggesting. If you rename a table without deleting the metadata definition for the old table and then create a new one that is the sort of error you would likely get. I avoid metadata registration of tables to prevent running into these type of issues.

You can check if you have these tables registered in SAS Management Console.

Re: Downloading a table in Enterprise Guide where the physical library name is off.

DavidPhillips2 — Mon, 14 May 2018 13:10:24 GMT

Yes, the table is registered in Metadata. I believe I need to register it in Metadata in order to work with the table in Data Integration Studio.

Re: Downloading a table in Enterprise Guide where the physical library name is off.

SASKiwi — Mon, 14 May 2018 21:29:58 GMT

OK, then when you rename a physical table you need to delete the original metadata registration and re-create it with the new name.