/* Lesson 12-02 */
 /*    File Name = les1202.sas  01/07/20   */

options nocenter linesize=78 pagesize=35;
options locale='en_US';
/* options locale='ja_JP'; */
proc printto print = 'Kougi19/les1202-Results.txt' new;

data gakusei;
  infile 'Kougi19/all19b.csv'
    firstobs=2 dlm=',' dsd missover 
    encoding=sjis termstr=crlf;
  input sex $ shintyou taijyuu kyoui 
        jitaku $ kodukai carryer $ tsuuwa;

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

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

title '*** データ全体を対象に ***';
proc freq data=gakusei;
  table sex;
run;
proc means data=gakusei;
  var shintyou taijyuu; 
run;
ods listing;
ods graphics off;
proc univariate data=gakusei plot;
  var shintyou taijyuu; 
run;

/* 性別ごとに(方法1) */
title '*** 性別ごとに平均値(方法1) ***';
proc means data=gakusei;
  where sex="M";
  var shintyou taijyuu; 
run;
proc means data=gakusei;
  where sex="F";
  var shintyou taijyuu; 
run;

/* 性別ごとに(方法2) */
title '*** 性別ごとに平均値(方法2) ***';
proc sort data=gakusei;
  by sex;
run;
proc means data=gakusei;
  var shintyou taijyuu; 
  by sex;
run;
ods listing;
ods graphics off;
proc univariate data=gakusei plot;
  var shintyou taijyuu; 
  by sex;
run;

/* 性別ごとにヒストグラム(方法1) */
title ' *** 性別ごとにヒストグラム(方法1) ***';
proc chart data=gakusei;
  hbar shintyou taijyuu;
  by sex;
run;

/* 性別ごとにヒストグラム(方法2) */
title '*** 性別ごとにヒストグラム(方法2) ***';
proc chart data=gakusei;
  hbar shintyou taijyuu/group=sex;
run;