topic Re: delete the duplicate and adding the two values in New SAS User

delete the duplicate and adding the two values

Smitha9 — Sun, 10 Jan 2021 23:29:35 GMT

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 . .

Re: delete the duplicate and adding the two values

Shmuel — Mon, 11 Jan 2021 06:25:14 GMT

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.

Re: delete the duplicate and adding the two values

Ksharp — Mon, 11 Jan 2021 11:27:58 GMT

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;