topic Re: PROC INFOMAP - adding dynamic values to text prompt in SAS Procedures

PROC INFOMAP - adding dynamic values to text prompt

dosborne — Thu, 31 May 2018 05:31:27 GMT

Environment: SAS BASE 9.4, EG 7.15 HF3 (7.100.5.6132) (64-bit)

I am trying to add a text_prompt to an Information Map using:

insert text_prompt
displayed_text="Select Code:"
name="CODE"
id="codePrompt"
selection_type=single
value_displayed=yes
allow_user_values=no
column="table_name"."column_name";

2 problems !!!

1) Cant get the syntax for column= correct (wont execute to create Information Map , always get "cant find table" no matter what referencing I try)

2) If I use dataitem= as in

insert text_prompt
displayed_text="Select Code:"
name="CODE"
id="codePrompt"
selection_type=single
value_displayed=yes
allow_user_values=no
dataitem="dataItemID";

The map creates OK and I can use in EG but it WILL not display the dynamic list of possible prompt values.

Any help appreciated

Re: PROC INFOMAP - adding dynamic values to text prompt

ChrisHemedinger — Thu, 31 May 2018 11:26:30 GMT

Does your "table name" reference contain the full folder path of the infomap, as in this example from the doc?

insert text_prompt
   displayed_text="Select countries that apply:"
   id="countryPrompt"
   value_displayed=yes
   allow_user_values=yes
   column="/Shared Data/CUSTOMER"."Country”
      label_column="Postal_Code" /format=”custom-format”
   default_values=('CANADA' 'GERMANY');insert

Re: PROC INFOMAP - adding dynamic values to text prompt

dosborne — Fri, 01 Jun 2018 02:50:11 GMT

I have tried all sorts of path referencing options for both the COLUMN= and DATAITEM= options but cannot get values to show in the prompt when using the Information Map:
1) DATAITEM=

/* Insert a data source */
insert datasource sasserver="SASApp"
table="libr name".TABLE_NAME;

insert dataitem
column="TABLE_NAME"."COL_NAME"
id="codeId"
folder="folder name";

insert text_prompt
displayed_text="Select Code:"
name="CODEID"
id="codePrompt"
selection_type=single
value_displayed=yes
allow_user_values=no
dataitem="codeId";

- this code executes but the prompt show no values when used
- any attempt to provide full path of dataitem in code does not execute

For example:
insert text_prompt
displayed_text="Select Code:"
name="CODEID"
id="codePrompt"
selection_type=single
value_displayed=yes
allow_user_values=no
dataitem="/Shared Data/InformationMaps/map_name/folder name/codeId";

ERROR [ com.sas.iquery.metadata.MetadataException: The specified value column/data item "/Shared Data/InformationMaps/map_name/folder name/codeId" cannot be found. ]

- syntax error for every path name permutation I can think of:
"/Shared Data/InformationMaps/map_name/folder name"."codeId"
"/Shared Data/InformationMaps/map_name/folder name.codeId"
etc

2) COLUMN=

/* Insert a data source */
insert datasource sasserver="SASApp"
table="libr name".TABLE_NAME;

insert dataitem
column="TABLE_NAME"."COL_NAME"
id="codeId"
folder="folder name";

insert text_prompt
displayed_text="Select Code:"
name="CODEID"
id="codePrompt"
selection_type=single
value_displayed=yes
allow_user_values=no
column="TABLE_NAME"."COL_NAME";

- this code executes but the prompt show no values when used
- any attempt to provide full path of column in code does not execute

For example:
insert text_prompt
displayed_text="Select Code:"
name="CODEID"
id="codePrompt"
selection_type=single
value_displayed=yes
allow_user_values=no
column="TABLE_NAME"."COL_NAME";

[ com.sas.iquery.metadata.MetadataException: The specified external table TABLE_NAME cannot be found. ]

- same error for every path name permutation I can think of:
"TABLE_NAME.COL_NAME"
"Libr name"."TABLE_NAME"."COL_NAME"
"Libr name"."TABLE_NAME.COL_NAME"
"Libr name.TABLE_NAME.COL_NAME"

Thanks

Re: PROC INFOMAP - adding dynamic values to text prompt

ChrisHemedinger — Fri, 01 Jun 2018 11:41:29 GMT

Do you have the option to use SAS Information Map Studio to define a prompt the way that you want it, and then use PROC INFOMAPS and the INFOMAP libname engine to see how it's defined (to inform your coding)? See some tips in this blog post.

Re: PROC INFOMAP - adding dynamic values to text prompt

dosborne — Sun, 03 Jun 2018 23:27:15 GMT

No. I am trying to do this without Studio.

Thanks

Re: PROC INFOMAP - adding dynamic values to text prompt

dosborne — Tue, 12 Jun 2018 00:21:54 GMT

I have tried the following and it works fine:

insert text_prompt
displayed_text="Select CODE:"
name="CODEID"
id="codePrompt"
selection_type=single
value_displayed=yes
allow_user_values=no
values=(("200000" "Chosen") ("1"));

Re: PROC INFOMAP - adding dynamic values to text prompt

dosborne — Fri, 22 Jun 2018 01:23:41 GMT

Still cant get it to work.

Re: PROC INFOMAP - adding dynamic values to text prompt

suhaneyr — Fri, 29 Jun 2018 01:30:22 GMT

Kindly read this , if any help. http://support.sas.com/kb/36/193.html

Re: PROC INFOMAP - adding dynamic values to text prompt

dosborne — Fri, 29 Jun 2018 04:04:23 GMT

Thanks for the info. I am using EG 7.1 and Base SAS 9.4 so the prompted filters should work.

Thanks

Re: PROC INFOMAP - adding dynamic values to text prompt

suhaneyr — Fri, 29 Jun 2018 04:29:17 GMT

no worries.

Did you got your problem solved? if so please let me know the solution.

Re: PROC INFOMAP - adding dynamic values to text prompt

dosborne — Fri, 29 Jun 2018 04:31:36 GMT

No solution yet, I have a track open with SAS Support. I will let you know.

Thanks

Re: PROC INFOMAP - adding dynamic values to text prompt

FK1 — Wed, 29 Jan 2020 10:06:05 GMT

Hi @dosborne : has SAS Support finally resolved your problem with the prompt ?