normal distribution for number of members by age

#1
Hello ,

I am trying to find out the normal distribution of number of members against each age-group. I have use the sas code but I am not sure if its the correct one .
data totalmembers;
input year age$ members;
datalines;
1997 16-21 20.70
1997 22-29 46.70
1997 30-39 60.80
1997 40-49 64.20
1997 50-54 63.20
1997 55-59 57.80
1997 60-64 47.10
1997 65+ 12.20
1998 16-21 18.00
1998 22-29 45.60
1998 30-39 60.20
1998 40-49 64.40
1998 50-54 63.20
1998 55-59 57.90
1998 60-64 44.70
1998 65+ 12.50
1999 16-21 17.80
1999 22-29 43.40
1999 30-39 57.30
1999 40-49 62.40
1999 50-54 61.10
1999 55-59 55.10
1999 60-64 42.40
1999 65+ 10.10
2000 16-21 19.10
2000 22-29 42.20
2000 30-39 56.00
2000 40-49 61.10
2000 50-54 59.80
2000 55-59 54.20
2000 60-64 40.20
2000 65+ 10.70
;
run;
proc print;
run;

PROC UNIVARIATE DATA=totalmembers normaltest;
TITLE2 "Analysis of pension members by age";
CLASS age;
VAR members;
RUN;



I just want to find out the process I am doing is right.
 

hlsmith

Less is more. Stay pure. Stay poor.
#3
Probably seems like what you want, however you have year in there but disregard it in the analyses.

So you get normality test of member by age groups for years 1997-2000 (guessing this is what you want).

As Jrb599 stated, where are your reservations?