Where can I use sql caluculated(derived column) in SAS DI

VVDR — Tue, 22 Sep 2020 23:15:39 GMT

Hi All,

In SAS DI, where can I use calculated column(newly derived in the same block) in SAS DI.

Thanks

Re: Where can I use sql calculated(derived column) in SAS DI

Rama_V — Wed, 23 Sep 2020 02:09:32 GMT

Hi VVDR,

I mean you are referring calculated column in SQL and applying in SQL or Extract transformation.

As in normal SQL, calculated columns are created using aggregated functions. You can use them in output under "select" part of SQL with user defined name for column or under "Having" part of SQL to filter after calculation. Under Having part, referring column name defined in select part for aggregate function need to be prefixed with "Calculated" word.

Same applies in DI Studio, navigate to the SQL transformation to select => mappings there you can create new column and write the aggregate function under expression.

topic Where can I use sql caluculated(derived column) in SAS DI in SAS Data Management

Where can I use sql caluculated(derived column) in SAS DI

Re: Where can I use sql calculated(derived column) in SAS DI