Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

SAS Miner: Filter Node: Can't exclude element of small size by selecting bar chart.

Accepted Solution Solved
Reply
Contributor
Posts: 31
Accepted Solution

SAS Miner: Filter Node: Can't exclude element of small size by selecting bar chart.

I can't exclude the 5th element pictured below using the filter node. The bar graph is too small for me to select the element to exclude. It has 17 elements. I have played with the chart settings as well. I have been trying over and over to select with my mouse.

 

Is there another way I can exclude values from the data set using the filter node? What about the "input data" node? If there is, would you specify the steps!! Thank you!!.

Filter.png


Accepted Solutions
Solution
‎01-28-2016 10:16 AM
Super Contributor
Posts: 336

Re: SAS Miner: Filter Node: Can't exclude element of small size by selecting bar chart.

One way to do it. Add a Transform Variables node. Click on the SAS Code ellipsis and then write something like the suggestions below.

 

if myvariable="X" then delete;

if myvariable="X" then myvariable="";

 

etc.

 

I hope this helps!

 

 

View solution in original post


All Replies
Super Contributor
Posts: 336

Re: SAS Miner: Filter Node: Can't exclude element of small size by selecting bar chart.

Hey bud,

Your image didn't paste well, or it might be my browser. Attach it again or explain the problem a bit and someone will give you a couple ideas along the lines of Filter, Transform, or SAS Code nodes.

 

Thanks!

Contributor
Posts: 31

Re: SAS Miner: Filter Node: Can't exclude element of small size by selecting bar chart.

I can't select the one labeled X.

 

I want to remove these values in my dataset. Tips would be helpful, because I am about to create seperate datasets outside of Miner and re-import. Thanks!!


Filter.png
Contributor
Posts: 31

Re: SAS Miner: Filter Node: Can't exclude element of small size by selecting bar chart.

If you zoom the image you can see it. Thanks.

Solution
‎01-28-2016 10:16 AM
Super Contributor
Posts: 336

Re: SAS Miner: Filter Node: Can't exclude element of small size by selecting bar chart.

One way to do it. Add a Transform Variables node. Click on the SAS Code ellipsis and then write something like the suggestions below.

 

if myvariable="X" then delete;

if myvariable="X" then myvariable="";

 

etc.

 

I hope this helps!

 

 

Contributor
Posts: 31

Re: SAS Miner: Filter Node: Can't exclude element of small size by selecting bar chart.

That worked!  Such an easy solution to everything I am trying. Thank you!

 

 

☑ This topic is solved.

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

Discussion stats
  • 5 replies
  • 403 views
  • 0 likes
  • 2 in conversation