Desktop productivity for business analysts and programmers

the SAS tables names not updated in SAS EG after renamed in SMC

Reply
Occasional Contributor
Posts: 6

the SAS tables names not updated in SAS EG after renamed in SMC

I have bunch of sas tables in one of the library and as per the user requirement and to maintain unique name across all libraries, i have renamed the SAS Tables in that library.

like tables registered and name changed from 'ttf_address' to 'address', but in SAS EG i could see the table names as 'ttf_address' not just 'address'.

why this happening and how to apply the fix to be able to reflect the same table names in SAS EG.

Esteemed Advisor
Posts: 5,198

Re: the SAS tables names not updated in SAS EG after renamed in SMC

It seems that you have rename the metadata name, and in the server tab, physical names are displayed.

Or, you have renamed the tables in SMC, but not renamed the tables physically.

Data never sleeps
Occasional Contributor
Posts: 6

Re: the SAS tables names not updated in SAS EG after renamed in SMC

Hi Linush,

Thank you for your reply...

I have renamed in SAS SMC after registered the tables from out source.

like there are data tables with same name for two entitis but data is different, hence we have prefix with entity code.

Ex: like transport entity tables has prefix 'ttf_sample'  for table names

& sales entity tables has 'sls_sample' table name

and resisted them into two SAS sales library and transport libraries  then renamed in SAS SMC in both libraries to met the table names in rest of the libraries.

Esteemed Advisor
Posts: 5,198

Re: the SAS tables names not updated in SAS EG after renamed in SMC

I'm not following you.

  • What are the physical table names?
  • What are the metadata table names?
  • What engine do you use (for EG users)?
  • What allocation method for library assignment is used?
Data never sleeps
Occasional Contributor
Posts: 6

Re: the SAS tables names not updated in SAS EG after renamed in SMC

Hi Linush,

yes, i can see physical table names in server tab are the physical tables?

i can see metadata table names as renamed table names in Folders tab.

oracle Engine

applied read/deny permissions on libraries in SMC.

i think i need to apply the permission on folder structure rather than on libraries using SMC.

please comment.

Community Manager
Posts: 2,692

Re: the SAS tables names not updated in SAS EG after renamed in SMC

If you are renaming the tables in metadata and NOT renaming the physical table files, then that can cause some confusion.

It would be better to rename the physical files, then update the table definitions in metadata by using the Register Tables function in SAS MC, or Tools->Update Library Metadata in EG.

EG operates in both The World of Metadata and the World of What's Real.  So while your end users might see libraries and tables as they are named in metadata, SAS programs that are written against these tables might revert to the actual physical file names.  It's best to keep these in sync, if possible.

Chris

Occasional Contributor
Posts: 6

Re: the SAS tables names not updated in SAS EG after renamed in SMC

Hi Chris,

thank you for your reply.

still not getting exactly.

i had rename the tables after registered from Oracle schema in SMC as below.

Example - registered below tables:

USA_cust table - registered into 'US' library then renamed to USA_customer_details.

UK_cust table   - registered into 'UK' library then renamed to UK_customer_details.

answer for your hint is - i cannot rename the tables in physical location as both tables exists in same schema, wont allow to be create two tables with same name.

Users wants to see the renamed table name(USA_customer_details & UK_customer_details) in SAS EG under "Server > SASApp > Libraries >US & UK libraries" appropriately.

Regular Contributor
Posts: 220

Re: the SAS tables names not updated in SAS EG after renamed in SMC

Gurram - one thing you can do from Chris note is i guess -

- unregistere all tables from MC (this will not delete physical table from library)

- RENAME all tables physically under all library, as per user needs (i think you can do it since tables names are different as UK and US)

- then register all tables under each library meanwhile check how it looks like in EG

- in worse case - concern SAS technical guys...last options Smiley Happy

Gd lk!

Occasional Contributor
Posts: 6

Re: the SAS tables names not updated in SAS EG after renamed in SMC

Hi Sandy,

i can not rename physically as oracle schema wont allow two tables with same name.

correction in last post table names....

USA_cust table - registered into 'US' library then renamed to 'customer_details'   (not USA_customer_details   - its typo error).

UK_cust table   - registered into 'UK' library then renamed to 'customer_details'    (not UK_customer_details   - its typo error).

Users wants to see the renamed table name(customer_details & customer_details) in SAS EG under "Server > SASApp > Libraries >US & UK libraries" appropriately.

Can i do log into SAS EG and navigate to Server > SASApp > Libraries >US & UK - rename tables names?

i have already renamed table names in SMC after registered them into UK & USA libraries.

Ask a Question
Discussion stats
  • 8 replies
  • 470 views
  • 0 likes
  • 4 in conversation