$B!!A02s$^$G$KJ,I[FC@-$rGD0.$9$k$?$a$N$$$/$D$+$N;XI8$r@bL@$7!"(B $B$=$N;H$$J}$dCm0UE@$r4-5/$7$?!#$^$?%0%k!<%WJ,$1$,M-MQ$J$3$H$b@bL@$7$?!#(B $B:#2s$O!"C1=c=87W$H$7$F$h$/MxMQ$5$l$kIQEY=87W$d%/%m%9=87W$NJ}K!$r>R2p$9$k!#(B
iv. $BE}7W4XO"(B
/* Lesson 08-1 */
/* File Name = les0801.sas 11/22/06 */
data gakusei;
infile 'all06be.prn'
firstobs=2;
input sex $ shintyou taijyuu kyoui
jitaku $ kodukai carryer $ tsuuwa;
proc print data=gakusei(obs=5);
run;
:
proc freq data=gakusei; : $BIQEY$r;;=P(B
tables sex jitaku carryer; : $B0lJQNL$4$H$K(B
run; :
proc freq data=gakusei; : $BIQEY$r;;=P(B
tables sex*jitaku; : $BFsJQNL$NAH$_9g$o$;$G(B
tables sex*carryer; :
tables jitaku*carryer; :
run; :
SAS $B%7%9%F%`(B 1
09:01 Wednesday, November 22, 2006
OBS SEX SHINTYOU TAIJYUU KYOUI JITAKU KODUKAI CARRYER TSUUWA
1 F 145.0 38 . J 10000 .
2 F 146.7 41 85 J 10000 Vodafone 6000
3 F 148.0 42 . J 50000 .
4 F 148.0 43 80 J 50000 DoCoMo 4000
5 F 148.9 . . J 60000 .
SAS $B%7%9%F%`(B 2
09:01 Wednesday, November 22, 2006
Cumulative Cumulative
SEX Frequency Percent Frequency Percent
-------------------------------------------------
F 121 33.3 121 33.3
M 242 66.7 363 100.0
Frequency Missing = 5
Cumulative Cumulative
JITAKU Frequency Percent Frequency Percent
----------------------------------------------------
G 118 37.3 118 37.3
J 198 62.7 316 100.0
Frequency Missing = 52
Cumulative Cumulative
CARRYER Frequency Percent Frequency Percent
------------------------------------------------------
DDIp 2 1.4 2 1.4
DoCoMo 56 39.2 58 40.6
J-PHONE 10 7.0 68 47.6
KDDI 1 0.7 69 48.3
No 5 3.5 74 51.7
Vodafone 20 14.0 94 65.7
Willcom 1 0.7 95 66.4
au 39 27.3 134 93.7
au+willc 1 0.7 135 94.4
docomo 5 3.5 140 97.9
docomo+w 1 0.7 141 98.6
softbank 1 0.7 142 99.3
vodafone 1 0.7 143 100.0
Frequency Missing = 225
SAS $B%7%9%F%`(B 6
09:01 Wednesday, November 22, 2006
TABLE OF SEX BY JITAKU
SEX JITAKU
Frequency|
Percent |
Row Pct |
Col Pct |G |J | Total
---------+--------+--------+
F | 36 | 68 | 104
| 11.46 | 21.66 | 33.12
| 34.62 | 65.38 |
| 30.77 | 34.52 |
---------+--------+--------+
M | 81 | 129 | 210
| 25.80 | 41.08 | 66.88
| 38.57 | 61.43 |
| 69.23 | 65.48 |
---------+--------+--------+
Total 117 197 314
37.26 62.74 100.00
Frequency Missing = 54
SAS $B%7%9%F%`(B 9
09:01 Wednesday, November 22, 2006
TABLE OF SEX BY CARRYER
SEX CARRYER
Frequency|
Percent |
Row Pct |
Col Pct |DDIp |DoCoMo |J-PHONE |KDDI |No | Total
---------+--------+--------+--------+--------+--------+
F | 1 | 23 | 4 | 0 | 1 | 54
| 0.70 | 16.20 | 2.82 | 0.00 | 0.70 | 38.03
| 1.85 | 42.59 | 7.41 | 0.00 | 1.85 |
| 50.00 | 41.07 | 44.44 | 0.00 | 20.00 |
---------+--------+--------+--------+--------+--------+
M | 1 | 33 | 5 | 1 | 4 | 88
| 0.70 | 23.24 | 3.52 | 0.70 | 2.82 | 61.97
| 1.14 | 37.50 | 5.68 | 1.14 | 4.55 |
| 50.00 | 58.93 | 55.56 | 100.00 | 80.00 |
---------+--------+--------+--------+--------+--------+
Total 2 56 9 1 5 142
1.41 39.44 6.34 0.70 3.52 100.00
(Continued)
SAS $B%7%9%F%`(B 11
09:01 Wednesday, November 22, 2006
TABLE OF SEX BY CARRYER
SEX CARRYER
Frequency|
Percent |
Row Pct |
Col Pct |Vodafone|Willcom |au |au+willc|docomo | Total
---------+--------+--------+--------+--------+--------+
F | 9 | 1 | 12 | 1 | 1 | 54
| 6.34 | 0.70 | 8.45 | 0.70 | 0.70 | 38.03
| 16.67 | 1.85 | 22.22 | 1.85 | 1.85 |
| 45.00 | 100.00 | 30.77 | 100.00 | 20.00 |
---------+--------+--------+--------+--------+--------+
M | 11 | 0 | 27 | 0 | 4 | 88
| 7.75 | 0.00 | 19.01 | 0.00 | 2.82 | 61.97
| 12.50 | 0.00 | 30.68 | 0.00 | 4.55 |
| 55.00 | 0.00 | 69.23 | 0.00 | 80.00 |
---------+--------+--------+--------+--------+--------+
Total 20 1 39 1 5 142
14.08 0.70 27.46 0.70 3.52 100.00
(Continued)
SAS $B%7%9%F%`(B 13
09:01 Wednesday, November 22, 2006
TABLE OF SEX BY CARRYER
SEX CARRYER
Frequency|
Percent |
Row Pct |
Col Pct |docomo+w|softbank|vodafone| Total
---------+--------+--------+--------+
F | 0 | 1 | 0 | 54
| 0.00 | 0.70 | 0.00 | 38.03
| 0.00 | 1.85 | 0.00 |
| 0.00 | 100.00 | 0.00 |
---------+--------+--------+--------+
M | 1 | 0 | 1 | 88
| 0.70 | 0.00 | 0.70 | 61.97
| 1.14 | 0.00 | 1.14 |
| 100.00 | 0.00 | 100.00 |
---------+--------+--------+--------+
Total 1 1 1 142
0.70 0.70 0.70 100.00
Frequency Missing = 226
SAS $B%7%9%F%`(B 16
09:01 Wednesday, November 22, 2006
TABLE OF JITAKU BY CARRYER
JITAKU CARRYER
Frequency|
Percent |
Row Pct |
Col Pct |DDIp |DoCoMo |J-PHONE |KDDI |No | Total
---------+--------+--------+--------+--------+--------+
G | 1 | 20 | 4 | 1 | 0 | 46
| 0.81 | 16.26 | 3.25 | 0.81 | 0.00 | 37.40
| 2.17 | 43.48 | 8.70 | 2.17 | 0.00 |
| 100.00 | 41.67 | 44.44 | 100.00 | 0.00 |
---------+--------+--------+--------+--------+--------+
J | 0 | 28 | 5 | 0 | 4 | 77
| 0.00 | 22.76 | 4.07 | 0.00 | 3.25 | 62.60
| 0.00 | 36.36 | 6.49 | 0.00 | 5.19 |
| 0.00 | 58.33 | 55.56 | 0.00 | 100.00 |
---------+--------+--------+--------+--------+--------+
Total 1 48 9 1 4 123
0.81 39.02 7.32 0.81 3.25 100.00
(Continued)
SAS $B%7%9%F%`(B 18
09:01 Wednesday, November 22, 2006
TABLE OF JITAKU BY CARRYER
JITAKU CARRYER
Frequency|
Percent |
Row Pct |
Col Pct |Vodafone|Willcom |au |au+willc|docomo | Total
---------+--------+--------+--------+--------+--------+
G | 4 | 0 | 12 | 0 | 2 | 46
| 3.25 | 0.00 | 9.76 | 0.00 | 1.63 | 37.40
| 8.70 | 0.00 | 26.09 | 0.00 | 4.35 |
| 23.53 | . | 35.29 | 0.00 | 40.00 |
---------+--------+--------+--------+--------+--------+
J | 13 | 0 | 22 | 1 | 3 | 77
| 10.57 | 0.00 | 17.89 | 0.81 | 2.44 | 62.60
| 16.88 | 0.00 | 28.57 | 1.30 | 3.90 |
| 76.47 | . | 64.71 | 100.00 | 60.00 |
---------+--------+--------+--------+--------+--------+
Total 17 0 34 1 5 123
13.82 0.00 27.64 0.81 4.07 100.00
(Continued)
SAS $B%7%9%F%`(B 20
09:01 Wednesday, November 22, 2006
TABLE OF JITAKU BY CARRYER
JITAKU CARRYER
Frequency|
Percent |
Row Pct |
Col Pct |docomo+w|softbank|vodafone| Total
---------+--------+--------+--------+
G | 1 | 1 | 0 | 46
| 0.81 | 0.81 | 0.00 | 37.40
| 2.17 | 2.17 | 0.00 |
| 100.00 | 100.00 | 0.00 |
---------+--------+--------+--------+
J | 0 | 0 | 1 | 77
| 0.00 | 0.00 | 0.81 | 62.60
| 0.00 | 0.00 | 1.30 |
| 0.00 | 0.00 | 100.00 |
---------+--------+--------+--------+
Total 1 1 1 123
0.81 0.81 0.81 100.00
Frequency Missing = 245
$B"cA0N,"d(B if carryer="au+willc" then carryer="au+Willc"; if carryer="docomo" then carryer="DoCoMo"; if carryer="docomo+w" then carryer="DoCoMo+W"; if carryer="vodafone" then carryer="Vodafone"; $B"c8eN,"d(B
$B"cA0N,"d(B
proc freq data=gakusei order=freq; : $BIQEY$N9b$$$b$N=g(B
tables sex jitaku carryer; :
run; :
:
proc freq data=gakusei order=freq; : $BIQEY$N9b$$$b$N=g(B
tables sex*jitaku; :
tables sex*carryer; :
tables jitaku*carryer; :
run; :
$B"c8eN,"d(B
/* Lesson 08-4 */
/* File Name = les0804.sas 11/22/06 */
data gakusei;
infile 'all06be.prn'
firstobs=2;
input sex $ shintyou taijyuu kyoui
jitaku $ kodukai carryer $ tsuuwa;
proc format; : $B3,5i$r:n$k!#(Bclass shintyou $B$N0U(B
value clshint low-<150=' -149' : $B3,5i$NDj5A(B 1
150-<160='150-159' : 2
160-<170='160-169' : 3
170-<180='170-179' : 4
180-high='180- ' : 5
other ='missing'; : 6
run; :
proc print data=gakusei(obs=5);
run;
proc freq data=gakusei; : $BIQEY$r;;=P(B
tables shintyou; : $B0lJQNL$4$H$K(B
format shintyou clshint.; : $BO"B3JQNL$r%0%k!<%W2=$9$k$3$H$N;XDj(B
run; :
:
proc freq data=gakusei; : $BIQEY$r;;=P(B
tables sex*shintyou; : $BFsJQNL$NAH9g$o$;$G(B
format shintyou clshint.; : $BO"B3JQNL$r%0%k!<%W2=$9$k$3$H$N;XDj(B
run; :
:
proc sort data=gakusei; : $B:#$^$G$NJ}K!$G
SAS $B%7%9%F%`(B 2
09:01 Wednesday, November 22, 2006
Cumulative Cumulative
SHINTYOU Frequency Percent Frequency Percent
------------------------------------------------------
-149 6 1.7 6 1.7
150-159 52 14.7 58 16.4
160-169 120 34.0 178 50.4
170-179 152 43.1 330 93.5
180- 23 6.5 353 100.0
Frequency Missing = 15
SAS $B%7%9%F%`(B 3
09:01 Wednesday, November 22, 2006
TABLE OF SEX BY SHINTYOU
SEX SHINTYOU
Frequency|
Percent |
Row Pct |
Col Pct | -149 |150-159 |160-169 |170-179 |180- | Total
---------+--------+--------+--------+--------+--------+
F | 6 | 50 | 56 | 2 | 0 | 114
| 1.70 | 14.20 | 15.91 | 0.57 | 0.00 | 32.39
| 5.26 | 43.86 | 49.12 | 1.75 | 0.00 |
| 100.00 | 96.15 | 47.06 | 1.32 | 0.00 |
---------+--------+--------+--------+--------+--------+
M | 0 | 2 | 63 | 150 | 23 | 238
| 0.00 | 0.57 | 17.90 | 42.61 | 6.53 | 67.61
| 0.00 | 0.84 | 26.47 | 63.03 | 9.66 |
| 0.00 | 3.85 | 52.94 | 98.68 | 100.00 |
---------+--------+--------+--------+--------+--------+
Total 6 52 119 152 23 352
1.70 14.77 33.81 43.18 6.53 100.00
Frequency Missing = 16
SAS $B%7%9%F%`(B 6
09:01 Wednesday, November 22, 2006
------------------------------- SEX=' ' --------------------------------
Cumulative Cumulative
SHINTYOU Frequency Percent Frequency Percent
------------------------------------------------------
160-169 1 100.0 1 100.0
Frequency Missing = 4
SAS $B%7%9%F%`(B 7
09:01 Wednesday, November 22, 2006
-------------------------------- SEX=F ---------------------------------
Cumulative Cumulative
SHINTYOU Frequency Percent Frequency Percent
------------------------------------------------------
-149 6 5.3 6 5.3
150-159 50 43.9 56 49.1
160-169 56 49.1 112 98.2
170-179 2 1.8 114 100.0
Frequency Missing = 7
SAS $B%7%9%F%`(B 8
09:01 Wednesday, November 22, 2006
-------------------------------- SEX=M ---------------------------------
Cumulative Cumulative
SHINTYOU Frequency Percent Frequency Percent
------------------------------------------------------
150-159 2 0.8 2 0.8
160-169 63 26.5 65 27.3
170-179 150 63.0 215 90.3
180- 23 9.7 238 100.0
Frequency Missing = 4