option noxwait noxsync;
filename xx dde' excel|a:\data.xls!R1C1:R68C14';
data aa;
infile xx notab dlm='09'x dsd missover;
input NO $ GRADE WEIGHT HEIGHT BIRTHDT $ CREDIT CLUB RIGHT LEFT DEPART GENDER BLOOD ASTRO CALCULAT $;
proc print;
run;
1.data a;
set aa;
proc sort;
by gender;
proc print;
run;
proc univariate data=a;
var height weight;
by gender;
run;
The SAS System 5
19:49 Thursday, October 21, 1999
------------------------------------ GENDER=1 ------------------------------------
Univariate Procedure
Variable=HEIGHT
Moments
N 46 Sum Wgts 46
Mean 160.9348 Sum 7403
Std Dev 5.343333 Variance 28.55121
Skewness 0.57874 Kurtosis 0.817682
USS 1192685 CSS 1284.804
CV 3.320185 Std Mean 0.787831
T:Mean=0 204.2756 Pr>|T| 0.0001
Num ^= 0 46 Num > 0 46
M(Sign) 23 Pr>=|M| 0.0001
Sgn Rank 540.5 Pr>=|S| 0.0001
Quantiles(Def=5)
100% Max 177 99% 177
75% Q3 164 95% 170
50% Med 160 90% 167
25% Q1 158 10% 155
0% Min 150 5% 153
1% 150
Range 27
Q3-Q1 6
Mode 158
Extremes
Lowest Obs Highest Obs
150( 26) 167( 46)
152( 38) 168( 40)
153( 30) 170( 5)
154( 34) 172( 6)
155( 35) 177( 16)
The SAS System 6
19:49 Thursday, October 21, 1999
------------------------------------ GENDER=1 ------------------------------------
Univariate Procedure
Variable=WEIGHT
Moments
N 46 Sum Wgts 46
Mean 50.39783 Sum 2318.3
Std Dev 5.191381 Variance 26.95044
Skewness 0.719245 Kurtosis 1.096575
USS 118050.1 CSS 1212.77
CV 10.3008 Std Mean 0.765427
T:Mean=0 65.84272 Pr>|T| 0.0001
Num ^= 0 46 Num > 0 46
M(Sign) 23 Pr>=|M| 0.0001
Sgn Rank 540.5 Pr>=|S| 0.0001
Quantiles(Def=5)
100% Max 64 99% 64
75% Q3 53 95% 62
50% Med 50 90% 58
25% Q1 47 10% 44
0% Min 40 5% 43
1% 40
Range 24
Q3-Q1 6
Mode 50
Extremes
Lowest Obs Highest Obs
40( 11) 58( 6)
41( 38) 58( 46)
43( 17) 62( 30)
44( 37) 64( 16)
44( 27) 64( 31)
The SAS System 7
19:49 Thursday, October 21, 1999
------------------------------------ GENDER=2 ------------------------------------
Univariate Procedure
Variable=HEIGHT
Moments
N 22 Sum Wgts 22
Mean 170.6818 Sum 3755
Std Dev 5.947279 Variance 35.37013
Skewness -1.04567 Kurtosis 4.205068
USS 641653 CSS 742.7727
CV 3.484425 Std Mean 1.267964
T:Mean=0 134.6109 Pr>|T| 0.0001
Num ^= 0 22 Num > 0 22
M(Sign) 11 Pr>=|M| 0.0001
Sgn Rank 126.5 Pr>=|S| 0.0001
Quantiles(Def=5)
100% Max 183 99% 183
75% Q3 174 95% 178
50% Med 170 90% 176
25% Q1 168 10% 166
0% Min 152 5% 165
1% 152
Range 31
Q3-Q1 6
Mode 170
Extremes
Lowest Obs Highest Obs
152( 17) 175( 7)
165( 21) 176( 6)
166( 12) 176( 14)
167( 19) 178( 2)
168( 22) 183( 11)
The SAS System 8
19:49 Thursday, October 21, 1999
------------------------------------ GENDER=2 ------------------------------------
Univariate Procedure
Variable=WEIGHT
Moments
N 22 Sum Wgts 22
Mean 63.55909 Sum 1398.3
Std Dev 5.725104 Variance 32.77682
Skewness 0.312683 Kurtosis -0.64761
USS 89562.99 CSS 688.3132
CV 9.00753 Std Mean 1.220596
T:Mean=0 52.07216 Pr>|T| 0.0001
Num ^= 0 22 Num > 0 22
M(Sign) 11 Pr>=|M| 0.0001
Sgn Rank 126.5 Pr>=|S| 0.0001
Quantiles(Def=5)
100% Max 73 99% 73
75% Q3 67 95% 73
50% Med 62.25 90% 73
25% Q1 60 10% 58
0% Min 53 5% 56
1% 53
Range 20
Q3-Q1 7
Mode 60
Extremes
Lowest Obs Highest Obs
53( 19) 68( 7)
56( 14) 72( 3)
58( 17) 73( 10)
58( 16) 73( 11)
59.5( 1) 73( 13)
2.data b;
set aa;
proc sort;
by depart;
proc print;
run;
proc freq data=b;
tables blood;
by depart;
run;
The SAS System 11
19:49 Thursday, October 21, 1999
------------------------------------ DEPART=1 ------------------------------------
Cumulative Cumulative
BLOOD Frequency Percent Frequency Percent
???????????????????????????????????????????????????
1 9 30.0 9 30.0
2 9 30.0 18 60.0
3 10 33.3 28 93.3
4 2 6.7 30 100.0
The SAS System 12
19:49 Thursday, October 21, 1999
------------------------------------ DEPART=2 ------------------------------------
Cumulative Cumulative
BLOOD Frequency Percent Frequency Percent
???????????????????????????????????????????????????
1 12 34.3 12 34.3
2 9 25.7 21 60.0
3 13 37.1 34 97.1
4 1 2.9 35 100.0
Frequency Missing = 1
The SAS System 13
19:49 Thursday, October 21, 1999
------------------------------------ DEPART=3 ------------------------------------
Cumulative Cumulative
BLOOD Frequency Percent Frequency Percent
???????????????????????????????????????????????????
2 1 50.0 1 50.0
3 1 50.0 2 100.0
公衛系 O型最多 10人 佔33.33%
藥學系 O型最多 13人 佔37.1%
其他系 B.O型各佔一半 各1人 佔50%
3.data c;
set aa;
myopia=(right+left)/2;
proc print;
run;
data d;
set c;
if myopia=0 then myo='N';
else if 0<myopia<350 then myo='L';
else if 350<=myopia<600 then myo='M';
else myo='H';
proc freq;
tables myo*calculat / list;
run;
The SAS System 16
19:49 Thursday, October 21, 1999
Cumulative Cumulative
MYO CALCULAT Frequency Percent Frequency Percent
??????????????????????????????????????????????????????????
H 1 1 1.5 1 1.5
H 2 3 4.4 4 5.9
H 3 8 11.8 12 17.6
H 4 7 10.3 19 27.9
L 3 13 19.1 32 47.1
L 4 10 14.7 42 61.8
M 2 5 7.4 47 69.1
M 3 15 22.1 62 91.2
M 4 5 7.4 67 98.5
N 3 1 1.5 68 100.0
1:沒修 2:好 3:普通 4:爛
不同近視組別,在CALCULAT上,普通(3)皆佔最多!
--
※ 發信站: 批踢踢實業坊(ptt.twbbs.org)
◆ From: h205.s29.ts30.hinet.net
--
※ 發信站: 批踢踢實業坊(ptt.twbbs.org)
◆ From: steamev.m3.ntu.edu.tw