* advertising;
A 38 B 26 C 40
A 42 B 30 C 36
A 27 B 18 C 32
A 60 B 42 C 37
A 36 B 24 C 42
A 54 B 30 C 46
A 40 B 26 C 38

* ames70 macro variable;
 * (creating new categorical variables);
   AboveAverage_Quality=0; BelowAverage_Quality=0;
   AboveAverage_Condition=0; BelowAverage_Condition=0;
   if Overall_Quality=3 then AboveAverage_Quality=1;
   if Overall_Quality=1 then BelowAverage_Quality=1;
   if Overall_Condition=3 then AboveAverage_Condition=1;
   if Overall_Condition=1 then BelowAverage_Condition=1;
   if Heating_QC="Ex" then Excellent_Heat_QC=1;
      if Heating_QC="Gd" or Heating_QC="Fa" or Heating_QC="TA" 
      then Excellent_Heat_QC=0;
   if Lot_Shape="IRR" then Irreq_Lot_Shape=1;
      if Lot_Shape="Reg" then Irreq_Lot_Shape=0;
   if Central_Air="Y" then C_Air=1;
      if Central_Air="N" then C_Air=0;
   nbr_clus1=0; nbr_clus2=0; nbr_clus3=0;
   if neighborhood="NoRidge" or neighborhood="NridgHt" or 
      neighborhood="Somerst" or neighborhood="StoneBr" or 
      neighborhood="Timber" or neighborhood="Veenker" or 
      neighborhood="CollgCr" or neighborhood="Gilbert" or 
      neighborhood="ClearCr" then nbr_clus1=1;
   if neighborhood="NAmes" or neighborhood="SWISU" or 
      neighborhood="IDOTRR" or neighborhood="OldTown" or 
      neighborhood="Edwards" or neighborhood="BrkSide" or 
      neighborhood="Sawyer" then nbr_clus2=1;
   if neighborhood="Mitchel" then nbr_clus3=1;

 * (for varclus with 32 vars);
%let fullset=Gr_Liv_Area Total_Bsmt_SF Bsmt_Fin_SF Bsmt_Unf_SF Lot_Area
     Age_At_Sale Bedroom_AbvGr High_Kitchen_Quality Fullbath_2Plus 
     Fireplace_1Plus TwoPlusCar_Garage High_Exterior_Cond 
     High_Exterior_Qual One_Floor Vinyl_Siding CuldeSac Has_Fence
     Land_Level Poured_Concrete Paved_Driveway Total_Functionality 
     Normal_Prox_Cond AboveAverage_Quality BelowAverage_Quality 
     AboveAverage_Condition BelowAverage_Condition Excellent_Heat_QC 
     Irreq_Lot_Shape C_Air nbr_clus1 nbr_clus2 nbr_clus3;

%let reducedset=Age_at_Sale Total_Bsmt_SF Gr_Liv_Area Paved_Driveway
     Bsmt_Unf_SF Irreq_Lot_Shape Lot_Area Fullbath_2plus 
     Total_Functionality Normal_Prox_Cond nbr_clus3 AboveAverage_Condition
     High_Kitchen_Quality Has_Fence Fireplace_1plus Land_Level
     BelowAverage_Quality BelowAverage_Condition High_Exterior_Cond 
     CuldeSac C_Air One_Floor Vinyl_Siding;

* amesreg300: predictors
Gr_Liv_Area Total_Bsmt_SF Lot_Area
     Age_At_Sale High_Kitchen_Quality Fullbath_2Plus 
     Fireplace_1Plus TwoPlusCar_Garage High_Exterior_Cond 
     CuldeSac Has_Fence Land_Level

* amesreg300: predictors(glmselect);
Gr_Liv_Area Total_Bsmt_SF Lot_Area
     Age_At_Sale Overall_Quality High_Kitchen_Quality Fullbath_2Plus
     Fireplace_1Plus TwoPlusCar_Garage Vinyl_Siding Lot_Shape High_Exterior_Cond
     CuldeSac Has_Fence Land_Level Open_Porch_SF Garage_Area Bedroom_AbvGr

* ames70: predictors;
Gr_Liv_Area Total_Bsmt_SF Lot_Area
     Age_At_Sale Overall_Quality High_Kitchen_Quality Fullbath_2Plus
     Fireplace_1Plus TwoPlusCar_Garage High_Exterior_Cond
     CuldeSac Has_Fence Land_Level 

# bigcats
Name,Weight
Tiger,203
Leopard,64
Leopard,58
Lion,200


DATA CHILDREN;
INPUT WEIGHT HEIGHT AGE;
DATALINES;
64 57 8
71 59 10
53 49 6
67 62 11
55 51 8
58 50 8
77 55 10
57 48 9
56 42 10
51 42 6
76 61 12
68 57 9
;RUN;

# CIAdata1
country,lifeExp,urban,pcGDP
Finland,79.41,85,36700
Slovakia,76.03,55,23600
UK,80.17,80,36600
Ukraine,68.74,69,7300
Spain,81.27,77,31000

# CIAdata2
country,pcGDP,lifeExp,urban
Italy,30900,81.86,68
Croatia,18400,75.99,58
Slovakia,23600,76.03,55


# coffeeshop.csv
Date,Sales
21/NOV/2011,2144.88
22/NOV/2011,1702.99
23/NOV/2011,2731.45
24/NOV/2011,1943.04
25/NOV/2011,1862.09

# CPIdata
country,CPI
Spain,80.24
UK,100.13
Croatia,67.54
Italy,94.82
Ukraine,51.1
Finland,99.69
Spain,80.24


# customers
"Name","Address"
"Mr A. Jackson","17 Bridge Street, Reading, RG3 2QN"
"Ms D. Phillips","112 park avenue, reading, berkshire, RG21NY"
"Mrs S. O'Neill","Flat 1, 72 Norfolk Road, Maidenhead, SL6 7AZ"
"Mr D. Singh","373 Castle Lane, READING, RG5 2LL"
"Mr A. Rojas","2 Green Lane, Wokingham, RG40 2NA"

# endangered
Name,Status
Lion,Vulnerable
Leopard,Least Concern
Tiger,Endangered
Leopard,Endangered


DATA EXAMPLE;
INPUT AGE @@;
DATALINES;
12 11 12 12 9 11 8 8 7 11 12 14 9 10 7 13
6 11 12 4 11 9 13 6 9 7 13 9 13 12 10 13
11 8 11 15 12 14 10 10 13 13 10 8 12 7 13
11 9 12
;

DATA FERTILIZER;
INPUT FEEDTYPE WEIGHTGAIN;
DATALINES;
1 46.20
1 55.60
1 53.30
1 44.80
1 55.40
1 56.00
1 48.90
2 51.30
2 52.40
2 54.60
2 52.20
2 64.30
2 55.00
;run;

# flights.csv
Date,Time,Flight Number,Destination
12/01/2012,20:30,BE898,GLASGOW
12/01/2012,20:35,BE775,EDINBURGH
13/01/2012,06:50,BE382,DUBLIN
13/01/2012,07:00,BE861,MANCHESTER
13/01/2012,07:05,BE1011,AMSTERDAM
13/01/2012,08:00,AF6541,RENNES
13/01/2012,08:00,BE3025,RENNES


# fruit.csv
Product,Price,Unit
Apricots,10,per kg
Baby Watermelon,2,each
Bananas,0.68,per kg
Blush Pears,2.1,per kg
Braeburn Apples,1.65,per kg
Bramley Cooking Apples,1.55,per kg
Cantaloupe Melon,2,each

# grades1
ClassA,ClassB,ClassC
87,83,80
64,97,86
89,97,80
82,99,80
59,92,84


DATA grow;
INPUT BRAND $ HEIGHT;
DATALINES;
   A   20.00
   A   23.00
   A   32.00
   A   24.00
   A   25.00
   A   28.00
   A   27.50
   B   25.00
   B   46.00
   B   56.00
   B   45.00
   B   46.00
   B   51.00
   B   34.00
   B   47.50
;run;

* heights; mixed effects;
DATA HEIGHTS; 
INPUT FAMILY GENDER$ HEIGHT @@; 
DATALINES; 
   1 F 67   1 F 66   1 F 64   1 M 71   1 M 72   2 F 63 
   2 F 63   2 F 67   2 M 69   2 M 68   2 M 70   3 F 63 
   3 M 64   4 F 67   4 F 66   4 M 67   4 M 67   4 M 69 
   ;

* housing3;
data housing;
input ID SqFt SalePrice  @@;
   datalines;
  1  1050 175 2  2100 120 3  1050 80  4  2800 170  4 3150 155 
   6  3000 275 7  6500 50  8  3500 280 9  700  90  10 1750 218 
   11 3800 325 12 2100 210 13 2450 120 14 3850 270 15 4300 275 
;

* liver;
data liver;
   input time $ group $ status $ count @@;
datalines;
early   antidote severe 6 early   antidote not 12
early   control  severe 6 early   control  not  2
delayed antidote severe 3 delayed antidote not 4
delayed control  severe 3 delayed control  not 0
late    antidote severe 5 late    antidote not 1
late    control  severe 6 late    control  not 0
;


# pulserates.csv
Patient,Pulse1,Pulse2,Pulse3
3051,70,77,73
3052,65,66,56
3053,64,58,60
3054,53,58,56


* repmixed;
DATA REPMIXED(KEEP= SUBJECT GENDER TIME OUTCOME);
INPUT SUBJECT GENDER $ HOUR1-HOUR4 ;
OUTCOME = HOUR1;  TIME = 1; OUTPUT;
OUTCOME = HOUR2;  TIME = 2; OUTPUT;
OUTCOME = HOUR3;  TIME = 3; OUTPUT;
OUTCOME = HOUR4;  TIME = 4; OUTPUT;
DATALINES;
1	M	1	1.5	6	5.1
2	M	4	2.2	6.1	5.2
3	M	5.2	4.1	5.8	3.2
4	F	5.1	3.3	5.2	4.8
5	F	6.3	4.9	7.9	6.9
6	F	8.2	5.9	9.5	9.1
7   F   8.3 6.1  .  9.2
;

data retailer1;
time amount
5 50.97 
6 54.17 
6 51.31 
6 57.56 
7 69.01 
7 60.17 
7 54.12 
8 58.50 
9 53.58 
9 55.85 

data retailer2;
time amount
2     1   85.1
2     5   83.6
2     6   54.8
2     7   61.2
2     7   73.0
2     8   60.8
2     8   75.8
2     8   69.7
2     9   82.5
2    11   65.1

