topic DI Studio SORT transformation DUPOUT option in SAS Data Management

DI Studio SORT transformation DUPOUT option

Mushy — Mon, 14 Feb 2022 12:15:05 GMT

Hello All,

In SAS DI, In the SORT transformation we have the option for NODUPKEY.

Do we have any option to add additional output port/dataset in the SORT transformation to

direct the duplicate records, like DUPOUT option?

Thanks,

Mushy

Re: DI Studio SORT transformation DUPOUT option

LinusH — Tue, 26 Apr 2022 11:43:02 GMT

It seems that DI Studio haven't been updated with this option.

And I can't see a good way to use it in a good way.

Sure, you can add the dupout= as an option, but you can't add the dupout table as an output port.

Your options should be to either create your own transformation, or add a table object that corresponds to your dupout (but you can't link them really).