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?
proc summary data=have;
class tranche;
var hommes femmes;
output out=want sum=;
run;
proc summary data=have;
class tranche;
var hommes femmes;
output out=want sum=;
run;
omg thanks!!!!!
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 😞
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;
Paige,
You missed option NWAY .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.