data all; * retailer1+retailer2;
time amount
1     5   51.0
2     1   85.1
1     6   54.2
2     5   83.6
1     6   51.3
2     6   54.8
1     6   57.6
2     7   61.2
1     7   69.0
2     7   73.0
1     7   60.2
2     8   60.8
1     7   54.1
2     8   75.8
1     8   58.5
2     8   69.7
1     9   53.6
2     9   82.5
1     9   55.8
2    11   65.1

* data sunglasses;
Store Price_X Qty_Sold_Y 
1 12 65 
2 18 50 
3 23 36 
4 28 30 
5 32 29 


Volume
484.11
459.49
471.38
512.01
494.48
528.63
493.64
485.03
473.88
501.59
502.85
538.08
465.68
495.03
475.32
529.41
518.13
464.32
449.08
489.27


# WHOdata
alcohol,mortality
12.52,91
13.33,130
13.37,77
15.6,274
11.62,68

# vitalsigns
subject,test,result
1733,Pulse,120
1733,DiaBP,79
1733,SysBP,79
1734,Pulse,121
1734,DiaBP,86
1734,SysBP,72
1735,Pulse,130
1735,DiaBP,94
1735,SysBP,74
1736,Pulse,142
1736,DiaBP,99
1736,SysBP,87


* Merge statement;

data name;

Mary    insadong
Tom     samsundong
Jenny   Myungdong
Sam     gaepodong
Greene  hyehwadong

data post;

insadong    111
shinchon    222
samsundong  333
daehakro    444
jongno      555
euljiro     666
Myungdong   777
gaepodong   888
hyehwadong  999


DATA D1;
   INPUT   #1  @1  (V1-V6)   (1.)
               @8  (COMMIT)  (2.) ;
CARDS;
776122 24
776111 28
111425  4
222633 24
551666  4
666524  4
633112 24
766212 23
454444 17
111332  8
444343 21
556212 20
543332 11
677222 27
666234 15
557322  6
555221 18
544111 17
424232 28
445435 13
767232 13
444422  8
653211 15
555323 16
655123 17
221121 11
666421 20
454332  9
655321 25
444332 12
433222 27
777314 16
555212  7
443221  4
243334 11
666111 15
423412 11
555222 18
223332  8
333335 13
445433 22
444323 12
455556 22
444112 17
334445 12
444321 16
655222 15
433344 15
557332 20
655222 13
;run;

/* ====
7 = Very Frequently
6 = Frequently
5 = Somewhat Frequently
4 = Occasionally
3 = Seldom
2 = Almost Never
1 = Never

1 2 3 4 5 6 7   1. Went out of my way to do a favor for a coworker
1 2 3 4 5 6 7   2. Went out of my way to do a favor for a relative
1 2 3 4 5 6 7   3. Went out of my way to do a favor for a friend
1 2 3 4 5 6 7   4. Give money to a religious charity 
1 2 3 4 5 6 7   5. Give money to a religious charity not associated with a religion
1 2 3 4 5 6 7   6. Give money to a panhandler
===== */




DATA D1_alpha;
   INPUT   #1  @1  (V1-V6)   (1.) ;
CARDS;
556754
567343
777222
665243
666665
353324
767153
666656
334333
567232
445332
555232
546264
436663
265454
757774
635171
667777
657375
545554
557231
666222
656111
464555
465771
142441
675334
665131
666443
244342
464452
654665
775221
657333
666664
545333
353434
666676
667461
544444
666443
676556
676444
676222
545111
777443
566443
767151
455323
455544
;run;


* ex2-9;

 6.5  4.0  7.1  8.3  5.4  7.6  9.0 15.7 16.7
 6.4  5.0  8.5  5.7  7.7  7.2 12.4  7.1  5.5
 9.7  4.4  7.0  6.3  8.3  6.9  5.7  7.6  7.9
 7.9  6.0  8.2 10.4  9.9  3.9  9.8  8.2  5.6
 7.9  6.4  7.4  7.0 13.0  8.7  6.4  6.7  7.4

ex29<-c(
 6.5, 4.0,  7.1,  8.3,  5.4,  7.6,  9.0, 15.7, 16.7,
 6.4, 5.0,  8.5,  5.7,  7.7,  7.2, 12.4,  7.1,  5.5,
 9.7, 4.4,  7.0,  6.3,  8.3,  6.9,  5.7,  7.6,  7.9,
 7.9, 6.0,  8.2, 10.4,  9.9,  3.9,  9.8,  8.2,  5.6,
 7.9, 6.4,  7.4,  7.0, 13.0,  8.7,  6.4,  6.7,  7.4
)


data examinat;
 set examinat;
     if math >= 90 then grade_m='A';
else if math >= 80 then grade_m='B';
else if math >= 70 then grade_m='C';
else if math >= 60 then grade_m='D';
else grade_m='F';
     if engl >= 90 then grade_e='A';
else if engl >= 80 then grade_e='B';
else if engl >= 70 then grade_e='C';
else if engl >= 60 then grade_e='D';
else grade_e='F';
run;


* birthday data(for fields)

Kyle          17  Aug 14 1981   skiing
Kelly         15  Jul 10 1983   baseball
Kristopher    16  Nov 13 1982   hunting
Nicholas      14  Aug 24 1984   4-wheeling

* yr1998
day   temperature weather
-------------------------
Jan 1  33  sun
Jan 2  35  sun
Jan 3  45  clouds
Jan 5  28  snow

* yr1999
day   temperature weather
-------------------------
Jan 1  25
Jan 2  20
Jan 3  35
Jan 6  40
Jan 8  39


* ex318;

38 174 13 58 26 155 80 26 51 46
19 134 69 30 39 29 37 47 9 52

* ex320;

3.6 1
3.7 1
3.8 6
3.9 6
4.0 10
4.1 10
4.2 13
4.3 11
4.4 13
4.5 7
4.6 6
4.7 7
4.8 5
4.9 4

* ex323;

38 174 13 58 26 155 80 26 51 46
19 134 69 30 39  29 37 47  9 52

* ex812;

 1 82 1 78 1 77 1 76 1 74 1 80 1 71 1 84 1 77 1 83
 2 75 2 73 2 78 2 72 2 68 2 72 2 72 2 68 2 75 2 70

* ex813;

1 224 202
2 270 228
3 253 217
4 265 220
5 281 229


* ex814

  1   98.4   97.5
  2  103.3  105.8
  3  112.1  113.4
  4   77.6   69.9
  5   80.5   81.2
  6  112.8  118.4
  7   84.5   88.1
  8  100.9  100.8
  9   85.6   86.7
 10   74.9   73.8

* pr85

  1   9.4   8.1
  2   7.5   6.7
  3   8.2   7.7
  4  12.1  10.4
  5  11.2   9.6
  6   6.8   6.2
  7   7.2   7.0
  8  11.4   9.6


* pr8-7 (Á¤ºñ¾÷¼ÒÀÇ Á¤ºñºñ¿ë)

   A        B
  -------------
   576      584
   818      756
   585      552
   924      857
   795      748
   854      884
   921      878
   694      675
   684      680
   832      813

* ex911;
-------
1    1    25
1    2    28
1    3    23
2    1    28
2    2    31
2    3    26
3    1    24
3    2    27
3    3    22
------
1    1    25
1    2    28
1    3    23
2    1    36
2    2    31
2    3    26
3    1    27
3    2    32
3    3    31



* ex93;
 brand life;

 1 36  2 38  3 35
 1 42  2 36  3 38
 1 38  2 35  3 37
 1 36  2 27  3 34

* ex94;
 temperat x

1 2.64  2 2.72  3 2.98  4 2.89
1 2.62  2 2.84  3 2.96  4 2.97
1 2.63  2 2.78  3 2.92  4 2.92
1 2.66  2 2.81  3 2.89  4 2.92
1 2.68  2 2.86  3 2.97  4 2.88

temp x
1 2.64  
1 2.62  
1 2.63  
1 2.66  
1 2.68  
2 2.72  
2 2.84  
2 2.78  
2 2.81  
2 2.86  
3 2.98  
3 2.96  
3 2.92  
3 2.89  
3 2.97  
4 2.89 
4 2.97 
4 2.92 
4 2.92 
4 2.88 


* ex95;
 block appraise value

1 A1 184  1 A2 204  1 A3 182
2 A1  57  2 A2  76  2 A3  68
3 A1 102  3 A2 103  3 A3  98
4 A1 228  4 A2 239  4 A3 214

* ex98;
 driver auto x @@;

1 1  9.4  1 2  9.8  1 3 11.1
2 1 13.1  2 2 12.4  2 3 14.2
3 1 11.4  3 2 10.8  3 3 14.8

* ex98: long;
drive auto x
1 1  9.4  
1 2  9.8  
1 3 11.1
2 1 13.1  
2 2 12.4  
2 3 14.2
3 1 11.4  
3 2 10.8  
3 3 14.8


* ex913;
 road brand x @@;
 1 1 34 1 1 29 1 1 24 1 1 36 1 1 25
 1 2 24 1 2 20 1 2 18 1 2 20 1 2 19
 1 3 32 1 3 24 1 3 36 1 3 25 1 3 23
 2 1 26 2 1 25 2 1 18 2 1 31 2 1 27
 2 2 22 2 2 17 2 2 20 2 2 22 2 2 17
 2 3 28 2 3 24 2 3 34 2 3 27 2 3 20

* ex913
road brand x
1    1    34
1    1    29
1    1    24
1    1    36
1    1    25
1    2    24
1    2    20
1    2    18
1    2    20
1    2    19
1    3    32
1    3    24
1    3    36
1    3    25
1    3    23
2    1    26
2    1    25
2    1    18
2    1    31
2    1    27
2    2    22
2    2    17
2    2    20
2    2    22
2    2    17
2    3    28
2    3    24
2    3    34
2    3    27
2    3    20

* ex125

price period freq
1 1 22
1 2 11
2 1 15
2 2 32
3 1  5
3 2 10

* pudding;
 flavour sweet pref
-----------------------------------
 va 1 9 va 1 7 va 1 8 va 1 7
 va 2 8 va 2 7 va 2 8
 va 3 6 va 3 5 va 3 7
 ch 1 9 ch 1 9 ch 1 7 ch 1 7 ch 1 8
 ch 2 8 ch 2 7 ch 2 6 ch 2 8
 ch 3 4 ch 3 5 ch 3 6 ch 3 4 ch 3 4

