/* Lesson 13-07 */
 /*    File Name = les1307.sas  02/01/18   */

options nocenter linesize=78 pagesize=30;
proc printto print = 'Kougi/les1307_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 freq data=gakusei;
  tables shintyou;
  format shintyou clshint.;
run;

proc freq data=gakusei;
  tables sex*shintyou;
  format shintyou clshint.;
run;

proc sort data=gakusei;
  by sex;
run;
proc freq data=gakusei;
  tables shintyou;
  format shintyou clshint.;
  by sex;
run;