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

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

wave43 — Wed, 27 Jan 2016 21:48:09 GMT

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!!.

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

M_Maldonado — Thu, 28 Jan 2016 14:33:46 GMT

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!

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

wave43 — Thu, 28 Jan 2016 14:40:35 GMT

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!!

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

wave43 — Thu, 28 Jan 2016 14:41:53 GMT

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

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

M_Maldonado — Thu, 28 Jan 2016 14:59:38 GMT

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!

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

wave43 — Thu, 28 Jan 2016 15:16:41 GMT

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