How to get the unique value from a ISASTaskConsumer3.ActiveData

[Slash]

Hi, all

     I am use C# to write a EG Add-in. What I want is to get a specified variable's unique value. I can get the specified column and row's value through the Consumer.ActiveData.Accessor.Value property.

I have a idea:

Submit a sql code to get the unique value and create a temp data set;

And I get the unique value from the temp data set.

But I think this is too complex and waste too much resources. Is there a easy way to do this?

Just like the Filter and Sort Node in the EG, the pic:

[ChrisHemedinger · Accepted solution]

Slash,

Check out this blog post for a small example of using the SAS.Tasks.Toolkit.SasData namespace:

Listing the data sets in a library within your custom task - The SAS Dummy

Then look at this helper method:

SAS.Tasks.Toolkit.Helpers.TaskDataHelpers.GetDistinctValues()

It returns a List<string> collection of formatted values from the data you specify, using a SAS format that you specify.

Chris

[Slash]

Thank you!

     Chris, this is good way to do it. There are a lot of API Functions in the Help Document. I should take a close look.