BookmarkSubscribeRSS Feed
Mushy
Quartz | Level 8

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

1 REPLY 1
LinusH
Tourmaline | Level 20

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).

Data never sleeps

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1107 views
  • 0 likes
  • 2 in conversation