Desktop productivity for business analysts and programmers

Cleaning Data in SAS

Reply
Occasional Contributor
Posts: 10

Cleaning Data in SAS

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!

Super User
Posts: 19,058

Re: Cleaning Data in SAS

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.

Occasional Contributor
Posts: 10

Re: Cleaning Data in SAS

Thank you!
I figured it out
Super User
Posts: 5,382

Re: Cleaning Data in SAS

Great!

But please share your resolution for the benefit of others.

Data never sleeps
Occasional Contributor
Posts: 10

Re: Cleaning Data in SAS

I basically transposed the dataset and deleted the missings
Ask a Question
Discussion stats
  • 4 replies
  • 311 views
  • 0 likes
  • 3 in conversation