topic Re: clean up the data set in SAS Studio

clean up the data set

xshhAlex — Wed, 06 Dec 2017 03:29:36 GMT

I want to eliminate the missing values in the data set below and make it become a cleaner data set.

I have the following data set:

id age gender score

1 . . 30

1 . F .

1 10 . .

2 . . 40

2 . M .

2 11 . .

3 . . 50

3 . F .

3 12 . .

How can I change the above data set to the new data set looks like:

id age gender score

1 10 F 30

2 11 M 40

3 12 F 50

Re: clean up the data set

Reeza — Wed, 06 Dec 2017 03:33:59 GMT

There's a trick for this using the UPDATE statement. Replace your data set name with the HAVE in the code below and see what you get.

data want;
update have(obs=0) have;
by ID;
run;

@xshhAlex wrote:

I want to eliminate the missing values in the data set below and make it become a cleaner data set.

I have the following data set:

id age gender score

1 . . 30

1 . F .

1 10 . .

2 . . 40

2 . M .

2 11 . .

3 . . 50

3 . F .

3 12 . .

How can I change the above data set to the new data set looks like:

id age gender score

1 10 F 30

2 11 M 40

3 12 F 50

Re: clean up the data set

xshhAlex — Wed, 06 Dec 2017 03:50:26 GMT

The code you offered me works! Thank you so much!