Just a quick tip on the shared prompts in SAS Information Map Studio: When attempting to select a previously created prompt in Information Map Studio, SAS will only display shared prompts that can be used for the type of variable you are filtering/prompting. For example, if you have a date value
Let me just say, I am loving SAS 9.2 and it's functionality for cascading prompts. I created a dynamic list prompt (the icing to that cake by the way) pointing to a sas dataset that has two variables: County and City. In Prompt #1, I created a County Selection pointing
Within SAS 9.2 you can now create shared prompts to use across information maps and stored processes. To get to the Shared Prompt capability from SAS Management Console: Move to Folders Tab Create Stored Process enter 'dummy' data for STP screens until you arrive at the Parameter Entry Screen. On
When accessing an external data source from Oracle, Teradata, SQL, etc with SAS it is widely accepted that the SAS program should use the SQL Pass-Thru functionality rather than a libname reference. However when linking to a defined external data source in the SAS Metadata from SAS Information Maps, the
Can there be ‘Or’ Boolean logic on filters within Information Map studio. The answer is yes. See the screenshot below on how to apply the ‘Or’.
When creating a filter on a numeric value in Information Map Studio, the query doesn't include the filter when used in Web Report Studio. The classification of the variable must be changed from "Measure" to "Category". (Measure is automatically used for incoming numeric values.) For instance, SASHELP.SHOES has a 'Number
Adding a bookmark or data exploration to the Information Map Viewer Portlet in SAS Information Delivery Portal will only display the number of records in your preferences within the data exploration itself. Be careful of novice users not realizing this and just taking the initial screen at face value (har
