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.
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.
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.
OK, then when you rename a physical table you need to delete the original metadata registration and re-create it with the new name.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.