Merge two observations

[polpel]

Hello,

Basically I have a dataset where two-by-two lines are basically indentical and sort of complete each other like a puzzle piece (you'll see what I mean). And my goal is to merge those two lines to make just one. here's the set:

It shows number of men and women according to their age.

Tranche       Hommes Femmes

65 ans et plus   |   0    |   71
65 ans et plus   | 241 |    0
De 18 à 24 ans |   0    |  203
De 18 à 24 ans | 386 |    0
De 25 à 29 ans |    0   |  710
De 25 à 29 ans |1106|      0
De 30 à 34 ans |    0   |   680
De 30 à 34 ans |1380|     0

What i want is this:

65 ans et plus   |   241    |   71
De 18 à 24 ans |   386    |  203
De 25 à 29 ans |    1106 |  710
De 30 à 34 ans | 1380    |   680

any ideas?

[PaigeMiller · Accepted solution]

proc summary data=have;
    class tranche;
    var hommes femmes;
    output out=want sum=;
run;

[polpel]

omg thanks!!!!!

[polpel]

just it adds a new line with the sum of all the observations, any way of avoiding it?

i'm totally new in sas please dont judge 😞

[PaigeMiller]

Oh, that was my mistake. You can simply delete that record, or here is the fixed code

proc summary data=have nway;
    class tranche;
    var hommes femmes;
    output out=want sum=;
run;

[Ksharp]

Paige,

You missed option NWAY .