topic Re: How to get the unique value from a ISASTaskConsumer3.ActiveData in SAS Enterprise Guide

How to get the unique value from a ISASTaskConsumer3.ActiveData

Slash — Tue, 11 Sep 2012 05:29:44 GMT

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:

Re: How to get the unique value from a ISASTaskConsumer3.ActiveData

ChrisHemedinger — Tue, 11 Sep 2012 18:16:30 GMT

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

Re: How to get the unique value from a ISASTaskConsumer3.ActiveData

Slash — Wed, 12 Sep 2012 03:33:00 GMT

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.