Hi,
I need help cleaning my dataset
eg:
id animal plant x y z
1 2 3 3 7 6
1 3 4 5 . 8
1
2 2 2 6 5 6
2
2 1 1 2 7 7
3
3
3 5 1 . 8 8
now,
I need to remove rows with missing values.
Can anyone help me with this/
Thanks!
1. Are you intending to use Code or the GUI?
2. Post more details of your logic please, is it a specific set of variables that need to be missing.
3. Post what you expect as output
4. Please let us know what you've already tried so we can tailor the responses to what you need rather than just generic solutions.
Great!
But please share your resolution for the benefit of others.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.