delete the duplicate and adding the two values

[Smitha9]

Hi,

I have a data

id  a  b 

1   1  2

2   .    .

3   1   3

4   .     .

5   .     .

In the above data I have "a" has duplicate. So. I want take the second duplicate value "b" to the first.

Also the missing values should be deleted if it is in between the duplicates. If the missing values are not between, then I want to take only one and not the duplicate missing value.

want data:

id a  b

1  1  3

4  .    .

[Shmuel]

What does ID mean? It seems you assigned it just the observation number and it can be neglected and dropped?

If you drop ID, sort the data by a then select last.a - maybe you will get what you want.

[Ksharp]

data have;
input id  a  b ;
cards;
1   1  2
2   .    .
3   1   3
4   .     .
5   .     .
;

data temp;
 set have end=last;
 by id a b notsorted;
 if cmiss(a,b)=2 and not last then delete;
run;
data want;
 set temp;
 by a notsorted;
 if last.a;
run;