BookmarkSubscribeRSS Feed
sas_p
Fluorite | Level 6

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!

4 REPLIES 4
Reeza
Super User

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.

sas_p
Fluorite | Level 6
Thank you!
I figured it out
LinusH
Tourmaline | Level 20

Great!

But please share your resolution for the benefit of others.

Data never sleeps
sas_p
Fluorite | Level 6
I basically transposed the dataset and deleted the missings

sas-innovate-2024.png

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.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1013 views
  • 0 likes
  • 3 in conversation