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-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

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