Hello ,
I have five variables in a SAS data set
Region, Sex(2 categories),School(2 categories),age(2 categories),Count
If we consider n_ijkl the value of count for each combination of Sex(2 categories),School(2 categories),age(2 categories) by region
How I can get n_ijk. = sum_l (n_ijkl) the sum over the categories l of age
and have it in my sas output 1 value and not twice without the variable age.
I use , but this give the total twice for each category of age (it is correct but I need it one time)
thanks
Adel
proc sql;
create table table_output as
select distinct* ,
sum(count) from table1 group by
region,sex,school;
quit;
---------------------------------
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails !
Créez votre Yahoo! Mail
|