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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register 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
  • 908 views
  • 0 likes
  • 2 in conversation