/* Lesson 12-03 */
 /*    File Name = les1203.sas  01/11/22   */

options nocenter linesize=78 pagesize=30;
options locale='en_US';
/* options locale='ja_JP'; */
proc printto print = 'StatM21/les1203-Results.txt' new;

data gakusei;
  infile 'StatM21/StudAll21d.csv'
    firstobs=9 dlm=',' dsd missover 
    encoding=sjis termstr=crlf;
  input sex $ shintyou taijyuu kyoui 
        jitaku : $10. kodukai carryer $ tsuuwa;

if sex=" " or shintyou="." or taijyuu="." then delete;

proc format;
  value cl_shin  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 cl_shin.;
run;