topic Re: Linking A Stored Process with SAS Information Map in Developers

Linking A Stored Process with SAS Information Map

prabhatkumar — Sun, 09 Dec 2018 14:23:54 GMT

Hi Everyone,

I would like to inquire that is there any way through which we can attach a stored process created in SAS Enterprise Guide version 7.13 to SAS Information Map version 4.4 M4.

Please assist me.

Thanks

Re: Linking A Stored Process with SAS Information Map

Cynthia_sas — Sun, 09 Dec 2018 15:41:03 GMT

Hi:
It depends on how you're using the Stored Process and the Information Map.

It is possible to have a stored process provide data to an information map. If this is what you mean, then EG is really out of the picture after you create your stored process. In Information Map Studio, you have to define the stored process (or "bind" the stored process to the Information Map) inside Information Map Studio. Note that in this scenario, your stored process does NOT produce report output -- it produces data that is used by the information map. In this example https://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/infomap31_tips_9310.pdf it shows restricting access to data at the row level using a stored process to populate an information map.

In the other scenario, your Stored Process is producing a report output, using the Information Map as a data source. Your Stored Process in EG would need to be defined to run on the Workspace server (because Information Maps run on the Workspace server) and you'll need a LIBNAME statement that uses the INFOMAPS engine, as shown here (page 117) https://go.documentation.sas.com/api/docsets/engimap/9.4/content/engimap.pdf

Hope this helps. Note that most of the people working with Stored Processes will be monitoring this Forum specifically for Stored Processes: https://communities.sas.com/t5/SAS-Stored-Processes/bd-p/sas_stored_processes

Cynthia

Re: Linking A Stored Process with SAS Information Map

Kurt_Bremser — Mon, 10 Dec 2018 00:29:27 GMT

I moved the thread to the Stored Processes community.

Re: Linking A Stored Process with SAS Information Map

prabhatkumar — Mon, 10 Dec 2018 05:10:46 GMT

Hi @Cynthia_sas

The link of the document which was provided by you was for older version of SAS Information Map i.e SAS IMAP 3.1. Currently I am using SAS IMAP v 4.4 M4. In the previous version there was an option of stored process directly under the tool option but in the later version it is not available.

Kindly assist.

Regards

Prabhat Kumar