topic Re: Merge two observations in SAS Procedures

Merge two observations

polpel — Fri, 20 Sep 2019 13:05:42 GMT

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?

Re: Merge two observations

PaigeMiller — Fri, 20 Sep 2019 13:07:28 GMT

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

Re: Merge two observations

polpel — Fri, 20 Sep 2019 13:27:45 GMT

omg thanks!!!!!

Re: Merge two observations

polpel — Fri, 20 Sep 2019 13:30:46 GMT

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 😞

Re: Merge two observations

PaigeMiller — Fri, 20 Sep 2019 13:32:17 GMT

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;

Re: Merge two observations

Ksharp — Fri, 20 Sep 2019 13:35:40 GMT

Paige,

You missed option NWAY .