* math and IQ
group     math    iq
---------------------
 A        260    105
 B        324    126
 A        325    115
 B        440    135
 A        300    122
 B        425    142
 A        400    125
 B        500    140
 A        390    138
 B        600    160




group$   score    age    height    time
---------------------------------------
  A        90      16      182      4.8
  B        92      18      181      4.6
  C        97      18      185      5.4
  A        88      15      177      3.8
  B        88      13      177      3.8
  C        92      17      180      4.4
  A        72      12      163      1.0
  B        76      12      164      1.2
  C        88      16      179      4.2
  A        82      14      170      2.4
  B        78      14      166      1.6
  C        92      17      180      4.4
  A        65      12      158      0.5
  B        90      17      179      4.2
  C        99      17      190      6.4
  A        74      13      165      1.4
  B        68      12      158      0.5
  C        82      14      172      2.8

* ex111
  y       x1       x2
---------------------
 45.1    2450      45
 56.8    2404      32
 59.7    1554      14
 56.4    1784      10
 59.2    1684      28
 63.4    2472      30
 69.3    2144       8
 65.6    2458       9
 89.5    2714       4
101.4    3073       7
108.7    3269       6
 98.1    4534      11

* ex1214

branch contract
---------------
A 14 A 17 A 21 A 20 A 24
B 26 B 18 B 20 B 23 B 27 B 15 B 19
C 27 C 23 C 33 C 29 C 32 C 35

