topic Cleaning Data in SAS in SAS Enterprise Guide

Cleaning Data in SAS

sas_p — Thu, 18 Aug 2016 21:38:24 GMT

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!

Re: Cleaning Data in SAS

Reeza — Thu, 18 Aug 2016 21:45:24 GMT

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.

Re: Cleaning Data in SAS

sas_p — Thu, 18 Aug 2016 22:15:51 GMT

Thank you!
I figured it out

Re: Cleaning Data in SAS

LinusH — Fri, 19 Aug 2016 06:40:55 GMT

Great!

But please share your resolution for the benefit of others.

Re: Cleaning Data in SAS

sas_p — Wed, 24 Aug 2016 23:42:55 GMT

I basically transposed the dataset and deleted the missings