Cleaning Data in SAS

[sas_p]

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!

[Reeza]

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]

Thank you!
I figured it out

[LinusH]

Great!

But please share your resolution for the benefit of others.

[sas_p]

I basically transposed the dataset and deleted the missings