proc import
    datafile="C:\Users\joma3299\Downloads\survey.xls"
    out=survey
    dbms=xls
    replace
    ;
run;


proc freq data=survey noprint;
tables gender ;
run;

data survey;
set survey;
    new1=input(ColGPA, 12.);
    new2=input(HSGPA, 12.);
    new3=input(height, 12.);
    drop age ColGPA HSGPA height;
    rename new1=ColGPA;
    rename new2=HSGPA;
    rename new3=height;
run;

proc glm data = survey;
class gender;
model ColGPA = gender;
means gender / hovtest=levene(type=square);
run;


proc means data=survey;
class gender;
where ColGPA > 3;
drop=_HSGPA_ _height_);
run;