* ex127(Spearman's Rank Correlation);

5 4 4 5 8 8 2 3 3 1 7 6 1 2 6 7


* ex136;
 y
16.9 19.9 20.6 23.2
18.9 23.7 23.1 26.7
20.7 24.0 23.1 25.7
21.1 25.3 25.2 30.1



* ex137;
 year y
1970  768  1971  880  1972  922  1973 1226  1974 1069
1975 1095  1976 1302  1977 1634  1978 1985  1979 2478
1980 2969  1981 3515  1982 3300  1983 4127  1984 4140
1985 4132

* Migraine;
Gender $ Treatment $ Response $ Count 
female Active  Better 16   female Active  Same 11
female Placebo Better  5   female Placebo Same 20
male   Active  Better 12   male   Active  Same 16
male   Placebo Better  7   male   Placebo Same 19


* Aspirin and Tylenol;

 Aspirin         Tylenol
 -------------------
   40             35
   42             37
   48             42
   35             22
   62             38
   35             29

* Chocolate Sales;

/* chocosales.dat */
code sales
----------
C865 15
K086  9
A536 21
S163 34
K014  1
A206 12
B713 29


/* choconame.dat */
code $ 1-4 name $ 6-14 description $ 16-60
---------------------------------------------------
A206 Mokka     Coffee buttercream in dark chocolate
A536 Walnoot   Walnut halves in bed of dark chocolate
B713 Frambozen Raspberry marzipan covered in milk chocolate
C865 Vanille   Vanilla-flavored rolled in ground hazelnuts
K014 Kroon     Milk chocolate with a mint cream center
K086 Koning    Hazelnut paste in dark chocolate
M315 Pyramide  White with dark chocolate trimming
S163 Orbais    Chocolate cream in dark chocolate


* dcf2;

 STOCK1    STOCK2    STOCK3
---------------------------
  1.50      2.01      2.07
  1.60      2.28      2.12
  1.65      2.50      2.16
  1.70      2.63      2.16
  1.75      2.70      2.16
  1.80      2.86      2.16
  1.86      2.94      2.18
  2.12      3.02      2.23
  2.60      3.10      2.30
  2.82      3.16      2.40


* Monthly Rents of 29 Apartment($,1993)

 750.0    610    675    630    565
 625.0    650    780    600    600
 777.5    870    750    720    600
 600.0    650    625    675    700
 700.0    620    750    695    735
 850.0    750    600    805

* Home Gardener;

name tomato zucchini pea grape zone
------------------------------
Gregor  10  2  40    0 14
Molly   15  5  10 1000 14
Luther  50 10  15   50 14
Susan   20  0   .   20 14

* new data;
utilization  Age Num_loans   Num_dependents  MonthlyIncome   DebtRatio;
.30 34  2   3   8000    .20
.70 40  5   4   5000    .45
.70 50  5   4   2500    .55

* To determin whether a reading program could improve the reading speed;
Subj Before After
1 100 110  2 120 121  3 130 140  4 90 110  5 85 92
6 133 137  7 210 209  8 155 179



* smoke by job;
input job smoke count;
A y 220 A n 80
B y 212 B n 88
C y  80 C n 120
D y 105 D n 95

* Social Security;
Social Security No.  Annual Salary    Age    Race
----------------------------------------------
123874414   28000   35   W
646239182   29500   37   B
012437652   35100   40   W
018451357   26500   31   W

* Supermarket

18 21 22 19 34 32 40 42
56 58 64 28 29 29 36 35

* trend;
data trend;
 input outcome $ dose count;
 cards;
Success 1 8
Success 2 8
Success 3 10
Success 4 15
Failure 1 12
Failure 2 12
Failure 3 10
Failure 4 5
;run;



* DVD Sales;

/* DVD Sales */
name $ 1-29 exercisetype $ price
--------------------------------
Adorable Abs                    aerobics 12.99
Aerobic Childcare for Parents   aerobics 13.99
Judy Murphy's Fun Fitness       step     12.99
Lavonnes' Low Impact Workout    aerobics 13.99
Muscle Makers                   weights  15.99
Rock N Roll Step Workout        step     12.99


/* DVDdisc.dat */
exercisetype $ discount
----------------------
aerobics        .20
step            .30
weights         .25




* Web Site;
month  visit(1000)
Jan 1610  Feb 1585  Mar 1649  Apr 1590
May 1540  Jun 1397  Jul 1410  Aug 1350
Sep 1495  Oct 1564  Nov 1602  Dec 1655

* Employee Compensation;

(Healthe Service Worker)
20.1 19.8 22.36 18.75 21.9 22.96 20.75
(Educational Service Worker)
26.19 23.88 25.5 21.64 24.85 25.3 24.12 23.45

* plastic housing;
day supplier1 supplier2 supplier3 suppler4
mon 62 63 57 61
tue 63 61 59 65
wed 61 62 56 63
thu 62 60 57 64
fri 64 63 58 66

/* IRON AND STEEL EXPORTS EXCLUDING SCRAPS(1937-1980) */
data steel;

export
3.89 2.41 2.8 8.72 7.12 7.24 7.15 6.05 5.21 5.03 6.88 4.7 5.06 3.16
3.62 4.55 2.43 3.16 4.55 5.17 6.95 3.46 2.13 3.47 2.79 2.52 2.8 4.04
3.08 2.28 2.17 2.78 5.94 8.14 3.55 3.61 5.06 7.13 4.15 3.86 3.22
3.5 3.76 5.11


data examinat;
 input last $ first $9. sex $ math engl;
 tot=math+engl;
 avg=tot/2;
 cards;
KIM  LUCKY      M       58.9    77.8
CHOI SUNGSU     M       67.7    45.9
CHOI MINYOU     F       91.0    82.6
PARK KISUK      F       46.0    89.2
SOHN SUKIM      F       56.4    67.9
LEE  YONGHO     M       78.9    56.7
PARK CHANYOUNG  M       45.6    76.8
KIM  INYOUNG    F       66.7    88.2
MIN  UK         M       63.5    78.1
KIM  HANJIN     M       78.4    87.5
HONG KILDONG    M       34.2    67.8
YOU  KONGJU     F       56.9    78.5
;run;
proc sort data=examinat out=examsort;
 by descending avg;
run;
data examsort;
 set examsort;
 rank=_n_;
run;
proc print ;run;

=============
data amex1;
 set amex1;
  volume=vol_adv+vol_dec+vol_unc;
  percent=(close-lag(close))/lag(close);
run;

data q.djm;
label djm='Dow Jones Index';
input date:monyy5.   djm @@;
format date monyy5.;
day=intnx('month','01dec82'd,_n_);
format day monyy7.;
cards;
....
run;

data q.amex2;
 set q.amex1 (obs=25);
 day1=weekday(day);
run;

proc format;
 value wk_day 2='Mon' 3='Tue' 4='Wed' 5='Thu' 6='Fri';
run;

proc print ;
format day1 wk_day.;
run;

proc gchart data=q.amex2;
 format day1 wk_day.;
 vbar day1 / type=mean sumvar=volume; * (type mean);
 run;

* LG Display ;

date        close
01-02-09    23400
01-05-09    24400
01-06-09    25250
01-07-09    25600
01-08-09    24500
01-09-09    23750
01-12-09    23550
01-13-09    24300
01-14-09    25300
01-15-09    22800
01-16-09    24100
01-19-09    26000
01-20-09    25200
01-21-09    24850
01-22-09    24750
01-23-09    24550
01-28-09    26750
01-29-09    26800
01-30-09    26800
02-02-09    27300
02-03-09    27350
02-04-09    28550
02-05-09    28000
02-06-09    28650
02-09-09    28050
02-10-09    27650
02-11-09    27900
02-12-09    27150
02-13-09    27500
02-16-09    26950
02-17-09    25900
02-18-09    26050
02-19-09    26500
02-20-09    25500
02-23-09    26800
02-24-09    26550
02-25-09    26750
02-26-09    24550
02-27-09    25500
03-02-09    24650
03-03-09    25650
03-04-09    27100
03-05-09    26700
03-06-09    27100
03-09-09    27800
03-10-09    27250
03-11-09    27700
03-12-09    25900
03-13-09    26400
03-16-09    26750
03-17-09    27300
03-18-09    27400
03-19-09    26300
03-20-09    26450
03-23-09    27000
03-24-09    27550
03-25-09    28200
03-26-09    28800
03-27-09    28550
03-30-09    27350
03-31-09    28050
04-01-09    28750
04-02-09    30200
04-03-09    30300
04-06-09    31200
04-07-09    31650
04-08-09    30500
04-09-09    31300
04-10-09    32100
04-13-09    31850
04-14-09    31900
04-15-09    31250
04-16-09    31150
04-17-09    31450
04-20-09    31800
04-21-09    32100
04-22-09    33500
04-23-09    34100
04-24-09    33400
04-27-09    32400
04-28-09    31000
04-29-09    31500
04-30-09    31300
05-04-09    31450
05-06-09    31400
05-07-09    31000
05-08-09    31400
05-11-09    31950
05-12-09    31200
05-13-09    30900
05-14-09    29650
05-15-09    29400
05-18-09    28900
05-19-09    29850
05-20-09    30150
05-21-09    29700
05-22-09    28400
05-25-09    28250
05-26-09    28000
05-27-09    28350
05-28-09    28900
05-29-09    29600
06-01-09    28700
06-02-09    28650
06-03-09    29100
06-04-09    29250
06-05-09    30650
06-08-09    31500
06-09-09    30950
06-10-09    31350
06-11-09    31550
06-12-09    31150
06-15-09    30600
06-16-09    30800
06-17-09    31000
06-18-09    30500
06-19-09    30500
06-22-09    31300
06-23-09    31200
06-24-09    32050
06-25-09    32300
06-26-09    32000
06-29-09    32250
06-30-09    31800
07-01-09    31850
07-02-09    32450
07-03-09    33600
07-06-09    33900
07-07-09    34300
07-08-09    34400
07-09-09    34500
07-10-09    34000
07-13-09    33300
07-14-09    33900
07-15-09    34500
07-16-09    34800
07-17-09    35600
07-20-09    37050
07-21-09    37150
07-22-09    37100
07-23-09    37200
07-24-09    36250
07-27-09    37000
07-28-09    36500
07-29-09    35800
07-30-09    35500
07-31-09    35450
08-03-09    36000
08-04-09    35200
08-05-09    34050
08-06-09    34650
08-07-09    34300
08-10-09    33800
08-11-09    34400
08-12-09    34750
08-13-09    36000
08-14-09    37200
08-17-09    36800
08-18-09    36650
08-19-09    36450
08-20-09    36600
08-21-09    35850
08-24-09    35350
08-25-09    36250
08-26-09    37550
08-27-09    36800
08-28-09    36900
08-31-09    36900
09-01-09    37050
09-02-09    39250
09-03-09    38750
09-04-09    38800
09-07-09    38400
09-08-09    37650
09-09-09    36600
09-10-09    36750
09-11-09    36000
09-14-09    34750
09-15-09    35000
09-16-09    34650
09-17-09    35050
09-18-09    34800
09-21-09    34550
09-22-09    34100
09-23-09    34600
09-24-09    34600
09-25-09    34200
09-28-09    33250
09-29-09    33950
09-30-09    33900
10-01-09    33600
10-05-09    32350
10-06-09    32150
10-07-09    33050
10-08-09    33200
10-09-09    33600
10-12-09    33300
10-13-09    33500
10-14-09    33200
10-15-09    33250
10-16-09    31850
10-19-09    31850
10-20-09    32900
10-21-09    32750
10-22-09    31950
10-23-09    31350
10-26-09    31250
10-27-09    30450
10-28-09    29250
10-29-09    29300
10-30-09    28850
11-02-09    28900
11-03-09    29250
11-04-09    29900
11-05-09    29650
11-06-09    29800
11-09-09    29150
11-10-09    29350
11-11-09    30000
11-12-09    29600
11-13-09    30750
11-16-09    31500
11-17-09    31400
11-18-09    31400
11-19-09    31500
11-20-09    31700
11-23-09    32000
11-24-09    32150
11-25-09    32150
11-26-09    32200
11-27-09    30950
11-30-09    32050
12-01-09    34000
12-02-09    34350
12-03-09    35000

/* Social Security Number */

Social Security No.  Annual Salary    Age    Race
123874414       28000   35      W
646239182       29500   37      B
012437652       35100   40      W
018451357       26500   31      W




/* Cert */

data demog;
 input id $ 1-4 age 7-8 sex $ 11 date:mmddyy8.;
 format date mmddyy8.;
 cards;
A002  32  m  06/15/63
A003  24  f  08/17/72
A005  44  f  02/24/52
A007  39  m  11/11/57
A001  21  m  05/22/75
A004   .     03/27/69
;run;

proc sort data=demog;
 by id;
run;

data visit;
 input id $ 1-4 visit $  SysBP DiasBP Weight Date:mmddyy8.;
 format Date mmddyy8.;
 cards;
A001 1 140 85 195 07/04/98
A001 2 138 90 198 10/13/98
A001 3 145 95 200 11/05/98
A002 1 121 75 168 04/14/98
A003 1 118 68 125 08/12/98
A003 2 112 65 123 08/21/98
A004 1 143 88 204 03/30/98
A005 1 132 78 174 02/27/98
A005 2 132 78 175 07/11/98
A005 3 134 78 176 04/16/98
A008 1 128 80 182 05/23/98
;run;


data clients;
 input name $ 1-12 EmpID;
 cards;
ANKERTON, L.  11123
DAVIS, R.     22298
MASTERS, T.   33351
WOLMER, B.    44483
;run;

data Amounts;
 input name $ 1-12 Date:date7. Amt;
 format Date date7.;
 cards;
ANKERTON, L.  08OCT96 92
ANKERTON, L.  15OCT96 43
DAVIS, R.     04OCT96 16
MASTERS, T.   13OCT96 18
MASTERS, T.      .    27
THOMAS, A.    21OCT96 15
;run;

data exercise;
 input id $ 1-4 age 6-7 ActLevel $ 9-12 se $ 14;
 cards;
2810 61 MOD  F
2804 38 HIGH F
2807 42 LOW  M
2816 26 HIGH M
2833 32 MOD  F
2823 29 HIGH M
;run;


data Reps;
 input id name $ 3-17;
 cards;
1 Nay Rong
2 Kelly Windsor
3 Julio Meraz
4 Richard Krabill
;

data Close;
 input id Sale:dollar7.;
 format sale dollar7.;
 cards;
1 $28,000
2 $30,000
2 $40,000
3 $15,000
3 $20,000
3 $25,000
4 $35,000
;
data Bonus;
 input id Bonus:dollar7.;
 format Bonus dollar7.;
 cards;
1 $2,000
2 $4,000
3 $3,000
4 $2,500
;run;


/* SASCert_C6  */


data hrdtemp;
 input City $1-11 State $ Zip phone StartDate EndDate PayRate $ Days Hours;
 cards;
CARY        NC  27513   6224549 14567   14621   10  11   88
CART        NC  27513   6223251 14524   14565   8   25  200
CHAPEL HILL NC  27514   9974749 14570   14609   40  26  208
RALEIGH     NC  27612   6970450 14516   14527   15  10   80
;run;

data sasuser.temp;
   attrib Address length=$19;
   attrib City length=$11;
   attrib State length=$2;
   attrib Zip length=$5;
   attrib Phone length=$7;
   attrib Startdate length=5 format=date9.;
   attrib Enddate length=5  format=date9.;
   attrib Payrate length=$2;
   attrib Days length=$2;
   attrib Hours length=3;
   attrib Birthdate length=4 format=date9.;
   attrib Job length=$29;
   attrib Contact length=$16;
   attrib Dept length=$4;
   attrib Site length=$02;

   infile datalines dsd;
   input
    Address
    City
        State
        Zip
        Phone
        Startdate
        Enddate
        Payrate
        Days
        Hours
        Birthdate
        Job
        Contact
        Dept
        Site
;
datalines4;
65 ELM DR,CARY,NC,27513,6224549,14567,14621,10,11,088,7054,Word Processing,WORD PROCESSOR,DP,26
11 SUN DR,CARY,NC,27513,6223251,14524,14565, 8,25,200,5757,Filing Admin.Duties,ADMIN. ASST.,PURH,57
712 HARDWICK STREET,CHAPEL HILL,NC,27514,9974749,14570,14608,40,26,208,3156,Organizational Dev. Specialist,CONSULTANT,PERS,34
5372 WHITEBUD ROAD,RALEIGH,NC,27612,6970540,14516,14527,15,10,080,6097,Bookkeeping Word Processing,BOOKKEEPER ASST.,BK,57
11 TALYN COURT,DURHAM,NC,27713,3633618,14550,14561,12, 9,072,4327,Word Processing sec. work,WORD PROCESSOR,DP,95
101 HYNERIAN DR,CARRBORO,NC,27510,9976732,14564,14613,15, 7,064,5644,Bookkeeping Word Processing,BOOKKEEPER ASST.,BK,44
11 RYGEL ROAD,CHAPEL HILL,NC,27514,9972070,14093,14108,12,12,096,5644,Word Processing,WORD PROCESSOR,DP,59
121 E. MOYA STREET,DURHAM,NC,27713,3633020,14158,14162,10,25,040,4347,Word Processing sec. work,WORD PROCESSOR,PUB,38
1905 DOCK STREET,CARY,NC,27513,6565303,14168,14172,10, 5,030,4327,Word Processing,WORD PROCESSOR,DP,44
1304 CRESCENT AVE,RALEIGH,NC,27612,4341557,14178,14182,15, 5,025,4527,Word Processing,WORD PROCESSOR,DP,90
;;;;
run;

data z.dec_review;
 input Site $ 1-11 Day Rate $ Name $ 21-31;
 cards;
Westin      12  A2  Mitchell, K
Stockton     4  A5  Worton, M
Center City 17  B1  Smith, A.
;run;


data temp;
 input agency $ 1-28 id $ Name $ 41-64;
 cards;
Administrative Support, Inc.    F274    CICHOCK, ELIZABETH MARIE
Administrative Support, Inc.    F101    BENINCASA, HANNAH LEE
OD Consulting, Inc.             F054    SHERE, BRIAN THOMAS
New Time Temps Agency           F077    HODNOFF, RICHARD LEE
;run;

data temp;
 input agency $ 1-28 id $ LastName$ 41-49 FirstName $ 53-61 MiddleName $ 65-70;
 cards;
Administrative Support, Inc.    F274    CICHOCK     ELIZABETH   MARIE
Administrative Support, Inc.    F101    BENINCASA   HANNAH      LEE
OD Consulting, Inc.             F054    SHERE       BRIAN       THOMAS
New Time Temps Agency                   F077    HODNOFF     RICHARD     LEE
;run;

data before;
 input Name $29.;
 cards;
Mrs. Millicent Garett Fawcett
Miss Charlotte Despard
Mrs. Emmeline Pankhurst
Miss Sylvia Pankhurst
;run;


/* Fig11.7  */

data z.usa;
 input manager $ JobType $ Payroll;
 cards;
Coxe    3    40710.0
Coxe    50   41040.0
Coxe    50   82350.0
Coxe    240  27300.0
Coxe    240  54270.0
Delgado 240  35520.0
Delgado 240  63120.0
Delgado 420  18870.0
Delgado 420  45830.0
Delgado 440  21759.6
Overby  1    82270.8
Overby  5    48550.2
Overby  10   53766.0
Overby  20   70929.0
Overby  20  108885.0
;run;


/* SASCert: C13P408 */


data newtemp;
 input City $ 1-11 State $ Zip $ Phone StartDate EndDate PayRate $ Days Hours;
 cards;
CARY        NC 27513 6224549 14567 14621 10  11  88
CARY        NC 27513 6223251 14524 14565 8   25 200
CHAPEL HILL NC 27514 9974749 14570 14608 40  26 208
RALEIGH     NC 27612 6970450 14516 14527 15  10  80
;run;


/* SASCert: C16P515 */
1---+----10---+----20---+----30
BIRD FEEDER   LG088  3 20
GLASS MUGS    SB082  6 12




/* SASCert: C16 */

EVANS   DONNY 112 29,996.63
HELMS   LISA  105 18,567.23
HIGGINS JOHN  111 25,309.00
LARSON  AMY   113 32,696.78
MOORE   MARY  112 28,945.89
POWELL  JASON 103 35,099.50
RILEY   JUDY  111 25,309.00


/* c16P527 */

BED/BATH    1,354.93*
HOUSEWARES  2,464.05*
GARDEN      923.34*
GRILL       598.34*
SHOES       1,345.82*
SPORTS*
TOYS        6,536.53*

/* C16P538 */

MALE 27 1 8 0 0
FEMALE 29 3 14 5 10
FEMALE 34 2 10 3 3
MALE 35 2 12 4 8
FEMALE 36 4 16 3 7
MALE 21 1 5 0 0
MALE 25 2 9 2 1
FEMALE 21 1 4 2 6
MALE 38 3 11 4 3
FEMALE 30 3 5 1 0

MALE,27,1,8,0,0
FEMALE,29,3,14,5,10
FEMALE,34,2,10,3,3
MALE,35,2,12,4,8
FEMALE,36,4,16,3,7
MALE,21,1,5,0,0
MALE,25,2,9,2,1
FEMALE,21,1,4,2,6
MALE,38,3,11,4,3
FEMALE,30,3,5,1,0

data phonesurvey;
 input IDnum $ Ques1-Ques5;
 cards;
1000 23 94 56 85 99
1001 26 55 49 87 85
1002 33 99 54 82 94
1003 71 33 22 44 92
1004 88 49 29 57 83
;run;

MALE*27*1*8*0*0
FEMALE*29*3*14*5*10
FEMALE*34*2*10*3*3
MALE*35*2*12*4*8
FEMALE*36*4*16*3*7
MALE*21*1*5*0*0
MALE*25*2*9*2*1
FEMALE*21*1*4*2*6
FEMALE*30*3*5*1*0

data growth;
 length City $ 12;
 input City $ Pop70 Pop80;
 cards;
ANCHORAGE 48081 174431
ATLANTA 495039 425022
BOSTON 641071 562994
CHARLOTTE 241420 314447
CHICAGO 3369357 3005072
DALLAS 844401 904078
DENVER 514678 492365
DETROIT 1514063 1203339
MIAMI 334859 346865
PHILADELPHIA 1949996 1688210
SACRAMENTO 257105 275741
;run;

data cityrank;
 input rank city & $12. pop86:comma.;
 cards;
 1 NEW YORK  7,262,700
 2 LOS ANGELES  3,259,340
 3 CHICAGO  3,009,530
 4 HOUSTON  1,728,910
 5 PHILADELPHIA  1,642,900
 6 DETROIT  1,086,220
 7 SAN DIEGO  1,015,190
 8 DALLAS  1,003,520
 9 SAN ANTONIO  914,350
10 PHOENIX  894,070
;run;

/* Raw Data */

data mixedstyles;
 input ssn $ 1-11 @13 HireDAte:date7.  @21 Salary:comma6. Department:$9. Phone $;
 cards;
209-20-3721 07JAN78 41,983 SALES 2896
223-96-8933 03MAY86 27,356 EDUCATION 2344
232-18-3485 17AUG81 33,167 MARKETING 2674
251-25-9392 08SEP84 34,033 RESEARCH 2956
;run;


/* C18 */

/* Aprdata */

data z.aprbills;
 input LastName $8. @10 DateIn mmddyy8. +1 DateOut mmddyy8. +1 RoomRate 6. @35 EquipCost 6.;
 days=dateout-datein+1;
 RoomCharge=days*RoomRate;
 Total=roomcharge+equipcost;
 format datein dateout worddate12.;
 cards;
Akron    04/05/99 04/09/99 175.00 298.45
Brown    04/12/99 05/01/99 125.00 326.78
Carnes   04/27/99 04/29/99 125.00 174.24
Denison  04/11/99 04/12/99 175.00  87.41
Fields   04/15/99 04/22/99 175.00 378.96
Jamison  04/16/99 04/23/99 125.00 346.28
;run;


/* C19 */

data temp;
 input Lname $ 1-8 Fname $ 10-15;
 input Department $ 1-12 JobCode $ 15-19;
 input Salary comma10.;
 cards;
ABRAMS   THOMAS
MARKETING     SR01
$25,209.03
BARCLAY  ROBERT
EDUCATION     IN01
$24,435.71
COURTNEY MARK
PUBLICATIONS  TW01
$24,006.16
;run;


data fig19_37;
 input #1 Lname $ Fname $ /
    Department: $12. Salary: comma.;
 cards;
ABRMAS THOSMAS
SALES $25,209.03
BARCLAY ROBERT
MARKETING $29,180.36
COURTNEY MARK
PUBLICATIONS $24,006.16
;run;

data data97;
 input id $ @;
 do quarter=1 to 4;
    input sales:comma. @;
    output;
 end;
 cards;
0734 1,323.34 2,472.85 3,276.65 5,345.52
0943 1,908.34 2,560.38 3,472.09 5,290.86
1009 2,934.12 3,308.41 4,176.18 7,581.81
1043 1,295.38 5,980.28 8,876.84 6,345.94
1190 2,189.84 5,023.57 2,794.67 4,243.35
1382 3,456.34 2,065.83 3,139.08 6,503.49
1734 2,345.83 3,423.32 1,034.43 1,942.28
;run;


/* fig20.36 sales97 */

data z.sales97;
 infile cards missover;
 input id $ sales:comma. @;
    quarter=0;
 do while(sales ne .);
    quarter+1;
    output;
    input sales: comma.@;
 end;
 cards;
1824 1,323.34 2,472.85
1943 1,908.34
2046 1,423.52 1,673.46 3,276.65
2063 2,345.34 2,452.45 3,523.52 2,983.01
;run;



/* C20P634 : data97 */

1001 77,163.19 76,804.75 74,384.27
1002 76,612.93 81,456.34 82,063.97
1003 82,185.16 79,742.33





/* fig20.47 */
*---+----10---+----20---+----30---+----40;
1001 77,163.19 76,804.75 74,384.27
1002 76,612.93 81,456.34 82,063.97
1003 82,185.16 79,742.33

*---+----10---+----20---+----30---+----40;
1824 1,323.34 2,472.85 
1943 1,908.34 
2046 1,423.52 1,673.46 3,276.65 
2063 2,345.34 2,452.45 3,523.52 2,983.01 


[Completing the DO WHILE Loop]

/* C20P633 */ 
data sales97;
 infile data97 missover;
 input id $ sales: comma. @;
 quarter=0;
 do while (sales ne .);
   quarter+1;
   output;
   input sales : comma. @;
 end;
run;

data sales97;
 infile cards missover;
 input id $ sales: comma. @;
 quarter=0;
 do while (sales ne .);
   quarter+1;
   output;
   input sales : comma. @;
 end;
 cards;
1824 1,323.34 2,472.85 
1943 1,908.34 
2046 1,423.52 1,673.46 3,276.65 
2063 2,345.34 2,452.45 3,523.52 2,983.01 
run;

/* C21P652 [Creating One Observation per Detail Record] */

data people (drop=type);
        infile cards;
        retain Address;
        input type $1. @;
        if type='H' then input @3 address $15.;
        if type='P';
        input @3 Name $10. @13 Age 3. @16 Gender $1.;
cards;
H 321 S. MAIN ST
P MARY E    21 F
P WILLIAM M 23 M
P SUSAN K    3 F
H 324 S. MAIN ST
P THOMAS H  79 M
P WALTER S  46 M
P ALICE A   42 F
P MARYANN A 20 F
P JOHN S    16 M
H 325A S. MAIN
;run;


/* C21P662 */

data people (drop=type);
        infile census end=last;
        retain Address;
        input type $1. @;
        if type='H' then do;
            if _n_>1 then output;
            total=0;
            input address $ 3-17;
        end;
        else if type='P' then total+1;
        if last then output;
;run;

/* census data */
H 321 S. MAIN ST
P MARY E    21 F
P WILLIAM M 23 M
P SUSAN K    3 F
H 324 S. MAIN ST
P THOMAS H  79 M
P WALTER S  46 M
P ALICE A   42 F
P MARYANN A 20 F
P JOHN S    16 M
H 325A S. MAIN ST
P MARGO K   27 F
P WILLIAM R 27 M
P ROBERT W   1 M



/ * SAMPLE PRG */
data q.kdk;
 input (gender grade class idnum college x1-x30) (1.);
 cards;
13222244112522332243334232222225354
13232254312311111111111222222832442
13232444323233223333341334333033334
23222344313233222424342324333824454
14232545333334333354343423232233454
23222222324553322342344323432622434
13222222443244333234522243343.22234
13222224444423422144555442243322124
13222222224422222244433322224.22254
13222224224324442445544355542022424
13222121122221334425555435535622434
13222224224324424324343433243623234
14232332333222222222222222222422231
24222354113233133111231223333633322
23222335243354225344243443552322154
13232334323223244343244343332834354
13222222343242553255322345321223424
13222224225542333534223423424722344
13222243355341144235543435244623424
23222124233442534254354244355823423
13222233334442322443533534443822344
13222122423442433423332324425612324
13222222444225553445323424423222534
13222223235533435533225532432621334
13222335443422533424433244234622424
1312245532333343342423234333343331.
23122444323344131311331133341232442
13122232122211312222412222222622353
13122344323343333443333234553833442
13122444333222232233231243333232552
13122233211212221232232121221022342
13132245323323111324542234121831532
13132234323243122312442112443834553
23122232333433334323342333334733453
13122434321113232322242231111613443
13122445323343432322432243333634353
13122344312342133144133144211644353
13122333113213111311311111111011442
13122443222333322423432323233334443
13132334323343232332332333243834442
13132555323333232244333234452033432
23122444212333444321111113333734552
13132334341242223322253434545634421
13122333323323434333334332322832432
23122331212212111111332332333733344
23122442423322322323441342432822321
231223425232..331224441323...0..432
23122332212222332222321223332734444
23122455333321131333312244433632454
13122242223211313343343321111211443
12122232233344333443343333442632332
22122232212342322244343224124223333
12122234133233422433423244322311234
12122233432423.24252334252342813422
22122233223322333444444234445832522
12122241211111111114433111111714452
22122332323343232333233333432734442
2212243421333313132233222424382442.
12122233214223141232545322221.34443
22122434433334332423432333344023431
12122224222222222222354233222622442
12122133223233333333334233333434442
12122434323332232334443333244223431
22122344222322222323113232222324432
22122333322211133322213233232823333
22122323323433232413424444341724441
22122232213322233323333333322033344
22122422222433121211111113344714454
22122332222222121213433322232633333
22122222212222111112111114133623454
22122331112111121111213222111831454
121223333223331233.4323323233234134
22122334342443423312243332222723222
12122444323322222233422232333633321
12122344323342332334232233224323234
12222223322344332132323322323213323
22222211213311111234333222244434333
22222132311333243223352342232723453
22222222223344433223453223342733452
12222134224422222425422232222823432
12221222333322322323212222222842321
22222432323344221224454443331344442
12222553333153131333333224355235532
122223233323333233323..............
12222222222322332223333233333834442
12222434434443434344423344444233314
22222122111111333233353334332733242
22222122113222222244354315111915511
22222223223342333223243334343243333
12222451335412323322133422322412123
22222322212322111213452131111734532
22222333212222111212122221221722532
22222331212233221232323213333233342
22222332222333222222332223233023444
22222121111333111211551112111.22553
12222443212333234434323324333933331
11232231232242222334442334442033342
23222555213211111111355222121633432
14232234223212122333243223331033442
2422424432332334333432333222223342.
12121244313123233224513312343533442
22122142213222111211232111221033432
22222233222322332223243333232023452
23121245211112312214251144115435511
22121143211333211211122231133311222
24121343111311111311132231111311342
24121334423434221324342334244434421
12124334113343232233434423434634543
22122444225434133553334334441044432
22122323323333222322233333432734442
2212144422333423.34.243234333024452
22122224213232111214112213332755554
22122324324344232323434444241724431
22121424312311222321232113132211353
23224354332434434333233222333233543
2212232431333313122242222434382432.
22122332332322333233333232322033224
22122533323222111322212233233223333
22121555213322143322322225222624511
22221434322214333232232114231034354
23124344333333333323333323233733542
22122444223333233222213222222723542
22122444423233121311211213222213511
22121332323322333422433334332234442
22122141222222422224413324313033511
12121455112113122211311123441232443
12122222212211121211114214343244554
12121333333212222314433334222624343
12121344323422443422233442322233443
11111132121114144411454111111214154
11112121213323433311312233231831442
11112133112311111111333113111611432
11111321222154311111321115551751554
211132112244243543233..............
21113222222123223333333333235035442
11114121111143111113211112144021114
11114221314332211213422324445944511
11114222323343333332333333234023331
21112222323454433333443225442234231
11114222212323111211313311233022554
21113322333322333322333233333733333
21111242221132311143343224441045353
21112344323243433333323224342832442
21112343313343422311224334251041533
11112131113311111133312111111631551
21111141212435213153511235541853421
21113243211222322232432222222724331
21113333323245434333242223333744343
11113442324144214443241234444744442
11113133113323333332333322243021451
11113234223331333321333221111622532
11114323332334333312333343333933343
11113122333344231223331233343034252
21113232212122333112321233241733343
21113244322333322222232333232732333
11111342311154122334232542334053512
11112132324454555343233444341813452
11114111333333333333333333333133333
21111134223242223322322112141221453
21114331323421133243443221115035552
11112223413215243321433445251331554
11112333221234414344443435334035421
21211432324224111332412225341544532
2111144332443544543143433121523151.
21214332322424223331353222233232432
11112121111331121132331114144824553
21114434223212322222333322113023342
11212321223343211212452.21143621531
11114332222331213321432342234034454
21212222213214133222454444311842541
11114131113334233222323324145015411
23122131112313312233333323111832132
21114235323125122452351321412315213
21114333312123112221322112122744431
21114332424445323311333441244425441
21114232333333333332313333344245433
21114231221314113211542231131045523
21212244222335412233355332141344554
21212323222234223233443224131332343
21113121213212211321333222222733521
21111133143123152211355531155751253
21111151312214422221553321115234341
11211432123323113323454234443734552
21111232223111233212133211114632243
11111142213333224322343332144042443
21114222312114333312444224115224551
11111142223353332433434335244243531
1111411111211411131134311231124323.
111121233143333343243332221211....2
11212222223344133213352324333042553
2121233421242413223145433412191142.
2121134232443344433135424444153151.
21113122332223333332344.43231045354
11114144332233111255454335345054454
21111122223344212311433221132622343
11114142324353341311333434352734454
11111144313353332431453131342233452
21211145213241322422352225144824342
21112234312333211332331335331631552
11112144221445111321542323441255352
21212544324534212332444444442243541
11211111111151115511555111151015551
11112222222243222211233323332412342
11112322322233222222233333341321332
21111332223232222322332232233234331
21111231322341322422342434451232452
21111131322141525431213231141631431
21111122214332332321443335345732531
21112224223434342332434443234232432
2111223132234233331122222313322252.
21112122212222222222233222222121444
21112233323333322332313343234731534
11114424111111111111233131111013342
11111332221134312311442322241644443
21111442323344332321334333442243432
11114233333343333233333333332633334
21114234212223424111343424115225531
11114332123355334411242335554844544
21114232313344223321233222344245442
11114122113133133222244113335844442
11114121213512355215552355111251543
21114444334333222324423334242444444
11112144223344121311323233134221334
21111321213123312211143111122522342
11212122222222222222232223233623442
21112344222112222211312212211222332
21114232222133132234442113231854554
21214554333333324344453335435033552
21212232324323423231344234221233442
11111145325552111311255431151731152
21111232323224333322433221231621343
21114442444441324411343324221224353
11114331222234223233333333231733242
21113234222432111111131234131732443
21114233223223131323342223235733442
11112131213334413215221141151251552
21114211111122111135511113151625553
21112321222332212322312233131732431
21211111222343111213551113141613154
21114321334245322244342233235724353
14134455334443333423342333343.33542
21211422223431323322353321233033331
21212333211113111332442224222733442
21212432324424211232253322232642432
21212121332333113311453334233734443
21212233313343421333454333221745521
21211131211333422233354.22232021432
11211353332244113411453341251224453
11214133223333122322343344444244541
112111223311331111111..............
212111312113421112222..............
212111312313332222333..............
21211334223323233321333223223733331
11212131111122511211232121422.31442
11214144.23231515333455343131425531
21214142324333231323443333234733343
1121222222233311123234111.231614452
21211354444443241334331224441745521
11212111111133111111151113221713534
11211254331255112412123442454712553
21211332223444321321352213331144431
21211542322111533321334332211311531
11211232233222233233432334322223414
21211222213343221211353323341722232
21211113111111111111353122231031443
21212233322232323212343433343624421
21212121114354121.23452323455045532
11212332322234333342354323235631343
11212231321233414222253225335821352
21113132322344424341343322151731354
21113123321253222312112225242023454
11111121111134234111311111251334253
11114232232333111222233332112022332
11114334111121224121353345151035344
11114334423423222321322333332355552
11114222223233323223333233331933331
11122333432344322312323323221822414
11112133113344334223144354434055554
111131311222313.1555112114554733554
2121423423341313331335321544385553.
21214232213232233332233223332732352
11214221122212132222332212232223224
11212344433433433344333433343044332
21212244322354331311351331153223554
21214332314314112333353213311233442
21214233223234333323333323233734332
21214222324444333322344333243234442
11214132322342333322253334443011254
11214333322343333322253224441033354
21113141213454111331332114351723552
11214234112241122353351211151611554
112122331122322223323..............
21113222333444411333434444344744453
21214132113244222221243334441232454
21214332323333323233343333333432444
21213122112141222322333211441222511
1111423321223522222133333334104552.
21112132222233333332333333332733333
21114341323335511131142334332235531
21114233222224222311142322144633431
21114233222224222311142322144633431
21114344223222222344343223242244333
21114434332233223333343331332222433
21114333223333333112233213231.35353
21114222112121133131333333323.14353
21113332223325333333332232244723454
21113435232543553353231533245.43254
21114444323324434322333342332833453
12224242223333232332353343333833354
12224222213322321221342113244833332
12224132313132132122322122222722454
22224232223334322213343333333824342
22224334323244321313354233333633442
22224334323334233323444334332733442
22224434334344232414333324441834341
12224334311111111211111221111811554
12224121111215332.13454334341812353
12224333223433444222113233333833454
12224344444411333344413115111.34554
12224232222223233244443333322922232
13224245323222222254132333323212354
23224122222222222222231113333033344
13124344311231223111153312222822553
12224334333333332434233333333233334
12234332323333232323353333332833442
12224333333333333243533234233055554
12224132213233231333413222333823354
22224434223333333322243222233833332
22224323213332121312232212223623432
22224232322232222223333333222733342
22224223222233221333353223333732343
22224435313113121213454122111.34553
21213132222322233211212243141613413
11212254333224211311254342453.23422
11212534111111111331151111322122353
21211334322125112323452325245233332
11214442222343222221452224342634531
11214132112414112123332134244923453
11214222212244454342353334132023322
11214342213324231212142334233834353
11211112223334323232343443232642443
21212344333345222312423322443242432
11212122113334122322342233234744443
11212224223222111222253221111723443
11211442334443322323353334442934331
11214152122444321434343125151222322
11214111221233122121311112125734354
11214113215333333333353333133033433
11214121221315535233253215131255553
11214222223343323322353343342933332
11214244332322131232322222334833533
11212121213234111223342222233632444
11214143213343431323353113233831353
2121423133324211132244143444253452.
11214231221142111244152424441844443
112142443333131213333..............
21212343232324333322343332234232442
11212331222323222331133233223231454
11214222233344444333323334442642354
11214122223223233322313332222032332
2121434142444442441151512544424431.
112122222232511111213..............
1121233321222232321235323123383343.
21212442223212123332254333231631432
11214332212333333312351232135235432
11214231222232122.22423223334231343
11214241212431244332553234451711254
11214333334253333223313334445242114
11214233223232122221133323331831343
11214224323343333422443234244.44353
21214332322233422322353224231224221
11214131213223333321322231224333432
11214434233444413332444224442044441
13122222444444233344224554553833212
13132122223333232333333333333033342
13132151323333333333333333333615352
24122252322223422333432333344234421
13132342312421242332444344231634543
23121342223323122324233233344223431
1312233332233.242334221334241845552
13122231222222211111322222222223431
23122333223344222323432234222623542
23122232223333333333333232333233322
13122222333211122232355333334855553
13132335322233121333333223333.33.41
131324443133....1.12431113333232442
13122355111343322544333245333233253
23122232111111111111111111111711113
13132441334312322233544234222733454
23122455131233533134342332253234552
1312244424.122244424544424242624441
24122444222422422233332232333433343
13132343444343333323332323333633454
24122151111111111134111111111011354
13132434113333333334333333333433354
24222332323333221333143312334233321
1422234322332323323342332332382231.
14.42444312333332214342333342344334
13222342333222131324451443132232352
14222112222225333333122222222033354
13222411313442233222332234231734553
24222342214423444355554.34432232452
232221242122222222334..............
14134555324434132422441344441544531
1413415532223332233154333333323322.
14232243322211211223322212222822233
13232442232133222324154333331933254
24222342113312322211433332331734444
24222332312222112211131123233222553
14232455322355111111555145453035554
14222145212133322122111231551844554
14132324423233422422442223243.2341.
14222424333343121112141234441423451
141222353553235332332..............
14222243223333333333353333333733253
141224443223334443243..............
14122334333233433332332232333334442
24122444212322242123311232342023521
24122433213333333323432233333333343
24122444323321332122243322222.23333
14142343433344334344334434334033334
14132354224324532332554343243234251
24122444313413332113321233322233432
24122555432343222213334333333825552
2412244432442213231343232222283351.
14132312334343555333434343334743113
14122444212233223233432234333333331
14122443322222212312333223221823254
24222434213343334323331334443834331
24222343323333233324441333332733443
24222442214244244311442435552044441
24122444434323334443331342232032321
14132433211143222223221223343633434
24122233212311311311121111111211112
24122331213422231223331233321023411
24122433322222332323343222222224551
24232323211334221111141335251744453
14122333221133111343211233333233553
1112123212132313212222322212321231.
13121345322333233311332113333234442
13131355413332333332233313233232552
13121343332334323332343322233534431
23121332243243324333324332343233552
13131333334243335324333312333234552
23121232324444233323444324144343431
13121333324233425511333313243223552
23121322323333332311333343333732432
23121244323433433322232223333232432
23121343332313233421333232222222222
231213423234332334442..............
23121123321133111345133334444233334
23121342324332432333424342342243552
13121334332533243533432342333233552
13131333234231342333324324332223552
23121333234333232323433233331233431
23121333213223333412232335222633552
23121344113255133114151111153013552
24121244212234411214441114244624532
23121333222212122111432223233833334
1312143442242422132434223423433242.
23121433322332433333333333333233334
2312123321112132221222221114322222.
1313114531313144433131444113373241.
23221233323233223334333324333633332
23221333333333333333333333333633331
13231445334434331424443344244624511
13231243213223334243322322134243324
2322155544444241123515433245564351.
13221555335553334333335333553833554
13221322312333233234444333242933441
13231333333423234323434323234232331
232214413231.243333145345........1.
13221333333333332333354323333233331
23231455333221312312453333344833432
23221344223322333322454223334233242
2322135433343343221144223323223352.
23221333313333333333344443333233333
23221434324332322113242224331722454
232211453242455553555342433..735352
23221334333333433323354333333233542
23221234222233232322433322332233431
23221222212222322234242223244234452
23231324322222322312243342242733431
13221112111333444333311131131644454
13221444223111222223252331111212322
13231333333333222333343333333233442
23221333333344333322354323333233441
13231222222222222222233222222.22333
23224234242424242424233345454354324
23224234234523452345223453345212344
23224345234345455545512323434.12342
23224345434343434545454545432843224
23224434545454323454534543454222222
23224232232222345433313544333213352
23224234212342344334422113455411432
23224244233444233444423443223223224
23224232255434332233323454344432222
23224543322111223345554321234443222
23224234234543234545522222222234322
23224543543543543543554345434253222
13234234234323432343223432343234322
13234545454545555555534545454255122
13234234344444444434434545454254324
13234333333333333454554345454243452
13234555454545454545443535454253213
13224234345434434434524343535224252
13234555545434543454523134542244324
13234345555555554545454543454634324
13234234343543234543454444554654324
13234345434354323454323454323654324
13234234345432134543543454345254344
13224345345435345434534543213254324
13224345345345345345345345235443434
23124544344344545454434435454654544
13124455345432233243534545454253324
13124555555555555555555555555645444
23124345345454545454555555555655552
23124345345444454545423454545254324
23124123343545545545424445454254324
23124234345454545455534545454634544
23124454545454543454434545454843324
23124454345454545454534333455542324
23124555555555555555545454545854333
23124123334545434454523344545654322
23124123234555554445523445555243324
13124123323454545454512344555154322
13134121342324124233353232415112242
13134123.24231211542412223351114422
131341122311342323433543332111....2
13134234234322234124511213425111322
13134245213423333123311113432123412
13134124125235123233312311535543232
13134124152253442342454353524915543
13134112324543454443523534253054312
13134555555555434543454323454412354
1313412345543212345444.............
13134123344312355444512343434624322
13134123234345455545423334545612343
22123321223213322312322342242223541
22123222223322332233333232222722332
22123223323333332312443343331733332
22123333323322121312333233222723542
22123221113211111311325233232712244
22123134113211111111142221122222441
22123222212122111212132222222211112
22123124331133112222331333331234511
12123144333333333222323233333233342
22123444333333332313222233333733343
22123123112222212313332223231712232
22123243332244332314413334242733543
22123152111321332325413233232.33432
22123444323343323422343342334033453
22123344323432332424324353342734433
22123333223232233323333343333033431
2212311122222222221322222222273442.
22123333333333232332333233333733443
22123241311134133112413143331024453
22123233324433444332444344242543432
23123342323233232333.32343232233431
23123332222223332333332233333733432
23123232222342221223432333331732442
23123242222233333322333353344234552
22223134212122323211332222111032322
22223355223322312321333222111033352
222232342233232432434..............
222233323424243423323..............
2222312223234334.232322223111033352
22223355223322312321322222111033352
22223331212322121212144242131021411
22223341212144111211153233353054431
22223233332323333243412221122212252
22223232223233322233353232233031142
22223223333432222222343223233723432
22223121113322311213254434334733242
22223121113322311213233322111033352
22223132212212333233352222211711454
232233542133123343233..............
2222312311222213112234333....7.....
24233344213244233423432333332435411
11113242321134122223332223234722232
11124132312313211111153341211055553
13231333333333433.33243323331833553
11113342111111311333232334111734554
2222211111111.222213232213233221342
22123121212122323311343333332723423
21111242322131322311332121135231443
21113233222332211343343323332721454
21212232223313333444343311111023354
22221334213244211224212224343233553
22221444322212231213253332232732342
11112433112323111221432122233212453
14131445432344241434442334443044511
11111233222332111121433221331033442
22221232333333121314141223333233332
11211232323232223322443233332024342
21112321224323344222431333234642431
2111222221321432323231123221173151.
21211233333343333332353334342032344
212113422124.3223233443234333033341
21112232212344312244543224142044432
24123343224433232333441333333234442
11212444223233222313242333445331343
11212422333424241314254225535042553
2111223432214211332231133435223332.
11111333322122221233322223221224444
11212444223555111211553321251855553
11111122233325.33222244344232243332
11211142214421444433551234111555553
24121445423344222424334544442734441
13231133222333323333343322233823452
24121332323333222323442224343134421
2412124221432244332323322222262331.
1111324432443421243233233424374442.
24121454324443342323442343343034443
24122244333244222222354224333833552
121244443243113224334..............
11224444434352244345443432443024332
12224322222222233333343333334833343
1222444532323422233245445322393451.
22122143222333332444434324433843332
14124333455552325323334332334855331
22123145112133222411231111332722511
13124324323344121323342343423224331
23224334323333232322323323343623431
13124521452225111114112.12451312124
14134444322322332423443344221634432
12124323222222131212433334232223532
23222343334433311333233433333232332
12221223222333233333223323322632233
23222344332333111112223222233222253
23222223322322322323322333233522332
23222334222222222222233312222.22232
24222223332333233232333232232222232
23221334332323333222222233433.33254
14241555554333232344433413333233332
23221233334323333232333232333233232
22221323222232233222333323332222332
2324223222322232232223333232.2322.
24221223223233311111212322232622322
22222444222232222223323323332412254
11211333332222211111122111112222214
24121445443333433133233443334.22331
23221344433343433343333344333533322
22221112232223223322312212222322122
24231133112222233233312221212222123
22222322223232323222112121323621132
13134355333333111222211221112822122
22222333111122211211111111221.11332
12121142224343444421333444442233424
121211452243323444333..............
2212144421232223321454212133373351.
12121222212222321222222233333733343
12121223221212433343443333321032232
22121434322355232312442335254725532
22121111112333111113111212312024554
22121232222332111222243232121022243
2212143323333323233333233233363332.
221213233122332333113..............
22121424213222322211142233231712332
22121324223211121223332133111311443
22121224322233122333432222322233442
22121122112222131313333222222632452
22121131112211211233232324323233234
22121244224323555423333212333124442
121211112223344332232..............
12121223333333333333333333333833334
22121222313234433222343432333734431
12121342323343131311233333333033342
22121253223233111311333241133122454
22121332322313122312322333233733432
22121344323242232222242334242534451
22221334322344333244333222443722332
22221344323232232322343334333633432
22221232223342223222432324443234443
22221355333233431311344332333734332
22221334322333232223343332333233332
22221322313444333323444224344844444
12221111111111111111111111111011114
12221333232333432323333323233033234
22221332323222231311343332332333532
12221555111452311115232415151631452
2222132422333223.332223233333834531
22221322212222422331133454332733432
12221111111111111111111111111111111
12221432223234213211343212322821554
22231334322222111212232343343734533
12221435223344532114414454442235542
22221244323.2...1423443224322723432
22221132212233111214253131111212533
21221432311311111124111144111311114
22221132324233231313252323333343442
12221222231111111213233312222623354
12221322313121534334353233222734553
12221144222222222222244321322022254
12124341324333144334441223333733544
22124445313.43321312411445453724553
12124234211323122424343241232012322
22124231.23322132113233333335055554
12124111111111111111311111111811354
12124332223333333333333333333833334
12124252124222322313333233223822322
12124222222312211223122332222533331
1213432322222232222133333222173355.
12124243223233233323421323332833442
12124444533143413311414342443833453
12124434313355555555554321345555552
12124233222222133333333333333833332
22124444343334433222244434433833322
12124434433344234333233443222833321
12124332222332233311344333422832221
22124434332344342323333224443534334
12124231112223311332233322111843343
12134444211133333311222333333333354
221242333233332333233..............
22124334222222221313333333333733333
12124121221222111222222322221811224
22124221222111334223432231233233531
12224113222132111112111122111721214
23233122223223111121112322212712553
23223223222332221322222122112822233
13223344222321433211142211111713554
23223333222222222222243332333733354
13223444342333221223333333333733331
13223333433333333333333333333033331
13223333333333111133333333333833332
23223333233333311333333323333233332
23223322333344322222144333322.33333
132233332334.2211123243334333233443
23233222222222323124132222222034454
13223333322222122312232232222633443
23223333333333111222233333333233332
23223333333234333333333333333733444
13223155115111111515151111111211554
23223333332333331314333333333.33352
23123233333333221223332222222733232
23223432333433121314353323334733331
13223444123322233221142224222711542
13133245212333111313152314224745553
13133334213332111313151222333.43453
13123221212133111322132233333233431
23123233221222121212231333232423343
23123241233333434324422333332734443
13123141323433343223123333333732443
13123332324333424324433443333523342
13133343222121333234123131332011452
23123344333322442444232233344733443
23123232312244342344242322244724442
23123143233233233322333333433724444
2312324433332222233233333111171...2
131333422134332222233..............
23123244232222222332222212244733554
23123222222222223223332222222733343
23123242223222111222342122232823342
13133233232434234342333434342021332
13123242212322222233242332243.14544
23123454332333222312333333443733332
23123434222342122311142234242324431
23123142213222111322121143332733342
2312315521333324.243532543333723332
23123333213133133222321313233733542
23123334332333222322232333233723442
131233342112122221121..............
23123134122333222223333232331733332
13133233323433222322343334234734432
13133255323233333322132244443734552
13223444332222111323343223332233353
24222344233432333224242332222325552
12122443334344342323323334442633352
14144434324344334234343543223724331
24123344221311111121141112114014411
2412343214234325324253234354301233.
1222311121.133333123133311553733334
23223332312233213323353333333733431
12121334333333321311353233333133334
14133134121211111111111211111011254
12123131111131111111111111111.11114
23221334313343333222342223233234341
21111333324434444441244341222221411
2212334421243212132244332333373343.
22123412112121233233131122221732333
112122332232233222223..............
221232312333333333333..............
22223322223323333222333222333722331
22121344223324223422433423342012332
23223232223333433323422333333723232
23123141112212112111333131211711333
24123332222332333412132313244733453
1313344411213311132333111333373313.
23133222212321133222432231111712522
24223332233332333344432332332732553
24223341223433332324442333333233442
122222213222333312442533211440....4
131332322322232322223..............
13223333222232111233453233331725321
24122334324433211324422444323534431
24133355212344221313331344343635411
24123342323422333312333.31333233334
21113222222232222233222322244233354
24223133111131111111.31113333833532
24223231211111111121231113331233553
23223232323333333333334334433.23324
;run;


data q.kdk1;
 set q.kdk;
 y1=mean(of x1-x3);
 y2=mean(x4,x5,x13,x16,x18);
 y3=mean(x8,x9,x21,x22,x23,x24,x26,x27);
 y4=x7;
 y5=mean(x14,x15);
 y6=mean(of x10-x12);
 y7=x6;
 y8=mean(x19,x20);
 y9=x17;
 y10=x28;
 y11=x29;
run;



OPTIONS PS=55 LS=78 NODATE PAGENO=1;
proc FREQ DATA=Q.kdk1;
     TABLES gender grade class idnum college;
run;


TITLE3 'CORRELATION MATRIX FOR Y1 - Y11   ';
PROC CORR DATA=Q.kdk1 NOMISS;
     VAR Y1 - Y11;
     RUN;
title3;

# word cloud : global substitution
res<-str_replace_all(place,"[^[:alpha:]]","")
res<-res[res!=""]
res<-gsub("blog","",res)
res<-gsub("com","",res)
res<-gsub("daum","",res)
res<-gsub("km","",res)
res<-gsub("me","",res)
res<-gsub("naver","",res)
res<-gsub("°¡º¼¸¸ÇÑ°÷","",res)
res<-gsub("°¡À»","",res)
res<-gsub("°Å¸®","",res)
res<-gsub("°È±â","",res)
res<-gsub("°Ë»ö","",res)
res<-gsub("°ø¿ø","",res)
res<-gsub("°ü±¤","",res)
res<-gsub("±¸°æ","",res)
res<-gsub("±Ù±³","",res)
res<-gsub("³ªµéÀÌ","",res)
res<-gsub("´Üdz","",res)
res<-gsub("µ¥ÀÌÆ®","",res)
res<-gsub("µµ½Ã","",res)
res<-gsub("¸¶À»","",res)
res<-gsub("¸í¼Ò","",res)
res<-gsub("¹®È­","",res)
res<-gsub("º¢²É","",res)
res<-gsub("ºí·Î±×","",res)
res<-gsub("»çÁø","",res)
res<-gsub("¼­¿ï","",res)
res<-gsub("¼Ò°³","",res)
res<-gsub("½Ã°£","",res)
res<-gsub("¾È³ç","",res)
res<-gsub("¾ß°æ","",res)
res<-gsub("¾àµµ","",res)
res<-gsub("¿©Çà","",res)
res<-gsub("¿À´Ã","",res)
res<-gsub("¿äÇÑ","",res)
res<-gsub("À¯¸í","",res)
res<-gsub("À̾߱â","",res)
res<-gsub("ÁÁÀº°÷","",res)
res<-gsub("ÁÖ¸»","",res)
res<-gsub("̵̧","",res)
res<-gsub("ÃàÁ¦","",res)
res<-gsub("̉ȍ","",res)
res<-gsub("ÄÚ½º","",res)
res<-gsub("ÇÏ°Ô","",res)
res<-gsub("Çູ","",res)



±ÇÇõÁ¦(2016), SAS µ¥ÀÌÅͺм®°ú Çؼ®(text), ¹Ú¿µ»ç
±ÇÇõÁ¦(2016), R µ¥ÀÌÅͺм®°ú Çؼ®, ¹Ú¿µ»ç
±ÇÇõÁ¦(2017), °æÁ¦°æ¿µ¼öÇÐ, ÁöÇÊ
cf) differential and difference equations (the second-order)
cf) simultaneous differential and difference equations

