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!!.
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!
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!
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!!
If you zoom the image you can see it. Thanks.
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!
That worked! Such an easy solution to everything I am trying. Thank you!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.