I am working on an information map using data in several look up tables. These tables have sets of variables labeled "Code" and "Description". When I add these to the InfoMap, the ID is defined as Code_# and Description_#. Is there an easy way to change these?
I am not sure if my issue is similar to the one referenced in this track or if it's something all together different. What I am trying to do is create an information map where the variable/measure names are static (e.g. C5-C17), but the the variable labels are what are displayed in WRS (e.g. C5 displays as "2010/01" this month, but would display as "2010/02" next.). I can run a SAS process to update the labels every month, but I don't want to have to change my reports every month. I was hoping that I could accomplish this via IMS.
I know that is where they are coming from, actually the _# is appended by SAS to the Fields with the name/label of Code or Description. Is there a way to change the ID either after creation, or as you are creating the InfoMap? The data that I am working from is in a MS-SQL table, and the person creating these in the future will not be able to change the label on the source data.
Found one way, not exactly in Information Map Studio. I can use PROC INFOMAPS to export the InfoMap to an XML file. Edit the XML file to replace the identity="CODE_#" with the value I edited in the description tag. Re-import the modified XML file (making sure I do this with a UTF-8 text editor and before doing anything with permissions) and everything is as I would like it.