topic Re: Data Integration Studio If Else in Expression in Developers

Data Integration Studio If Else in Expression

DavidPhillips2 — Fri, 31 May 2019 19:43:48 GMT

I’m just starting to use the advanced options in the expression editor of Data Integration Studio.

Is there a way to do an if else statement in Data Integration Studio Expression editor? Do I have to use a case statement, if so where is the case statement function on the interface?

Re: Data Integration Studio If Else in Expression

DavidPhillips2 — Fri, 31 May 2019 20:55:05 GMT

There is a case button in the expression selection drop down although using it is inefficient. I found how to manually write case syntax in the advanced expression screen. You just type in it in like.

case
when W77MQJBD.AWARD_CATEGORY='24'
end

Re: Data Integration Studio If Else in Expression

DavidPhillips2 — Mon, 03 Jun 2019 16:42:29 GMT

If this could be done using if else in the expression editor it would save me a lot of time because my SAS code uses if else instead of case.

Re: Data Integration Studio If Else in Expression

LinusH — Wed, 05 Jun 2019 06:59:17 GMT

Most transformations which allow you to enter columns level expressions is using SQL (verify by viewing the code generated).

Hence, if-then-else is not supported.

My own experience implementing ETL is that case expressions works as good as if-then-else. More complicated patterns requiring if-then-else is rare, and when occurs is either a signal of a faulty target model, or can be implemented by User Written code node.

Re: Data Integration Studio If Else in Expression

DavidPhillips2 — Wed, 05 Jun 2019 18:13:55 GMT

The reply I got from SAS technical support is that If / Else is not integrated into Data Integration Studio. Unless you want to use a coded datastep.

Without the ability to use basic SAS code in the graphical areas the tool doesn't have much of a SAS feel to it.