[Statistics]
Casella,G. and R.L.Berger(2002), Statistical Inference, 2e
DeGroot,M.H. and M.J.Schervish(2012), Probability and Statistics 4e
cf) Mathematical Statistics

[Econometrics]
Greene,W.H.(2018), Econometric Analysis, 8e
Wooldridge, J. M.(2016), Econometric Analysis of Cross Section and Panel Data, 2e
Cameron,A.C. and P.K.Trivedi(2005), Microeconometrics: Methods and Application
Davidson,R. and J.G.MacKinnon(2004), Econometric Theory and Methods
Hayashi,F(2000), Econometrics
Ruud,P.A.(2000), An Introduction to Classical Econometric Theory
Verbeek,M.(2008), A Guide to Modern Econometrics, 3e
Theil,H.(1971), Principles of Econometrics
Amemiya,T.(1985), Advanced Econometrics
Maddala,G.S.(1983), Limited-Dependent and Qualitative Variables in Econometrics

[Financial Time-Series]
Hamilton,J.D.(1994), Time Series Analysis
Luetkepohl,H.(2006), New Introduction to Multiple Time Series Analysis
Brockwell,P.J. and R.A.Davis(2006), Time Series: Theory and Methods, 2e

[Computational Finance and Risk Management]
Tsay, R. S.(2010), Analysis of Financial Time Series

