topic Re: Information Map Studio 4.2 Data Item ID in SAS Web Report Studio

Information Map Studio 4.2 Data Item ID

deleted_user — Mon, 24 Jan 2011 18:27:08 GMT

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?

Re: Information Map Studio 4.2 Data Item ID

AngelaHall — Mon, 24 Jan 2011 19:10:47 GMT

Change the source data table labels. The "code #" and "description #" are the labels for those two elements.

one example - changing sashelp.shoes =

data sashelp.shoes;
set sashelp.shoes;
attrib sales label="Sales #";
run;

~ Angela

Re: Information Map Studio 4.2 Data Item ID

deleted_user — Mon, 24 Jan 2011 19:29:39 GMT

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.

Re: Information Map Studio 4.2 Data Item ID

AngelaHall — Mon, 24 Jan 2011 19:57:26 GMT

Unaware of a way to change it from Information Map studio.

An alternative is that you could use the PROC INFOMAP step in base sas (or sas eg) to create the imap.

http://support.sas.com/documentation/cdl/en/engimap/61078/HTML/default/a003088311.htm

~ Angela

Re: Information Map Studio 4.2 Data Item ID

deleted_user — Mon, 24 Jan 2011 20:45:10 GMT

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.

Re: Information Map Studio 4.2 Data Item ID

AngelaHall — Mon, 24 Jan 2011 20:56:28 GMT

The xml can certainly be updated. Note that SAS TS doesn't 'officially' support this.
Be extremely careful as well, dependent reports could be broken during the editing process.

~ Angela

Re: Information Map Studio 4.2 Data Item ID

Michael_W — Tue, 01 Feb 2011 18:44:27 GMT

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.

Your support is greatly appreciated.

Michael