Desktop productivity for business analysts and programmers

How to get the unique value from a ISASTaskConsumer3.ActiveData

Accepted Solution Solved
Reply
Contributor
Posts: 64
Accepted Solution

How to get the unique value from a ISASTaskConsumer3.ActiveData

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:

1.jpg


Accepted Solutions
Solution
‎09-11-2012 02:16 PM
Community Manager
Posts: 2,691

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

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

View solution in original post


All Replies
Solution
‎09-11-2012 02:16 PM
Community Manager
Posts: 2,691

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

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

Contributor
Posts: 64

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

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.

111.jpg

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 304 views
  • 0 likes
  • 2 in conversation