Using Stored Processes to Improve Information Maps

Integrating Stored Processes into Information Maps can improve process performance as well as provide extra flexibility and complete query generation control. In order to showcase how powerful this combination is, I am presenting this topic during a SAS Talks webinar session this Thursday, December 16th. The scope of the example will be to replace implicit with explicit queries to a RDBMS, however combining stored processes with information maps can prove useful in other arenas as well.

Some Examples of Possible Stored Process use within Information Maps:

I'm sure with some creativity, you can think of other reasons to join these two components together for performance improvements. Register for the webinar & join me this Thursday to discuss how & why to use Stored Processes more often!

tags: Information Maps, Stored Processes

4 Comments

  1. Anonymous
    Posted December 17, 2010 at 2:53 pm | Permalink

    Great webinar! Thanks for the giving it.

  2. Anonymous
    Posted December 22, 2010 at 2:32 pm | Permalink

    Dang, I'm sorry I missed this.
    I'll read up on the links you posted.
    Thanks!!!

  3. KD
    Posted December 20, 2011 at 8:35 pm | Permalink

    Hi ,

    Great article indeed , but i have some implementation doubts.

    if i define the filter in the .sas STP code "a macro...&filter_var", how can i passe the user selected value from WRS to .sas code without defining it in the IMap.

    i have a requirement where the user will select from multiple / single value from one field and single or no value from other field.
    Base on these filter condition the a subset dataset should be created from the whole big dataset.

    This dataset should be again used information map studio to calculate a custom data element.

    the value of this custom data element with others will be used to render a graph.

    was wondering if all these can be done ? can you suggest any approach ?

    can this be alone done using only

    Thanks
    KD

    • Angela Hall Angela Hall
      Posted February 20, 2012 at 4:40 pm | Permalink

      KD,
      When you define parameters on a stored process and then add this stored process to an information map, the tool (whether its within SAS Information Map Studio during your testing or through SAS Web Report Studio) automatically surfaces the parameters (or prompts) to the user.

      You don't have to believe me :) but SAS has an 'official' KB entry that explains how to do this too & its been available since SAS 9.1.3sp4.
      http://support.sas.com/kb/33/146.html

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <p> <pre lang="" line="" escaped=""> <q cite=""> <strike> <strong>