topic Re: Expression Text in Information Studio in Developers

Expression Text in Information Studio

deleted_user — Thu, 13 Dec 2007 07:23:52 GMT

Is it possible to use CASE and WHEN expressions in Information Maps Studio? If not what would be alternative solutions to generate computed fields within information maps?

Re: Expression Text in Information Studio

Cynthia_sas — Thu, 13 Dec 2007 16:15:13 GMT

Hi:
Although Stored Process and Information Maps are both components of the SAS Enterprise Intelligence Platform, this forum is for stored process questions. Your best resource for help with Information Map questions is Tech Support. The method that you use (manually typing the CASE statement in the Expression Builder window or using the INSERT DATAITEM syntax) will vary depending on how you intend to create the Information Map. In addition, since your Information Map can reference Relational Tables or OLAP cubes, you would use MDX expressions for OLAP cubes. So the type of data will have an effect on what you want to do.

I have successfully typed a case statement in the Expression Builder Window of Information Map Studio. We teach the simple form of building expressions in chapter 3 of the Information Map Studio course. When you want to add an additional DATAITEM to an Information Map, you use an Expression Builder in Information Map Studio or the INSERT DATAITEM statement in PROC INFOMAP.

To send a question to Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem".

cynthia

Re: Expression Text in Information Studio

jasonDMNK — Fri, 14 Dec 2007 21:54:08 GMT

Hi Kelly,

It is possible. Here's a quick example if you wanted to recode missing values to 0 on a budget data item:

Create a new data item --> Click Edit on the Definition Tab
In the Expression Editor window enter this into the Expression Text:
case
when <<Table.Budget>> =. then 0
else <<Table.Budget>>
end

Obviously you can make it more complex, just make sure to validate the expression.
Hope that helps!

Jason