[Mathematics]
_(Linear Algebra)
Hadley,G.(1961), Linar Algebra, 
cf) Strang ~

_(Linear Programming)
Hadley.G.(1962), Linear Programming(6th printing:1972)

_(Nonlinear and Dynamic Programming)
Hadley,G.(1972), Nonlinear and Dynamic Programming
Chiang,A.(1992), Elements of Dynamic Optimization
cf) Calculus of Variations, Optimal Control Theory

_(Optimal Control Theory)
Intriligator,M.D.(1971), Mathematical Optimization and Economic Theory 
Hadley,G. and M.Kemp(1971), Variational Methods in Economics

_(Mathematical Economics and Applications)
Dorfman,R., P.A.Samuelson and R.Solow(1958), Linear Programming and Economic Analysis, (14th pr.1981)
Samuelson,P.A.(1947), Foundations of Economic Analysis, (6th pr. 1961)
Sargent,T.(1987), Dynamic Macroeconomic Theory  <- Dynamic Programming
Silberberg,E.(1990), The Structure of Economics: A Mathematical Analysis, 2e.
Nikaido,H.(1970), Introduction to Sets and Mapping in Modern Economics(3rd printing:1975)
Nikaido,H.(1968), Convex Structures and Economic Theory, (ref: Linear Systems->I/O Analysis)
cf) Takayama,A.(1994), Analytical Methods in Economics
cf) Takayama,A.(1985), Mathematical Economics

_(Expanded/Extended: Meta-Mathematics)
±èÇÐÀº(2006), Á¤ÇÕ°æÁ¦ÀÌ·Ð(Coherence Theory of Economics)
±èÇÐÀº(2020), ÀÚÀ¯¿Í Çå¹ýÀÇ ¿ø¸® I: ÀÚÀ¯ÀÇ ¿ø¸®
cf) II: ¹ÎÁÖÀÇ ¿ø¸®, III: Çå¹ýÀÇ ¿ø¸®, IV:¿ø¸®ÀÇ ½Çõ