/* Lesson 13-02 */
 /*    File Name = les1302.sas  01/14/20   */

options nocenter linesize=78 pagesize=30;
options locale='en_US';
/* options locale='ja_JP'; */
proc printto print = 'Kougi19/les1302-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 shintyou="." or taijyuu="." or kyoui="." then delete; 

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

proc means data=gakusei;
run;

proc fastclus data=gakusei out=outclust maxclusters=2; 
   var shintyou taijyuu kyoui;
run;

proc plot data=outclust;
   plot shintyou*taijyuu=cluster;
   plot taijyuu*kyoui=cluster;
   plot kyoui*shintyou=cluster;
run;

proc print data=outclust(obs=20);
run;

/* Output to text file */
data _null_;
  set outclust;
  file 'Kougi19/les1302-OutValue.txt';
  put shintyou taijyuu kyoui cluster distance; 
run;

/* Output to CSV file */
PROC EXPORT DATA=outclust
            OUTFILE= "Kougi19/les1302-OutCSV.csv"
            DBMS=CSV REPLACE;
RUN;