SAS MS Add-In: Why are there two variables with almost the same name?
Recently while setting up a report in SAS Add-In for Microsoft Excel, I was going to create a graph using an information map. When trying to assign the chart values, I realized I had several very confusing variable names. When the information map was created, I know I had everything neat looking due to my own OCD about variable names.
As shown in the following figure, the red boxes with the (1) – you can see the names are confusing. Turns out Name_2 and Order Month_2 were variables I had copied to create new variables. After changing the options to (2) Show Labels – my wonderful (3) variables names were there.
This turned out to be an important change, the Name_2 was actually the Customer name “decoded” and the variable called customer was a custom format I had applied to the customer variable. In the second list, you’ll notice that Customer (after the Sales measure) turned into Group.
Making it Permanent
You may want to advise your users to update their Options so the labels are always used. From the SAS ribbon, select Tools > Options. In the Data tab, select Display labels instead of variable names from the Settings area.
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)
- 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
- Creating a Web Analytics Report in SAS Visual Analytics 8.1 - 2017-06-19
- Designing Dashboards: Sending Your Style Vibe - 2017-01-21
- SAS Visual Analytics: Design Versus Reality - 2016-10-05