/* Lesson 13-08 */
 /*    File Name = les1308.sas  02/01/18   */

options nocenter linesize=78 pagesize=30;
proc printto print = 'Kougi/les1308_Results.txt' new;

data gakusei;
  infile 'Kougi/all08c_sjis.csv'
    firstobs=2 dlm=',';
  input sex $ shintyou taijyuu kyoui 
        jitaku $ kodukai carryer $ tsuuwa;

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";

proc format;
  value clshint  low-<150='   -149'
                 150-<160='150-159'
                 160-<170='160-169'
                 170-<180='170-179'
                 180-high='180-   '
                 other   ='missing';
run;

proc print data=gakusei(obs=5);
run;

proc tabulate data=gakusei;
  class sex jitaku;
  var kodukai;
  tables kodukai*(n mean std),sex*jitaku;
run;

proc tabulate data=gakusei;
  class shintyou sex;
  var taijyuu;
  tables taijyuu*(n mean std),shintyou*sex;
  format shintyou clshint.;
run;