SAS Info Map: Change Source Table Names from Klingonese to English
I love the way some data tables get named. After a while you begin to learn the patterns – but geez sometimes I think a true alien was involved. The names are cryptic and when the tables are place in SAS Information Map Studio – it gets confusing. You can change the name for your information map to help you understand as you create the necessary joins.
Image courtesy of Cartoon-A-Day
Using SAS Information Map Studio to Rename Data Tables
In SAS Information Map Studio, you can make changes to the base tables. For instance, the Oracle name may be tblEmployeeJibberish or a similar name that does not help you remember the content or why you wanted to link to the table. You can change the table name and select columns to include or omit. Right-click the table title bar and select Properties from the pop-up menu.
Making Your Own Decoder Ring
After infiltrating the secret table naming area (aka Table Properties) – you can really enjoy yourself. The Table Properties window has three panes: Definition, Resources, and Columns.
Definition: You can change the name of the table. This can help when the table uses a cryptic database title, such as tblemployeeall. A human readable title, such as SALES STAFF may help you remember what you were doing the next time you have to edit the information map. Changing the name here does not change the metadata. The real table name is kept in the ID field. [You probably thought it worked that way.]
Resource: You can get more information about the table metadata.
Columns: You can select any columns you want to omit. This prevents the SQL query that builds the information map from pulling these data items in the default query. It might be helpful for particularly large tables or when you have security concerns. You can also chose how you want new data items handled. For instance, if the table is updated with new columns you may not want to ensure they do not display.
Tip! You probably want to recall this action so later you are not wondering why the new columns you just added are not there.
Check out the other tips about SAS Information Map Studio.
Learn all about SAS BI
You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.
Latest posts by Tricia Aanderud (see all)
- Seven Interesting Data Storytelling Examples - 2018-06-09
- Use Network Analysis to Understand Your Customers with SAS Visual Analytics 8.2 - 2018-01-21
- My 7 Favorite Features in SAS Visual Analytics 8.2 on Viya - 2018-01-14
- Designing Dashboards: Finding the Fantastic Five Colors - 2017-06-19
- Creating a Web Analytics Report in SAS Visual Analytics 8.1 - 2017-06-19