BookmarkSubscribeRSS Feed
DavidPhillips2
Rhodochrosite | Level 12

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.

 

 

3 REPLIES 3
SASKiwi
PROC Star

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.

DavidPhillips2
Rhodochrosite | Level 12

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.

SASKiwi
PROC Star

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1352 views
  • 0 likes
  • 2 in conversation